Question: Question (C3): (3 marks) Below is a database with 2 tables - Lecturer, Student: Student table: primary key = Stud_Num, foreign key = Lect_num Student_Num

Question (C3): (3 marks) Below is a database with

Question (C3): (3 marks) Below is a database with 2 tables - Lecturer, Student: Student table: primary key = Stud_Num, foreign key = Lect_num Student_Num Stud_lastname Stud_firstname Year Lect_Num 1336 Hammer John 1 123 1337 Thunder Mary 1 111 1338 Thistle Cissy 2 1339 Exiter Amy 3 123 1340 Splitter Linus 2 123 1341 Miler Joan 1 134 111 Lecturer table: primary key = Lect_Num, no foreign key Lect_Num Department lect_phone grade 111 Maths 61-532-234156 2 123 Chemistry 62-333-123455 3 12 The above database contains an error in the data. Identify and describe this error

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!