This paper circulates around the core theme of You are to create an ER diagram, and a relational schema for a small business. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 72. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
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: 11:55pm, Monday the 28th August, 2016 (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;