Question (C3): (3 marks) Below is a database with 2 tables - Lecturer, Student: Student table: primary key = Stud_Num, f
Posted: Sun May 15, 2022 2:11 pm
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 111 1339 Exiter Amy 3 123 1340 Splitter Linus 2 123 1341 Miler Joan 1 134 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-1234553 12 The above database contains an error in the data. Identify and describe this error.