draw the ER diagram map the ER diagram to 3NF and Normalisation of IT LOGIT System

generallala

Main

Home >Homework Answsers >Information Systems homework help

BIS 234, Semester 1, 2016

Database Concepts Assignment 2

Prepared By: Jamal El-den, Craig Coley

Due date: Friday, Week 11

Value:

Part A 10% draw the ER diagram

Part B 10% map the ER diagram to 3NF

and Normalisation

topic: IT LOGIT System

Part A: Draw the ER diagram

Identify the business situation that you wish to design a database for. The situation needs to be a real life one (not an imaginary company for example) and ideally be something you are interested in or familiar with. Topics might include hobbies (cricket teams, online games), associations (hockey clubs, childcare centre), work-related concerns (fishing boats, student enrolments, art gallery) or other interests (Star Wars).

Try to pick an application that is relatively substantial, but not too enormous. If you decide to choose your own business situation will need to discuss with your lecturer if it is appropriate.

If you are unable to come up with your own you have the option of choosing from a list of cases. No group can choose the same case, unless there is sufficient difference in the case (Remember it will need to be based on a real practical situation).

Part B:

Map the ER diagram to 3NF

· Translate your ER Diagram into a schema of normalised tables. These must be in at least 3rd Normal Form (database schema)

Normalisation

Use a flat structure table include all attributes:

· Determine functional dependencies

· Use 3nf to develop the relations,show as

o Text notation

Internals

Will need to present the assignment in class in Week 11 Tuesday and outline the case, ERD and the normalisation that took place. Presentation is a maximum of 5 minutes with 2 minutes question time.