Consider the following table for a parking ticket database
More Normalization
Consider the following table for a parking ticket database.
ParkingTicket(date, time, badgeNo, officerFName, officeLName, carLicenseNo, carMake, carColor, street, ownerFName, ownerLName, amount)
The primary key is chosen to be a combination of (date, time, badgeNo) based on the reasoning that on a given date at a given time an officer with a particular badge number can only be issuing one ticket.
1. Are there any candidate keys?
2. Identify any functional dependencies.
3. Are there any partial dependencies on the primary key?
4. Are there any transitive dependencies on the primary key?
5. Decompose (normalize) the table to 3NF.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- a company had the following purchases a
- a company had the following purchases an
- form a word using the following letters
- online parking ticket payment nj
- spell a word with the following letters
- parking ticket by license plate
- nj pay parking ticket online
- convert the following fraction to a decimal
- which of the following is a nonmetal
- what is the periodic table for kids
- write the chemical equation for a photosynthesis
- explain the periodic table for dummies