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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!