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: Network App - December 14, 2018 :: Web App - December 14, 2018 :: Operating System - December 17, 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