For the following entity-relationship diagram, the attributes you would NOT expect to see in the Computer entity are
A) manufacturer.
B) type (laptop or desktop).
C) memory size.
D) disk size.
E) student's dorm room.

Question

For the following entity-relationship diagram, the attributes you would NOT expect to see in the Computer entity are 
A) manufacturer. 
B) type (laptop or desktop). 
C) memory size. 
D) disk size. 
E) student's dorm room.

Quizplus · Accepted Answer

The Computer entity is related to the Student entity through the Residence entity, which already includes the dorm room attribute. Therefore, it would be redundant and unnecessary to also include the dorm room attribute in the Computer entity. The manufacturer, type, memory size, and disk size attributes are all relevant to the Computer entity.

For the Following Entity-Relationship Diagram, the Attributes You Would NOT