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 2 – Extending an ER Diagram including Database Implementation and Queries Due Date: Thursday of Week 11 at 17:00 (see Course Description for further dates and times). Objectives: • To analyse and comprehend a provided ER diagram • To update the ER diagram using provided specifications • To create and update normalized relations of the data from the provided ER • To create and update Database Schema • To implement a database based on the provided ER diagram • To write required SQL statements to query the database Project Specification You have been commissioned by Julie from ABC Event Organisers to design a database and implement to assist them with managing their booking, customer and supplier information. The majority of the design has been completed, however there are some changes that they would like made to the system. Using the specifications from the previous assignment, the ER diagram and files provided update and implement the system using the following information. Original Specification 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…