Data Base

Sigchi4life
Category:
Programming
Price: \$50 USD

Question description

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.

(Top Tutor) Daniel C.
(997)
School: Purdue University
Studypool has helped 1,244,100 students

1827 tutors are online

Related Programming questions

05/12/2013
05/11/2013

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