Page 1 of 1
123 Question (C3): (3 marks) Below is a database with 2 tables - Lecturer, Student: Student table: primary key = Stud_Nu
Posted: Sun May 15, 2022 2:01 pm
by 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 67 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.