ITECH 2004 Data Modelling Assignment

Assignment Help Database Management System

Reference no: EM132500452

ITECH 2004 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.

Attachment:- Data Modelling Assignment File.rar

Reference no: EM132500452

Questions Cloud

Draw graphs showing margo utility from music : Draw graphs showing Margo's utility from music CDs and from movies on DVDs.

Describe how perfect completion differs : a) Describe how perfect completion differs from monopolistically competitive market model.

Advanced managerial accounting assignment : Advanced Managerial Accounting Assignment Help and Solution, College of Banking and Financial Studies - Assessment Writing Service

How much operating room overhead would be charged : Bill Harris had a 4-hour procedure on January 22. How much operating room overhead would be charged to his procedure, using the rate determined.

ITECH 2004 Data Modelling Assignment : ITECH 2004 Data Modelling Assignment - ER Model & Relational Schema, Assessment Help and Solution - Federation University, Australia. Create a database

Explain five reasons why cartel businesses are formed : a) Describe how perfect completion differs from monopolistically competitive market model.

What is estimated percent increase in net operating income : Using the degree of calculated operating leverage, what is the estimated percent increase in net operating income of a 5% increase in sales?

Compare the two utility graphs : a) Draw graphs showing Margo's utility from music CDs and from movies on DVDs.

How much grow to if invested at compounded interest rate : How much will $100 grow to if invested at a continuously compounded interest rate of 9% for 8.5 years? (Do not round intermediate calculations. )

User Account

All Pages