Yorkville High School Computer Science Department
Yorkville High School Computer Science Department on Facebook  Yorkville High School Computer Science Department Twitter Feed  Yorkville High School Computer Science Department on Instagram

Yorkville High School Computer Science

ASSIGNMENTS: Web App Attribute List - October 22, 2018 :: UI Project Paper Prototype - October 23, 2018 :: Challenges 5 - November 2, 2018 >>

Database Programming :: Projects :: Normalize This

Rubric
Lesson
Due: Sep 5

Problem

For each of the tables below you are to do the following:

Table One

Shipment (ShipNum, ShipperName, ShipperContact, ShipperFax, PackageNum, PackDepartureDate, PackArrivalDate, PackDestinaltionCity, PackShipCost, InsuranceValue, InsurerCompany, InsurerAddress)

FDs = {ShipNum --> ShipperName, ShipperContact, ShipperFax
PackageNum --> PackDepartureDate, PackArrivalDate, PackDestinationCity, PackShipCost, InsuranceValue, InsurerCompany
InsurerCompany --> InsurerAddress }

Table Two

Truck (TruckNum, TruckType, TypeDesc, TruckMiles, DatePurchased, TruckSerialNum, BaseCity, BaseState, BasePhone, BaseManagerName, ManagerPhone, BasePhone)

Assumptions: A truck is based at a single base and a base can be the base for many trucks.

Table Three

R (A, B, C, D, E, F, G, H, I, J)

FD = { A,B,C,D --> E, F, G, H, I J
B, C, D --> E, F
A --> G, H, I, J
E --> F
H, I --> J }

Yorkville High School Computer Science Department on Facebook Yorkville High School Computer Science Department Twitter Feed Yorkville High School Computer Science Department on Instagram