2023 Document Preview ITECH 1006 5006 Database Management Systems School of Science Information Technology and | Assignment Collections

Document Preview:

ITECH 1006 /5006 Database Management Systems School of Science, Information Technology and Engineering CRICOS Provider No. 00103D Assignment 1 Specification Page 1 of 5 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 Barry from the Fantastic Fireworks Company (FFC), a business that organises fireworks displays for individuals and organisations. He has asked you to design a database to assist FFC with managing their booking, customer and supplier information. You are only required to provide the design of the database at this time. FFC would like to store information regarding their customers. Customers may either be individuals or organisations. 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 organisational customers they would like to store the organisation name, organisation type (e.g. corporation, government, club), a contact name, address details (including their location, postal and delivery address details), email address, website URL, and phone numbers (mobile, work). The location address and work phone number are always recorded for a customer. Postal and delivery addresses and mobile and home phone numbers are sometimes not available so these are optionally recorded. FFC has a number of different suppliers who provide them with the products that enables them to conduct displays. 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…