123 Question (C3): (3 marks) Below is a database with 2 tables - Lecturer, Student: Student table: primary key = Stud_Nu

[answerhappygod]

123 Question C3 3 Marks Below Is A Database With 2 Tables Lecturer Student Student Table Primary Key Stud Nu 1 (37.84 KiB) Viewed 66 times

123 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 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-123455 3 12 The above database contains an error in the data. Identify and describe this error.