Question 1

Kaplan Cooking Academy runs cooking classes for a variety of Asia cuisine, such as Indian, Indonesian, Chinese, etc. The client can book a course of 12 lessons which are offered on weekdays only. Each course is for the cuisine of a particular type, such as “Chinese cuisine for beginners” or “Indian cuisine for junior chefs”. There are many courses for each type of cuisine and each course can have many classes.

When a client contacts the school, the course consultant verifies if the client is an existing or new student. A new client is required to be a registered student at the school and their details are recorded. Students can book more than one course at a time. An attendance list is prepared for each class and the client needs to take attendance for each class. Full attendance is required before the school issues “Certificates of Attendance” for the cooking course.

Question 2

The following table shows details of the student’s marks for their respective modules for the semester.

• Based on Table 1, write down the unnormalized form.
• Identify the repeating group of attributes and transform part (i) into tables that are in 1 st Normal form.
•  Identify any partial dependencies in part (ii) and transform them into tables that are in the 2nd Normal Form.
• Identify any transitive dependencies in part (iii) and transform them into tables that are in the 3rd Normal Form.