SBM4102: Data and Information Management - IT Assessment Answer

Subject Code: SBM4102 Internal Code: 1AGEEH

IT Assessment Answer

TASK: Assessment Details: In this assessment, students work in small groups to design and develop a relational database for use in a data mart context. Details of the requirements will be supplied in week two. The database design and implementation should give consideration, in particular to: ? Entry relationship model ? Database management systems and architecture ? Principles of normalisation ? Use of SQL components ? System documentation: Architecture, Data Quality & Security. Read the case study below please 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. Course           Cost Singing          $100 Piano             $75 Violin            $120 Guitar            $50 ? 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 also needs to maintain information about teaching staff. For example, it is required to record which staff will 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 need to pay one week before starting the course. They will be issued invoices with unique invoice number. Their payment should be recorded in detail. ? 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.

This IT Assessment has been solved by our IT experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.