Deliverable: Draw an Entity-Relationship Diagram using ER-Assistant or equivalen

By admin

Deliverable: Draw an Entity-Relationship Diagram using ER-Assistant or equivalent software. The deliverable is a complete ER model for the following scenario.
The ER diagram must include the necessary entity classes and all attributes specified in the description.
Identifiers for all entity classes must be shown clearly.
Relationships must be named, with cardinalities clearly shown.
Write down your assumption clearly if necessary
Do your best, if you are having troubles, please write that out with the assumptions. Document any assumption you have to make.
There are multiple right answers for this problem, so please don’t compare with others, as you can all read the case differently.
PLEASE UPLOAD THE ER MODEL (As a ERD,JPG,PNG, or PDF) AND THE Assumptions (a separate word or text document) to Canvas, Assignment 1. All entity class names and attribute names should start with your initials. No grade will be granted without your initials added.
Case Description
A trucking company (called TRUCKERS Inc.) is responsible for picking up shipments from warehouses of retail chain called MAZE and delivering the shipments to individual retail store locations of MAZE. Currently MAZE has 6 warehouses and 45 retail stores.
A truck may carry several shipments during a single trip. Each trip is identified by a “Trip #”.
The shipments on a single trip may be delivered to multiple stores. Each shipment is identified by a Shipment # and includes data on volume, weight, destination, expected delivery date, and the date shipment was picked-up.
Trucks have different capabilities on both volumes they can hold as well as the weights they can carry. TRUCKERS currently have 150 trucks in its fleet and each truck may make 3 to 4 trips per week.
A database that will be used by BOTH TRUCKERS AND MAZE is being designed to keep track of the truck usage and deliveries and to help in scheduling the trucks to provide timely deliveries to the retail stores. You are not creating a database now, you are doing the design by creating the ERD.

Exit mobile version