ITC556 Normalisation Database system

gif-final

Order Now mail

Charles Sturt University


ITC556 Normalisation Database system

Assessment No: 3

ITC556|Database system

Our Real
uni-icon
Student’s Score cards


ITC556 Normalisation Database system Assessment and Tutor Proposal

Normalisation


Task

In this task, you will perform normalization on a crude table so that it could be stored as a relational database.

The staff at 'Franklin Consulting' have to routinely visit their clients in other cities. Franklin have a fleet of cars available for staff travels. During their trips, the staff sometimes need to fill up the car fuel. Upon returning from the trip, the staff claim that expenses back by providing the fueling receipt and some other essential information. The accountant records all of that information in a spreadsheet. Below are the spreadsheet column headers and a sample of data from each column.

Column Name Example Data
Trip ID 4129
Total paid$96.42

 

Column Name Example Data
Staff name Sarah James
Car details Toyota Land Cruiser 2015
License Plate 1CR3KT
Odometer reading 25,067
Service station Coles Express
Station address 27 Queen St, Campbelltown, NSW 2560
Fill up time 30 Jan 2020, 2:45 pm
Fuel type Unleaded 95
Quantity litres 55
Cost per litre $1.753

 

 

 

Given the information in above table,

 

 

 

  • Draw a dependency diagram to show the functional dependencies existing between columns. State any assumptions you make about the data and the attributes shown in the table. (3 marks)
  • Show the step by step process of decomposing the above table into a set of 3NF relations. (5 marks)
  • Review the design of your 3NF relations and make necessary amendments to define proper PKs, FKs and atomic attributes. Any additional relations may also be defined at this stage. Make sure all of your attributes conform to the naming conventions. (3 marks)
  • Draw the Crow’s Foot ERD to illustrate your final design. (4 marks)

 

 

 

For guidance on how to normalise database relations from a dependency diagram, watch this very short video: https://www.youtube.com/watch?v=vkUyuLLgmwQ

 

 

 

All dependency diagrams and ERD must be created using a drawing tool. Hand-drawn diagrams are NOT acceptable.

 

 

Why invest in our services?

Only High Quality
Optimum quality

Our assignment help team is trained to provide you high quality writing services.

Reasonable Price of Each
High scores

High scores achieved by our students is a portrayal of our high quality online assignment help

Privacy and Security
Multiple reach

You can place your assignment order through 4 easy modes of communication

Order Now