Using the Entities and Attributes you created for your business from the week 1 discussions. Show the tables and relationships resulting from your model in the form of an E/R diagram. You can use PPT, VISIO or any other graphical modeling tool to create your ER diagram. Respond to at least one of the student's post by providing suggestion for additional relationships or tables that might be included for future enhancements of the model.

My business is J & A's Car Rental, the office needs a database that can find what cars are in stock, needs maintenance, rented out and customer information. The application that will be is used is MySQL as this is the only location, so it is only needed locally.

CUSTOMER

• last_name (PK)
• first_name
• address
• payment type
• date out
• date due back

CARS IN STOCK

• serial_number (PK)
• size
• make
• model
• year
• miles

CARS RENTED OUT

• serial_number (PK)
• size
• make
• model
• year
• miles_at_time_of_rental

CARS IN MAINTENANCE

• serial_number (PK)
• employee_doing_maintenance (FK)
• date_put_in_service
• work_required
• parts_ordered
• estimated_time_of_repair