Make the table in the format

Assignment Help Basic Computer Science

Reference no: EM13674180

Note: when you are asked to analyze a given table , you should go through the following steps:
a. make the table in the format : table_name (attribute1, attribute2, ...).
b. defind the key (and candidate key if there is any) for this table. Also, underline the key.
c. List all functional dependencies (FDs)
d. state the normal form this table is currently in
e. if this table is not in 3NF or BCNF, then normalize it by decomposing the table into a set of tables that are in 3NF or BCNF
Above 5 steps are very important for normalizing any table and are neccesary steps in your assignments.
1. Give the following table, key and FDs, what normal form this table is in ? Why explain your reason. How do you normalize it. What normal form is each table in after you normalize the PRODCUT table ?
PRODUCT (SerialNumber, Type, TankCapacity, RepairDate, RepairInvoiceNumber, RepairCost)
Candidate Keys (CK): (RepairInvoiceNumber), (SerialNumber, RepairDate)
Functional Dependencies:
RepairInvoiceNumber → all other attributes
(SerialNumber, RepairDate) → all other attributes
SerialNumber → (Type, TankCapacity) (note, Type does not determine TankCapacity)
2. Given the following table, key and FDs, what normal form this table is in ? how do you normalize it. What normal form is each table in after you normalize the REPAIR table ?
REPAIR (RepairInvoiceNumber, RepairDate, RepairCost, RepairEmployeeName, RepairEmployeePhone, SerialNumber, Type, TankCapacity)
Candidate Keys:
RepairInvoiceNumber, and (RepairDate, SerialNumber)
Functional Dependencies:
RepairInvoiceNumber → all other attributes
(RepairDate, SerialNumber) → all other attributes
SerialNumber → Type, TankCapacity
RepairEmployeeName → RepairEmployeePhone

3. Show a table other than the one we discussed in class and text that is in 3NF but not in BCNF, give your justification.
4. Normalize the following table into BCNF.
EQUIPMENT (Manufacturer, Model, AcquisitionDate, BuyerName, BuyerPhone, PlantLocation, City, State, ZIP)
Functional dependencies (FD):
BuyerName → BuyerPhone, PlantLocation, City, State, Zip;
Zip → City, State;
(Manufacturer, Model, BuyerName) → AcqDate

Reference no: EM13674180

Questions Cloud

What is the current sidereal time : Local noon at 0o longitude corresponds to 12:00UTC. a) Given that our longitude is 84o 28' 33'' W, what is our local noontime in UTC? (b) What local time would this correspond to today? (c) From this and your estimate of the sun's current hour angle,..

Utilize the vector model to show this pictorially : A composite pulse (or pulse sandwich) is an older method utilized to correct pulse imperfections due to not setting proper pulse durations or angles. For example an 180y pulse can be replaced by the 90y-180x-90y pulse sandwich

Design a dns namespace : Design a DNS namespace

Compute the work done in one heartbeat : Suppose the following simplified dependence of the pressure in a ventricle of the human heart as a function of the volume of blood pumped. Ps, the d=systolic pressure is 120 mm Hg. Pd, the diastolic pressure is 750 mm hg.

Make the table in the format : Make the table in the format : table_name

Simple harmonic oscillator placed in a resisting medium : A simple harmonic oscillator placed in a resisting medium, consists of a 100-g mass attached to a spring whose force constant is 10^{4} dyne/cm (1 dyne = 10^{-5} N). The mass is displace 3cm and released from rest.

Shortest open organ pipe that will resonate at frequency : The lowest note on an organ is 16.4 Hz. What would be the pitch if the same organ pipe were closed? What is the shortest open organ pipe that will resonate at this frequency?

Flexible single master operations roles : Flexible Single Master Operations Roles

Rifle is fired in a valley with parallel vertical walls : A rifle is fired in a valley with parallel vertical walls. The echo from one wall is heard 2.0 s after the rifle was fired. The echo from the other wall is heard 2.0 s after the first echo. How wide is the valley?

User Account

All Pages