Convert the eer diagram from task logical data model

MACQUARIE UNIVERSITY COLLEGE

You have established a Music Academy to train people to perform in the symphony orchestra. The revenue of your business is generated from teaching different musical instruments. You have decided to have a website (www.yourfirstnameMusicAcademy.com) for marketing and enrolling purpose. Your small operational team decided to automate all the business processes. For the automated web application to run, you need an underlying database that can cater for the relevant data. You want to develop a database for your business to support the following business rules:

- The database needs to store information about trainees such as unique identifier, first name, last name, address (including street number, street name, suburb, postcode and state), date-of-birth, phone number, and email address. There are two types of trainees, registered trainees, and guest trainees. Registered trainees are those who book for each term and attend training lessons, whereas guest trainees do not need to book a course and only attend practice lessons when there are not enough trainees available for the stage performance. For registered trainees, register date is recorded.

a particular timetable is created for one course. A trainer may be assigned to different timetables. Yet, a timetable is generated for one trainer.

- Trainees can make an enquiry to get information about courses. When a trainee enquiries about a course, the date of enquiry must be stored.

- A unique identifier is needed for payment. Other properties such as payment amount, payment date, payment time and payment note are also recorded. Each payment is made for one booking. The payment could be made in several instalments.

Note 2: The EER diagram should specify the completeness (total/partial) and disjointness (disjoint/overlap) inheritance constraints on the generalization/specialization. Students need to write clearly the inheritance type on the diagram.

Task 2- LDM Diagram (25 marks)

Answer the following questions
1.Which normal form is the following table in? Why?

2.In steps, transfer the table to 3rd normalised form (i.e., from 1st normal form to 2nd normal form to the 3rd normal form)
3.In each normal form, show the tables, highlight the Primary Keys and the Foreign keys.

This is an individual task and NOT a hurdle assessment.

HOW TO REPRESENT YOUR WORK

• On iLearn there is a template (named
WCOM1350_DB_Modeling_TEMPLATE_StudentName_StudentID.docx)
• Download the template and save it to your computer
• Rename the file to remove the word “TEMPLATE” and replace StudentName with your own name and StudentID with your own ID.

Submit your assignment to the submission link on iLearn prior to the deadline.

If you submit after the due date, your submission will be counted as a late submission and penalties will apply (see Late Submissions section below).

(iii) You must attach the screenshot AND the file containing your submission.

(iv) The email must be received by the Senior Teacher before the submission deadline. Please note that if your email is received after the due date, your submission will be counted as a late submission and penalties will apply (see Late Submissions section below).

Please note that it is your responsibility to:

Technical issues such as an internet outage or computer failure are not considered grounds for

special consideration. For further details please check the

• 5% of the total possible marks will be deducted if it is late by up to 30 minutes

• 10% of the total possible marks will be deducted if it is more than 30 minutes late and up to 24

Please note that online submissions are electronically tracked, and the electronic record of submission

will be used to determine late penalties. This means that submitting your work even a few seconds

RETENTION OF RECORDS

Students are required to keep a copy of all items submitted or completed for the purpose of

Using the work or ideas of another person, whether intentionally or not, and presenting them as your

own without clear acknowledgement of the source is called

• academic work must not be falsified in any way

• when the ideas of others are used, these ideas must be acknowledged appropriately.

EXPECTATIONS OF STUDENTS

• Actively engage in activities designed to develop assessment literacy, including taking the

initiative where appropriate (e.g. seeking clarification or advice, negotiating learning contracts,

• Ensure that their work is their own; and

• Be familiar with University policy and faculty procedures and act in accordance with those

You will be assessed according to the criteria below.

1. Which software I should use to draw the diagram? You can use any tools available.