Database Systems - Section 3 Multiple Questions and Answers.
Exercise Questions ::
Database Systems
Answer: Option C
Explanation:
The first part of the rectangle, contains the name of the entity set. The second part contains the names of all the attributes of the entity set.
See More Information
Tutorial Link:
Published by:Kiran Manzoor
12. Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality:
A. One to many B. One to one C. Many to many D. Many to one
View Answer
Discuss forum
Workplace
Report
Answer: Option B
Explanation:
This indicates that an instructor may advise at most one student, and a student may have at most one advisor.
See More Information
Tutorial Link:
Published by:Kiran Manzoor
13. We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________?
A. Diamond , diamond B. Rectangle, diamond C. Rectangle, rectangle D. Diamond, rectangle
View Answer
Discuss forum
Workplace
Report
Answer: Option D
Explanation:
Diamond represents a relationship set and rectangle represents a entity set.
See More Information
Tutorial Link:
Published by:Kiran Manzoor
14. An entity set that does not have sufficient attributes to form a primary key is termed a __________?
A. Strong entity set B. Variant set C. Weak entity set D. Variable set
View Answer
Discuss forum
Workplace
Report
Answer: Option C
Explanation:
An entity set that has a primary key is termed a strong entity set.
See More Information
Tutorial Link:
Published by:Kiran Manzoor
15. For a weak entity set to be meaningful, it must be associated with another entity set, called the?
A. Identifying set B. Owner set C. Neighbour set D. Strong entity set
View Answer
Discuss forum
Workplace
Report
Answer: Option A
Explanation:
Every weak entity must be associated with an identifying entity; that is, the weak entity set is said to be existence dependent on the identifying entity set. The identifying entity set is said to own the weak entity set that it identifies. It is also called as owner entity set.
See More Information
Tutorial Link:
Published by:Kiran Manzoor
« »