Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Consider the following database instance. Table name: Students  Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen   Table name: Courses  Primary key: cid cid cname 1 ICS 2 Finance   Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1   5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’);     INSERT INTO Students VALUES (6, ‘Ellen’);     INSERT INTO Register VALUES (1, 2);     INSERT INTO Courses VALUES (5, ‘Systems’);     INSERT INTO Register VALUES (6, 5);     INSERT INTO Register VALUES (3, 5); When I do the insert into I get: ERROR 1054 (42S22): Unknown column '‘Ellen’' in 'field list'

Consider the following database instance. Table name: Students  Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen   Table name: Courses  Primary key: cid cid cname 1 ICS 2 Finance   Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1   5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’);     INSERT INTO Students VALUES (6, ‘Ellen’);     INSERT INTO Register VALUES (1, 2);     INSERT INTO Courses VALUES (5, ‘Systems’);     INSERT INTO Register VALUES (6, 5);     INSERT INTO Register VALUES (3, 5); When I do the insert into I get: ERROR 1054 (42S22): Unknown column '‘Ellen’' in 'field list'

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Consider the following database instance.

Table name: Students  Primary key: sid

Sid

sname

7

Ricky

2

Ellen

6

MaryLou

4

Ellen

 

Table name: Courses  Primary key: cid

cid

cname

1

ICS

2

Finance

 

Table name: Register Primary key: sid,cid

Foreign key: sid references Students(sid)

Foreign key: cid references Courses(cid)

sid

cid

7

2

2

2

7

1

4

1

 

5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why.

  1. INSERT INTO Students VALUES (3, ‘Ellen’);

 

 

  1. INSERT INTO Students VALUES (6, ‘Ellen’);

 

 

  1. INSERT INTO Register VALUES (1, 2);

 

 

  1. INSERT INTO Courses VALUES (5, ‘Systems’);

 

 

  1. INSERT INTO Register VALUES (6, 5);

 

 

  1. INSERT INTO Register VALUES (3, 5);

When I do the insert into I get: ERROR 1054 (42S22): Unknown column '‘Ellen’' in 'field list'

Expert Solution
Step 1

You question is regarding the error you are getting and the queries. Here is the explanation:

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS