Map the high-level data model shown below to a set of relational tables. Identify primary, alternate, and foreign keys.

What will be an ideal response?


![15251|500x407](upload://br8URUhYF9pMqHSCpro2EpXCKHB.png)

Company(name, phone)
Equipment(equipID, price, CName)
Engineer(engNo, fName, lName, CName, dateJoined)
Fault(faultID, description, equipID)
ElectFault(faultID, ePart)
MechFault(faultID, mPart)
Repairs(engNo, faultID, date, hours)

Computer Science & Information Technology

You might also like to view...

Answer the following statements true (T) or false (F)

1. A queue is a last-in/first-out structure. 2. A collection is a data structure for holding elements. 3. A Java collection is any class that implements the Collection interface. 4. is a wildcard used to specify a wide range of parameters.

Computer Science & Information Technology

A(n) ________ code needs to be inserted if you want different page numbers, headers, and footers in a different part of a document

Fill in the blank(s) with correct word

Computer Science & Information Technology

In a style sheet, the color ____ indicates a style property, as shown in the accompanying figure.

A. red B. blue C. gray D. purple

Computer Science & Information Technology

What are the four steps in using Ajax to update data?

What will be an ideal response?

Computer Science & Information Technology