Question

urgent guys

INFO2312 Spring2019 Final (1) Compatibility Model - Micrasaft Word Hame insert Page layoutReterences Malngs Revs View Fnd- AaBhCrDdF AaPhCrDd Copy 「Subte Emo.. Quote - change ChangeRe ,Normal INo spoong Heading 1 Heading 2 Title Subtitle Emohaas ntense Ern. Strong Clpboard Parsgraph Styles Edring 2. UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company- wide information system. Shipped items are the heart of the UPS 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 UPS system at a single retail center. Retail centers are characterized by their type, uniquelD and address. Shipped items make their way to their destination via one or more standard UPS 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 a) Fill in the blanks below: [6 Marks] Table Name (Entity) Is dependent or Primary Key Column independent (Answer Name yes/no). Any other answer will receive 0 Shipped Items Transportation Events b) Fill in the relationship below from: [6 Marks] 1. One: One 2. Zero: One 3. One: Many A. Zero: Many 5. Many: Many INFO2312 Spring2019 Final (1) Compatibility Model - Micrasaft Word Hame insert Page layoutReterences Malngs Revs View Fnd- AaBhCrDdF AaPhCrDd a Copy Octe ' change select. Faste Format parter B 1 꾜 แ·х, x' Aa-ツ 스, . . . . E-o-- rNormal 1 No spsc ng Heading I Headnq 2 Ttle Subtitle stee Emp Emohaas ntense E. Strong Cipboard Parsgraph Styles Edring Retail Centre Transportation Events b) Fill in the relationship below from: [6 Marks] 2. Zero: One 3. One: Many 4. Zero: Many 5. Many: Many Shipped Items are Shipped Transportation Events Retail Centres ship ems (That are shipped) hipped are eceived and sorted in c) Write the name of the one column that can be a foreign key in the dependent table of part a) [1 Mark] d) Is the Transportation Events in 1NF/2NFI3NF? [2 Marksl

Answer 1

a)

Table Name(Entity)	Is Dependent or Independent	Primary Key Column Name
Shipped Items	Yes	Item Number
Retail Centres	No	Unique ID
Transportation Events	Yes	ScheduleNumber

b)

Shipped Items are Shipped Via	One : Many	Transportation Events
Retail Centres ship	Zero: Many	Items(That are shipped)
Shipped items are received and sorted in	One: One	Retail Centres

c) Retail Centres ->Unique ID

d) Transportation Events is 0NF because we can future breakdown Transportation Events entity Schedule Type column into another table as Flight, Truck etc.