Assignment Overview: The purpose of this task is to develop student's skills in designing and implementing a relational database for a given case study.
Learning Outcomes Assessed: The following course learning outcomes are assessed by completing this assessment:
- Design a relational database for a provided scenario utilizing tools and techniques including ER diagrams, relation models and normalisation.
- Describe relational algebra and its relationship to Structured Query Language (SQL).
- Design and implement a relational database using a database management system.
Assessment Details:
Background - You have been commissioned to create a database for Alcool Holdings. Alcool Holdings is an online retail beverages sales specialist and has two types of inventory, wine and beer. They would like a database to manage their inventory, manufacturers, wholesalers, customers and sales.
Requirements - This assignment should be presented in a report format, including the following items:
An ER Diagram with all entity names, attribute names, primary and foreign keys, relationships, cardinality and participation indicated. All many to many relationships should be resolved.
A discussion of normalisation, the normal form that each entity is in, how normalisation was achieved, and why that is optimal. All entities to be in 3NF, unless there is strong justification for leaving in 2NF.
A list of relationships with all table names, attributes, primary and foreign keys indicated as per the conventions given in the lecture slides (i.e. entity/table names in capitals, attributes as proper nouns, primary key underlined and foreign keys in italics).
A database schema indicating the type and purpose of all attributes.
Tutorsglobe has come up with the top-notch Data Modelling Assignment Help service that will always help you in fetching notable grades, without putting so much effort.
Tags: Data Modelling Assignment Help, Data Modelling Homework Help, Data Modelling Coursework, Data Modelling Solved Assignments, Relational Database Assignment Help, Relational Database Homework Help, Structured Query Language Assignment Help, Structured Query Language Homework Help
Attachment:- Data Modelling.rar