Home > Computer Engineering > Quizzes > Database Management Systems: Entity Relationship Data Model
Database Management Systems: Entity Relationship Data Model
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 16% • Most missed: “The refinement from an initial entity set into successive levels of entity subgr…”
Database Management Systems: Entity Relationship Data Model
Time left 00:00
25 Questions

1. Which one of the following attribute can be taken as a primary key?
2. The subset of a super key is a candidate key under what condition?
3. Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:
4. The descriptive property possessed by each entity set is _________
5. In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.
6. The completeness constraint may be one of the following: Total generalization or specialization, Partial generalization or specialization. Which is the default?
7. Which of the following is a single valued attribute
8. The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
9. The refinement from an initial entity set into successive levels of entity subgroupings represents a ________ design process in which distinctions are made explicit.
10. An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
11. _____________ express the number of entities to which another entity can be associated via a relationship set.
12. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
13. Drop Table cannot be used to drop a table referenced by a _________ constraint.
14. A _____________ constraint requires that an entity belong to no more than one lower-level entity set.
15. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
16. Which one of the following uniquely identifies the elements in the relation?
17. Which relationship is used to represent a specialization entity?
18. Not applicable condition can be represented in relation entry as
19. If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has
20. Which one of the following cannot be taken as a primary key?
21. Which of the following can be addressed by enforcing a referential integrity constraint?
22. Which of the following is another name for a weak entity?
23. There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called
24. The function that an entity plays in a relationship is called that entity'
25. Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________

⚡ Recently practiced quizzes in this topic
Live quiz activity
Information Technology Knowledge Test Computer Network MCQs General CS (Computer Science) Knowledge Test Big Data: NoSQL Green Computing Practice Test Natural Language Processing: Word Level Analysis Computational Thinking Concepts Computer Fundamentals Practice Test Operating Systems Practice Test: Introduction to OS Computer Fundamentals Practice Test: Generations of Computers
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.