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.

If you are searching for an online assignment help provider in Singapore then stop searching here! We are the leading provider of academic writing services in Singapore and have helped thousands of students achieve their academic goals. At Myassignmenthelp.sg, we understand that students often struggle with balancing their academic workload with other commitments, such as work and family. That’s why we offer a convenient pay-to-do-assignment service that allows you to delegate your assignments to our expert writers. So why wait? Contact us today and take the first step toward academic success!