Reference no: EM133374506
Question: Follow the instructions below to design a database for recording the information on the staff member who books the departmental car, including the date booked and returned, the car mileage, and any claims for the fuel, parking, and similar related expenses.
1. Create business rules that translate into tables and relationships.
2. Design an ER diagram including tables, attributes, primary and foreign key fields, relationships, and optional/mandatory - minimum/maximum cardinalities.
3. Create an Access database including key attributes and relationships.
4. Add at least five records for each table.
5. Upload your business rules in a Word document, a Visio ER diagram, Access database file for grading using the directions below.