Page 1 of 1

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
by answerhappygod
Question C3 3 Marks Below Is A Database With 2 Tables Lecturer Student Student Table Primary Key Stud Num F 1
Question C3 3 Marks Below Is A Database With 2 Tables Lecturer Student Student Table Primary Key Stud Num F 1 (49.1 KiB) Viewed 50 times
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.