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.

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Purdue University
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1829 tutors are online

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