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.
More Northwind Queries:
1. Determine the average number of days between an order’s being placed and its being shipped.
2. Find the employee who was youngest when hired.
3. Add yourself to the Employees table. Then make a query that lists the number of orders handled by every employee (including yourself). Rank the employees by the number of orders they have handled.
4. Make a list of employees and the total number of items contained within the orders they have handled. (Extra credit for including yourself.)
................
................
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