ITECH2004 ER Model and Relational Schema Assignment

Assignment Help Database Management System

Reference no: EM132500466

ITECH2004 Data Modelling Assignment - ER Model & Relational Schema, Federation University, Australia

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 utilising 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.

Note - This is a report type assignment which should include ERD, Normalisation and database Schema. Please follow the assignment requirements given in the specification.

Attachment:- Data Modelling Assignment File.rar

Reference no: EM132500466

Questions Cloud

Find what ratio is net income to be divided : $45,000 and devotes half time to the partnership. If no other information is available regarding distributions, in what ratio is net income to be divided?

What is legal action policy : What is legal action policy ? If the outstanding debt is greater than always turn over to legal action when the debt becomes days past due

Determining the demand elastic or inelastic : Mary is a smart entrepreneur in her primary school. She sells ball points to her fellow school mates. At a price of $2.00 each, she sells 100.

Prepare and make an income statement : Prepare and Make an income statement. The total manufacturing costs for the year were $685,000; the cost of goods available for sale totaled $725,000

ITECH2004 ER Model and Relational Schema Assignment : You have been commissioned to create a database for Alcool Holdings. A database schema indicating the type and purpose of all attributes

Analyze the cost components of the primary manufacturing : Analyze the cost components of the primary manufacturing process and examine the significance of cost behavior analysis. Evaluate the value.

What the elements of the cost-volume-profit : Examine the elements of the cost-volume-profit (CVP) income statement and provide your opinion on the benefits of its use for decision making.

Find the amount of sales : Find the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company.

Demand elastic or inelastic over this price range : Mary is a smart entrepreneur in her primary school. She sells ball points to her fellow school mates. At a price of $2.00 each, she sells 100.

User Account

All Pages