Online worksheet ยท 4 of 4

Relationships avoid repeated inconsistent copies - Online practice 4

Read the information, then answer the questions. An adult may read the instructions aloud. Show your working where asked.

Read before answering

Invented tables: Students(ID,Name): (104,'Alex'), (204,'Alex'). Courses(ID,Title): (304,'Robotics'), (404,'Art'). Enrolments(StudentID,CourseID): (104,304), (204,404). Keys identify records; names and titles are display fields. Rename course 304 to 'Robotics lab' without replacing its ID.

Worksheet preview

This exercise is included in the paid course. Full-course fee: GBP 200.00 once. Register and enrol to complete all course exercises and download the course PDFs. Access begins after payment is confirmed.

Register and enrol

Already registered? Sign in