
Access over 20 million homework documents through the notebank

Get on-demand Q&A homework help from verified tutors

Read 1000s of rich book guides covering popular titles
I need help with a Programming question. All explanations and answers will be used to help me learn.
What is the cost for a DBA to answers the folowing questions.
Problem
Tom's Equipment Rental is a small company that rents equipment to individuals. Each piece of equipment has a unique serial number, so even two identical pieces of equipment will have different serial numbers. Over time, pieces of equipment will be rented many times, possibly even by the same customer. When a customer rents equipment, a rental agreement is created that lists each item being rented during that visit. Each rental agreement has a unique agreement number and can include the rental of one or more pieces of equipment. Each customer has a unique customer number and may have more than one rental agreement (even on the same day). The table below shows sample data for this problem in a report format.
Agree_No |
Agree_Date |
Cust_No |
Cust_Name |
Cust_Phone |
Serial_No |
Item_Name |
Item_Rate |
100365 |
01/25/04 |
10534 |
Joe Brown |
555-234-1212 |
S6345 |
Circular Saw |
$10.00 |
S5489 |
Jig Saw |
$5.00 | |||||
100366 |
01/25/04 |
11937 |
Jill Jones |
555-364-1892 |
J1254 |
Jack Hammer |
$25.00 |
C0012 |
Cement Mixer |
$15.00 | |||||
100598 |
02/10/04 |
10534 |
Joe Brown |
555-234-1212 |
S6345 |
Circular Saw |
$10.00 |
100603 |
02/11/04 |
11937 |
Jill Jones |
555-364-1892 |
S5489 |
Jig Saw |
$5.00 |
100658 |
02/17/04 |
11321 |
Bob Hicks |
555-231-7856 |
C0012 |
Cement Mixer |
$15.00 |
100659 |
02/17/04 |
11321 |
Bob Hicks |
555-231-7856 |
J1254 |
Jack Hammer |
$25.00 |
Case Questions
1. Define the term "repeating group" and identify the attributes in the repeating group from the table above.
2. Convert to 1NF – Draw a dependency diagram showing the primary key attribute(s) and identifying all dependencies.
3. Convert to 2NF – Remove all partial dependencies and show the resulting table structure(s). You may use dependency diagrams or shorthand table structures (see page 125 in the text).
4. Convert to 3NF – Remove all transitive dependencies and show the resulting table structure(s). You may use dependency diagrams or shorthand table structures (see page 125 in the text).
5. Using the results of Question 4, draw a complete Crow's Foot ERD.
This question has not been answered.
Create a free account to get help with this and any other question!
Brown University
1271 Tutors
California Institute of Technology
2131 Tutors
Carnegie Mellon University
982 Tutors
Columbia University
1256 Tutors
Dartmouth University
2113 Tutors
Emory University
2279 Tutors
Harvard University
599 Tutors
Massachusetts Institute of Technology
2319 Tutors
New York University
1645 Tutors
Notre Dam University
1911 Tutors
Oklahoma University
2122 Tutors
Pennsylvania State University
932 Tutors
Princeton University
1211 Tutors
Stanford University
983 Tutors
University of California
1282 Tutors
Oxford University
123 Tutors
Yale University
2325 Tutors