Computers and Technology, 03.05.2020 14:10 pawfox
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
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
Total paid
$96.42
Given the information in above table,
1. 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)
2. Show the step by step process of decomposing the above table into a set of 3NF relations. (5 marks)
3. 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)
4. Draw the Crow’s Foot ERD to illustrate your final design. (4 marks)
Answers: 1
Computers and Technology, 22.06.2019 04:30
Which of the statements below is true? the formatting, standard, and drawing commands are unavailable. the formatting, standard, and drawing commands have been used. the formatting, standard, and drawing toolbars are displayed. the formatting, standard, and drawing toolbars are hidden.
Answers: 1
Computers and Technology, 22.06.2019 06:00
In outlook how can cherie look at the details of an event that appears on the month view of her calendar? check all that apply. by switching to the detail view by switching to the week view by switching to the day view by right-clicking on the event by double-clicking on the event by highlighting the event
Answers: 2
Computers and Technology, 22.06.2019 10:20
Print "usernum1 is negative." if usernum1 is less than 0. end with newline. convert usernum2 to 0 if usernum2 is greater than 10. otherwise, print "usernum2 is less than or equal to 10.". end with newline
Answers: 3
Computers and Technology, 22.06.2019 15:10
David is in week 3 of his current ashford course and has a paper due by monday night at midnight. he has finished everything but the concluding paragraph. as he boots up his computer to work on it, he sees a flash across the screen and then the screen goes black. he begins to panic as he tries desperately to turn the laptop back on. david should have saved his work on what kind of portable device?
Answers: 2
In this task, you will perform normalization on a crude table so that it could be stored as a relati...
Computers and Technology, 09.04.2020 21:03
Mathematics, 09.04.2020 21:03
Mathematics, 09.04.2020 21:03
Mathematics, 09.04.2020 21:03
Mathematics, 09.04.2020 21:03
Mathematics, 09.04.2020 21:03
Mathematics, 09.04.2020 21:03
History, 09.04.2020 21:03
Mathematics, 09.04.2020 21:03