Question 13. 13. (TCOs 9 and 10) What attributes would you have in a table to de

Question

Question 13.13. (TCOs 9 and 10) What attributes would you have in a table to describe an entity called Student? What would you use as the primary key? What would be the relationship between Grade and Student? Assume that a student can have many grades.

9. (TCOs 9 and 10) A technique wherein attributes that are common to several types of an entity are grouped into their own entity, called a supertype, is called (Points : 3)        normalization.
       generalization.
       concatenation.
       compound data type.
       None of the above

Explanation / Answer

1.

generalization, example entity 'car', 'bus', 'truck' can be generalized to an entity named 'vehicle'

2.

1NF

3.

a transitive dependency

4.

key integrity, A primary key can never be empty

5.

Attributes for 'student' entity:

StudentID, StudentName, HomeTown, Grade, Age

For primary key, I'd use StudentID, as it will be unique for all student. And there can't have any student who doesn't have a StudentID.

Relationship between Student and Grade can be 'got'. Like in: Student X got Grade Y

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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