Home / Expert Answers / Computer Science / need-help-use-the-erdplus-application-to-create-a-car-dealership-eer-diagram-15-points-using-the-pa334

(Solved): need help Use the ERDPlus application to create a Car Dealership EER diagram. (15 points) Using the ...



need help

Use the ERDPlus application to create a Car Dealership EER diagram. (15 points) Using the Menu then Export option, export the diagram as an image and submit in Blackboard by 9:4 (10 points) Create an EER diagram which includes the following: Entities & Attributes (20 points) CUSTOMER ? CustomerlD ? Name ? HomeAddress (Address, City, State, Zip) ? Phone ? Email ? DOB [Age] EMPLOYEE ? EmployeelD ? Name ? Job Title ? Manager VEHICLE ? VehicleID ? Make ? Model - Color ? Year - Mileage ? Price TRANSACTION ? TransactionID - CustomerlD ? EmployeelD ? VehicleID ? [SalesPrice] Additional Information (25 points) Employees can be a sales person and/or a manager or neither. (5 points) Customers can be new or existing but not both. (5 points) One customer can purchase many vehicles and each vehicle must be bought by one customer. One transaction must include a vehicle and each vehicle must be included in one transaction. Each vehicle must be sold by one employee and one employee can sell many vehicles. (5 point

student submitted image, transcription available below
student submitted image, transcription available below
Use the ERDPlus application to create a Car Dealership EER diagram. (15 points) Using the Menu then Export option, export the diagram as an image and submit in Blackboard by (10 points) Create an EER diagram which includes the following: Entities \& Attributes ( 20 points) dditional Information (25 points) Employees can be a sales person and/or a manager or neither. ( 5 points) Customers can be new or existing but not both. (5 points) One customer can purchase many vehicles and each vehicle must be bought by one customer. One transaction must include a vehicle and each vehicle must be included in one transaction. 1 Each vehicle must be sold by one employee and one employee can sell many vehicles. ( 5 poin 2. Using the Menu then Export option, export the diagram as an image and submit in Blackboard by . (10 points) 3. Create an EER diagram which includes the following: Entities \& Attributes (20 points) Additional Information (25 points) - Employees can be a sales person and/or a manager or neither. (5 points) - Customers can be new or existing but not both. (5 points) - One customer can purchase many vehicles and each vehicle must be bought by one customer. (5 points) - One transaction must include a vehicle and each vehicle must be included in one transaction. (5 points) - Each vehicle must be sold by one employee and one employee can sell many vehicles. (5 points)


We have an Answer from Expert

View Expert Answer

Expert Answer


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe