Entity Relationship Diagram Quiz
(102).jpg "Entity Relationship Diagram Quiz - Quiz")
Hey, are you aware of the entity-relationship model (ER)? Try this interesting 'ER diagram' quiz and see how much you can score on this test. This model is used to describe interrelated things of interest in a specific domain of knowledge. If you think you have a good understanding of this topic, then this quiz will be very useful in testing your knowledge. So, get ready and start answering. Good luck to you!
- 1.ER was developed by Chen in 1980. True or false?
- A.
True
- B.
False
- 2.ER aims to:
- A.
Facilitate database programming
- B.
Facilitate database organization
- C.
Facilitate database design
- D.
Facilitate database website
- 3.The Conceptual data model is the set of concepts that:
- A.
Describe the structure of a database and the associated insert and update transactions
- B.
Describe the structure of a database and the associated retrieval and update transactions
- C.
Describe the structure of a database and the associated retrieval transactions
- D.
None of the above
- 4.An ERs purpose is to support a user's perception of the data and conceal the technical aspects associated with database design. True or false?
- A.
True
- B.
False
- 5.A high-level conceptual model is dependent on the DBMS and HW platform used to implement the database. True or false?
- A.
True
- B.
False
- 6.The basic concepts of the Entity-Relationship model include:
- A.
Entity types
- B.
File types
- C.
Relationship types
- D.
Atrtributes
- E.
Storage detailes
- 7.Entity type = An object or concept identified by the enterprise as having an ______________ existence.
- 8.A Entity is
- A.
An instance of an Entity type that is uniquely identifiable
- B.
An instance of a DBA type that is uniquely identifiable
- C.
An instance of a type that is uniquely identifiable
- D.
None of the above
- 9.Weak entity type:
- A.
An entity that is not existance-dependent on some other entity type
- B.
An Entity that characterizes a DBMS
- C.
An instance that is existence dependent on some other entity type
- D.
None of the above
- 10.Strong entity type:
- A.
An entity that is not existance-dependent on some other entity type
- B.
An Entity that characterizes a DBMS
- C.
An instance that is existance dependent on some other entity type
- D.
All of the above
- 11.An Attribute is a property of an entity or a relationship type. True or false?
- A.
True
- B.
False
- 12.An Attribute:
- A.
A set of values that might be assigned to an attribute.
- B.
Is a property of an entity or a relationship type
- C.
A set of numbers and values
- D.
None of the above
- 13.An Attribute domain:
- A.
A set of values that might be asigned to an atribute
- B.
Is a property of an entity or a relationship type
- C.
Is a set of numeric and database values
- D.
None of the above
- 14.Simple attribute:
- A.
An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity
- B.
An attribute that holds multiple values for a single component
- C.
An attribute that holds a single value for a single entity
- D.
An atribute composed of multiple components each with individual existance
- E.
An atribute composed of a single component with an independent existance
- 15.Composite attribute:
- A.
An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity
- B.
An attribute that holds multiple values for a single component
- C.
An attribute that holds a single value for a single entity
- D.
An atribute composed of multiple components each with individual existance
- E.
An atribute composed of a single component with an independent existance
- 16.Single valued attribute:
- A.
An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity
- B.
An attribute that holds multiple values for a single component
- C.
An attribute that holds a single value for a single entity
- D.
An atribute composed of multiple components each with individual existance
- E.
An atribute composed of a single component with an independent existance
- 17.Multi- valued attribute:
- A.
An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity
- B.
An attribute that holds multiple values for a single component
- C.
An attribute that holds a single value for a single entity
- D.
An atribute composed of multiple components each with individual existance
- E.
An atribute composed of a single component with an independent existance
- 18.Derived attribute
- A.
An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity
- B.
An attribute that holds multiple values for a single component
- C.
An attribute that holds a single value for a single entity
- D.
An atribute composed of multiple components each with individual existance
- E.
An atribute composed of a single component with an independent existance
- 19.A Candidate key is an attribute or set of attributes that uniquely identifies individual occurrences of an entity type.
- A.
True
- B.
False
- 20.The Primary key:
- A.
Uniquely identifies each occurance of an entity type
- B.
Is equivalant with a composite key
- C.
Is the candidate key selected to be a primary key
- D.
All of the above
- 21.A Composite key is a candidate key that consists of two or more attributes. State true or false.
- A.
True
- B.
False
- 22.Degree of a relationship.
- A.
Is always 1
- B.
The number of participating entities in a relationship
- C.
The number of representations in a relationship
- D.
Is always 0
- E.
Is always 0
Recent Quizzes
Featured Quizzes
Popular Topics
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes