Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using Microsoft Visio or Lucid Chart, draw a CONCEPTUAL E - R diagram using Crow's Foot Notation to track the information in the car rental
Using Microsoft Visio or Lucid Chart, draw a CONCEPTUAL ER diagram using Crow's Foot Notation to track the information in the car rental contract below. Refer to Chapter of the text, class lectures, and Canvas ER diagramming videos for a review of conceptual ER diagramming.
You will be graded on your diagram of the entities, attributes and re lationships for the car rental report and business rules below.
WXURY RENTAL CAR CONTRACT
Rental Information:
Pickup Date: Return Date: Cost: $ Location: RDU
Customer Information:
First Name: Joseph Last Name: Jackson Cust#: A Email:
joejackson@yahoo.com
Address: Main St City: Jacksonville ST: NC ZIP: Phone:
Vehicle Information:
VIN: WPCADAXKS Make: Porsche Model: Turbo S Year.
Class: Luxury Mileage:
Maintenance Information:
Date of service:
Procedure: Oil change
Mileage during service:
Manufacturer Information:
Name: Porsche
Country: Germany
Sales Rep: Franz Beckenbauer
Phone:
BUSINESS RULES:
A car is manufactured by exactly one manufacturer.
A manufacturer provides zero, one or many cars to the rental company.
A car may not have been rented yet or it may have been rented to many customers.
A customer must rent a car at least once to be in the database and may have rented cars many times. Besides knowing who is renting which car, a rental transaction also tracks the rental date, the return date and the total cost of the rental.
COPy your CON CEPTU AL drawing here.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started