Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2015 Porto Portugal September 7 11 2015 Proceedings Part 2 Lnai 9285

Authors: Annalisa Appice ,Pedro Pereira Rodrigues ,Vitor Santos Costa ,Joao Gama ,Alipio Jorge ,Carlos Soares

1st Edition

3319235249, 978-3319235240

More Books

Students also viewed these Databases questions