database management system

ITECH 1006 /5006 Database Management Systems School of Science, Information Technology and Engineering CRICOS Provider No. 00103D Assignment 1 Specification Page 1 of 4 Assignment 1 – Development of an ER Diagram and Database Implementation Course Objectives: This assessment task focuses on the following course objective: • use entity-relationship diagrams to design a relational database. Due Date: Thursday of Week 6 at 17:00 (see Course Description for further dates and times). Project Specification You have been commissioned by Julie from ABC Event Organisers to design a database to assist them with managing their booking, customer and supplier information. You are only required to provide the design of the database at this time. ABC would like to store information regarding their customers. Customers may either be individual or corporate customers. For individual customers they would like to store the contact name, address details (including their location, postal and delivery address details), email address and phone numbers (mobile, home, work). For their corporate customers they would like to store the business name, a contact name, address details (including their location, postal and delivery address details), email address, website URL, and phone numbers (mobile, work). ABC has a number of different suppliers who provide them with the products that they require to organise events. For each supplier they would like to store their business name, contact name, address details (including their location, postal and delivery address details), and phone numbers (mobile, work). Each supplier may provide a number of different products. For example a supplier may provide furniture such as chairs, tables, or other items such as table clothes, cutlery and crockery. Suppliers may only provide one product or many different products. ABC would like to be able to search their database to obtain a list of suppliers who supply particular products, however, they do not need...