ITECH 1006 /5006 Database Management Systems School of Science, Information Technology and Engineering CRICOS Provider No. 00103D Assignment 2 (Semester 2 2013 (201317)) -Specification Page 1 of 6 Assignment 2 – Further Development of an ER Diagram, Database Implementation and Queries 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 Due Date: Thursday of Week 11 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. 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 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…