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
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) 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 9:40pm. (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)