SBM4102 Data and Information Management

Australian Institute of Music is a music college across the Australia. It provides wide ranges of courses related to music. The top level management of the college has recently decided to computerise the existing paper-based data to a database in order to keep record of all staff, students, courses, etc. Such database will facilitate saving, restoring, and reporting whenever required and reduced paper consumption in the college. The following describes information that is required to save in the database. 

Cost of each course is presented in the table below.

· It should be noted that some courses run for half an hour while others run for an hour. The minimum course time to teach is 30 minutes.

· The college is also needs to maintain information about teaching staff. For example, it is required to record which staff teach which instruments. For example, David teaches singing and piano. Information related to staff includes staff id, name and family, date of birth, phone number, address, and degree. Each staff has a unique ID to ensure easy identification.

· In addition, information related to students is required to maintain in this database. Students has name, postal address, date of birth, and contact phone number. Once a student is joined to the college, he or she can enrol in to interested instruments course. The date and time of the course(s) should be recorded, as well as the duration.

· Furthermore, it is necessary to record which staff member will be taking the course and instrument the course is defined for. Students pay for their courses once the course is finished. It is necessary to record the condition for the course payment and the date paid.

· Another type of information which is required to store is the available instruments in the college stock. This includes the instrument name, manufacture name, quantity or number of each instrument in the stock. The staff may use one or more instrument for teaching purpose.

· At the end of every month, the staff issues invoice statements. An invoice, which has a unique number, is issued for those students who have one or more unpaid courses in the previous month. An invoice, for example, contains date, student information, and total amount due.  

You Need To Do The Followings 

Part-I Entity-relationship data model

You are required to develop an ER model to represent the information requirements for given case study.  

 Your ER model must:

· show all necessary entities, attributes and relationships

· show unique identifiers

· show minimum and maximum cardinality.

· show associative entities, if applicable

Some business rules given in the case study may not be clear to you when you read the case study. You may simply make an assumption and then develop your ER model.

You are required to write brief definitions for the entities and attributes in your model.  For each entity and attribute in your model, write a sentence to describe the meaning of that entity or attribute.