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
Other questions on the subject: Computers and Technology
Computers and Technology, 22.06.2019 14:10, normarismendoza
Dean wants a quick way to look up staff members by their staff id. in cell q3, nest the existing vlookup function in an iferror function. if the vlookup function returns an error result, the text “invalid staff id” should be displayed by the formula. (hint: you can test that this formula is working by changing the value in cell q2 to 0, but remember to set the value of cell q2 back to 1036 when the testing is complete.)
Answers: 3
Computers and Technology, 23.06.2019 04:31, caseypearson377
Acloud service provider uses the internet to deliver a computing environment for developing, running, and managing software applications. which cloud service model does the provider offer? a. iaas b. caas c. maas d. paas e. saas
Answers: 1
Computers and Technology, 23.06.2019 07:00, schvox
1. you have a small business that is divided into 3 departments: accounting, sales, and administration. these departments have the following number of devices (computers, printers, etc.): accounting-31, sales-28, and administration-13. using a class c private network, subnet the network so that each department will have their own subnet. you must show/explain how you arrived at your conclusion and also show the following: all available device addresses for each department, the broadcast address for each department, and the network address for each department. also, determine how many "wasted" (not usable) addresses resulted from your subnetting (enumerate them).
Answers: 3
Do you know the correct answer?
In this task, you will perform normalization on a crude table so that it could be stored as a relati...
Questions in other subjects:
Mathematics, 23.03.2021 01:00
Mathematics, 23.03.2021 01:00
History, 23.03.2021 01:00
Mathematics, 23.03.2021 01:00
History, 23.03.2021 01:00
