A department of the university has a small car, which members of staff may use for work purposes. They need a database to keep track of who uses the car and any related expenses. In this assessment, you create business rules, an ER diagram, and an Access database. 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.

Create business rules that translate into tables and relationships. Design an ER diagram including tables, attributes, primary and foreign key fields, relationships, and optional/mandatory - minimum/maximum cardinalities. Create an Access database including key attributes and relationships. Add at least five records for each table. Upload your business rules in a Word document, a Visio ER diagram, Access database file