CHAPTER
4: RELATIONAL MODEL
2. Assume that ABC is a shipping company
operated worldwide. Look at the scenario as following:
ABC
prides itself on having up-to-date information on the processing and
current location of each shipped item. To do this, ABC relies on a
company-wide information system. Shipped items are the heart of the
ABC product tracking information system. Shipped items can be
characterized by item number (unique), weight, dimensions, insurance
amount, destination, and final delivery date. Shipped items are
received into the ABC system at a single retail center. Retail
centers are characterized by their type, uniqueID, and address.
Shipped items make their way to their destination via one or more
standard ABC transportation events (i.e., flights, truck deliveries).
These transportation events are characterized by a unique
scheduleNumber, a type (e.g, flight, truck), and a
deliveryRoute.
Create an Entity Relationship diagram that
captures information given in the scenario.
(20 Marks)
5
entities, 5 attributes, 5 primary keys, 10 relationships and 10
cardinalitys are identified.
3. Based-on answer in question 7,
normalize the database and identify primary key and foreign key for
each entity. Implement the database in Microsoft Access.
(20
Marks)
The post up-to-date information on the processing appeared first on My Assignment Online.