Question 1

Draw an Entity Relationship Diagram (ERD) for the following case study:

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 for 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.Marketing Research and Data Analysis

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 1st 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.

Question 3

Using any dialect of SQL, please complete the following SEVEN (7) parts:

1. Draw an entity-relationship diagram of the identified tables (3NF) in Question 2.
2. Using the CREATE TABLE in any dialect of SQL, create the corresponding SQL tables. Indicate the primary key, foreign keys, column names, constraints, etc.
3. Insert (at least) 10 sample rows for each identified table.
4. List all the students by lecturer (sorted by lecturer).
5. List student name, module name, and grade sorted by student name.
6.  List lecturer group by Department.
7. List all students who scored ‘HD’ for their module.

Tags: assignmenthelpaustralia, assignmenthelpermalaysia, assignmentmaker, assignmentwriter, assignmentwritingservices, australia, bhfyp, box, collegeassignment, collegestudents, confidentialassignment, dissertationhelp, education, essays, exam, exams, examseason, examstress, homeworkhelper, homeworkhelpers, java, math, motivation, onassignment, OnlineAssignmentHelp, research, statistics, studenthelp, universities, writingservices