Question: Using the EER modeling grammar, create a domain model / conceptual data model based on the following descriptions. For each subpart of the task, augment

Using the EER modeling grammar, create a domain model / conceptual data model based on the following descriptions. For each subpart of the task, augment the model from the previous step by including the aspects of the model that you can derive from the description.

a. A piano teacher teaches about twenty students each year, meeting with each once a week for an hour. It is essential to keep track of the regular weekly meeting time. b. All of the students are children under the age of sixteen, and each has an adult who is responsible for his/her payments. c. A students repertoire consists of musical pieces. For each student, it is important to know the pieces title, composer, and year of composition. d. The teacher wants to know when a specific student completed a specific piece and the quality of the test performance. e. The teacher has come to the conclusion that it is important to keep track of the composers separately from the pieces. You can assume that each piece has one composer but a composer can, obviously, compose multiple pieces over time. For each composer, the teacher wants to keep track of her/his date of birth, nationality, and primary style. f. The teacher also wants to keep track of each of the separate times when a student comes to a lesson, including the date, time, notes, and amount paid for that visit.

EER Model [Insert your model here} I need this in diagramatic manner(block diagram) by using this concept

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!