Suppose you are shown the attributes in the (poorly) constructed EMPLOYEE_PROB1_

Question

Suppose you are shown the attributes in the (poorly) constructed EMPLOYEE_PROB1_6 database table shown in Figure P1.6. Given this information, place a check mark matching each attribute to its characteristics. For example, if you (wrongly!) think that the "Name" attribute is Simple and Multivalued, place a check mark in the blanks next to "Name" and below the headers "Simple (atomic)" and "Multivalued" Given the EMPLOYEE table structure and contents shown in problem 1.6, show an alternate way to store the Skill data in the database table. Show only the table structure as it is defined by its attributes. For example, the EMPLOYEE table structure in problem 1.6 is defined by its attributes this way:

Explanation / Answer

Alternative way to store Skill data:

Table 1:

Table 2:

Susan B Smithson,    Network Admin

Susan B Smithson,    Database Systems Design

Like this, the Skill column has been made atomic.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.