Question
You will be modelling a database for a local package delivery company. As example, A FEDEX warehouse may need to track which driver who delivers
You will be modelling a database for a local package delivery company. As example, A FEDEX warehouse may need to track which driver who delivers packages delivered which package to which address on what time. You dont need to model every aspect of such a database. The database would record information about shippers who sent the package, addresses, package content, and drivers information. You only need to model the following, create necessary Entity sets with appropriate attributes as you see fit in addition to the required ones: Addresses The address where the package is supposed to be delivered. A shippers address may be recorded in this entity set also. Shippers A shipper needs to have an address (for returning service) as well as necessary attributes such as name and phone number. Packages - have necessary attributes such as content and weight. Delivery contain information on which packages are being delivered by which driver to which address at what time. Relationships: There could be more relationships, but you need to at least include the following: Shippers to Addresses relationship A shipper may reside or work at multiple addresses. The relationship between Shippers and Packages. A shipper could have shipped multiple packages Make sure that each entity set has an appropriate set of attributes and that you also model the relationship between/among your entity sets. 1. The entity sets, attributes and relationships need to meet the requirements listed above. 2. Your diagram should include indications regarding the multiplicity of the relationships in your model. 3. Text explanations of many-one and many-many relationships if any in the diagram. 4. You may also refer to the grading rubrics associated with the assignment for grading criteria
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