The staff at 'Frankli Consulting' have to routinely visit their clients in other cities. Franklin have a
Question:
The staff at 'Frankli 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.
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 normalize 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.
Vector Mechanics for Engineers Statics and Dynamics
ISBN: 978-0073212227
8th Edition
Authors: Ferdinand Beer, E. Russell Johnston, Jr., Elliot Eisenberg, William Clausen, David Mazurek, Phillip Cornwell