You are to create an ER diagram, and a relational schema for a small business. You need to provide a discussion of normalisation including the normal form that each entity is in, a list of...

You are to create an ER diagram, and a relational schema for a small business. You need to provide a discussion of normalisation including the normal form that each entity is in, a list of relationships with all table names, primary and foreign keys, and attributes indicating their type and purpose.

Timelines and Expectations Percentage Value of Task: 20%  Due: 5pm Thursday the 5th January, 2017 (week 7) Minimum time expectation: 12 hours

Learning Outcomes Assessed The following course learning outcomes are assessed by completing this assessment:  K4. design a relational database for a provided scenario utilising tools and techniques including ER diagrams, relation models and normalisation  K5. describe relational algebra and its relationship to Structured Query Language (SQL);  A1. design and implement a relational database using a database management system;

Project Specification You have been commissioned to create a database for ArtScapes, a new company that runs exhibitions in different locations in Australia. Their goal is to sell tickets to these art exhibitions to the public, promote featured artists and help them sell works of art during the exhibitions