Hybrid 02 Quiz
docx
keyboard_arrow_up
School
Algonquin College *
*We aren’t endorsed by this school
Course
8215
Subject
Information Systems
Date
Apr 3, 2024
Type
docx
Pages
4
Uploaded by MateWaspMaster1017
Quiz
22S Hybrid Quiz 2
Question 1
(2 points)
Saved
A disadvantage of using subtypes includes the fact that it can enable complexities in the queries used.
Question 1 options:
True
False
Question 2
(1 point)
Saved
One of the problems solved by the use of subtype is redundancy in the database.
Question 2 options:
True
False
Question 3
(2 points)
Saved
If subtypes are exclusive, it means that one supertype relates to at most one
subtype.
Question 3 options:
True
False
Question 4
(1 point)
Saved
The entity that has a relation with one or more of its subtypes and has attributes common to its subtype is called:
Question 4 options:
Discriminator
Recursive
Supertype
None of these answers are correct
Question 5
(2 points)
Saved
A recursive relationship occurs when an entity type has a relationship to itself. This means a relationship between two entities of the same type.
Question 5 options:
True
False
Question 6
(1 point)
Saved
Each entity has a set of unique attributes which can be repeated.
Question 6 options:
True
False
Question 7
(2 points)
Saved
In a data model, some entities could share attributes among themselves apart from the ones that are unique.
Question 7 options:
True
False
Question 8
(2 points)
Saved
When we develop an entity relationship model, we need to do it in such as way as not to reduce the number of attributes repeated in different entities.
Question 8 options:
True
False
Question 9
(2 points)
Saved
A subtype has its own unique attributes but it is not a subgroup of the supertype.
Question 9 options:
True
False
Question 10
(1 point)
Saved
We can divide entities into subtypes and supertypes.
Question 10 options:
True
False
Question 11
(2 points)
Saved
The relationships between supertypes and subtypes are known as:
Question 11 options:
HAS-A relationships
IS-A relationship
MUST-A relationship
None of the above
Question 12
(2 points)
Saved
Recursive relationships do not occur between instances of the same entity.
Question 12 options:
True
False
Question 13
(1 point)
Saved
If a supertype has to be in one of the subtypes, then the subtypes are called:
Question 13 options:
Partial subtypes
Total subtype
Relationship subtype
None of the answers are correct
Question 14
(2 points)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Saved
Subtypes provide some flexibility when the structure of the database is changed.
Question 14 options:
True
False
Question 15
(2 points)
Saved
Identifiers of the supertype and its subtypes must be unidentical.
Question 15 options:
True
False
Submit Quiz
15 of 15 questions saved