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 purposeThe 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