INFS 346 Final Exam Questions With Correct
Answers
Which of the following is a format in which data can appear? - CORRECT
| | | | | | | | | | | | | |
ANSWER✔✔-Text, Numbers, Images | |
Which of the following is typically found in the database metadata? -
| | | | | | | | | | | |
CORRECT ANSWER✔✔-Data types | |
what is depicted by ER diagrams? - CORRECT ANSWER✔✔-Metadata
| | | | | | | | |
only
How many entities are represented by the following requirements:
| | | | | | | |
Happy Cat veterinarian practice located in Chicago keeps track of its 20
| | | | | | | | | | | |
veterinarians, 30 vet technicians, and 1000 cat patients. - CORRECT
| | | | | | | | | |
ANSWER✔✔-3
How will the additional requirement about Happy Cat be represented in
| | | | | | | | | | |
an ER diagram:
| |
Each vet technician can examine many cat patients and each cat patient
| | | | | | | | | | | |
can be examined by multiple vet technicians. - CORRECT ANSWER✔✔-
| | | | | | | | |
many to many relationship
| | |
, How will the additional requirement about Happy Cat be represented in
| | | | | | | | | | |
an ER diagram:
| |
Each cat patient has at most one favorite veterinarian and each
| | | | | | | | | | |
veterinarian can be the favorite of zero or many cat patients. - CORRECT
| | | | | | | | | | | | |
ANSWER✔✔-one to many relationship | | |
The values of the following attribute type are NOT permanently stored
| | | | | | | | | | |
in a database. - CORRECT ANSWER✔✔-Derived attribute
| | | | | |
Which of the following statements regarding a weak entity is FALSE:
| | | | | | | | | |
A. A weak entity has zero or one partial keys
| | | | | | | | |
B. Identifying relationship can be many to many
| | | | | | |
C. Identifying relationship can be one to many
| | | | | | |
D. Identifying relationship can be one to one
| | | | | | |
E. Identifying relationship is always mandatory-one on the owner side -
| | | | | | | | | | |
CORRECT ANSWER✔✔-B |
If an ER diagram has 5 entities, what is the minimal number of
| | | | | | | | | | | | |
relationships it has to have (assume that the ERD has no relationships of
| | | | | | | | | | | |
|a degree higher than 2)? - CORRECT ANSWER✔✔-3
| | | | | | |
Based on the Spotify ERD, we can keep track of empty playlists.
| | | | | | | | | | |
Answers
Which of the following is a format in which data can appear? - CORRECT
| | | | | | | | | | | | | |
ANSWER✔✔-Text, Numbers, Images | |
Which of the following is typically found in the database metadata? -
| | | | | | | | | | | |
CORRECT ANSWER✔✔-Data types | |
what is depicted by ER diagrams? - CORRECT ANSWER✔✔-Metadata
| | | | | | | | |
only
How many entities are represented by the following requirements:
| | | | | | | |
Happy Cat veterinarian practice located in Chicago keeps track of its 20
| | | | | | | | | | | |
veterinarians, 30 vet technicians, and 1000 cat patients. - CORRECT
| | | | | | | | | |
ANSWER✔✔-3
How will the additional requirement about Happy Cat be represented in
| | | | | | | | | | |
an ER diagram:
| |
Each vet technician can examine many cat patients and each cat patient
| | | | | | | | | | | |
can be examined by multiple vet technicians. - CORRECT ANSWER✔✔-
| | | | | | | | |
many to many relationship
| | |
, How will the additional requirement about Happy Cat be represented in
| | | | | | | | | | |
an ER diagram:
| |
Each cat patient has at most one favorite veterinarian and each
| | | | | | | | | | |
veterinarian can be the favorite of zero or many cat patients. - CORRECT
| | | | | | | | | | | | |
ANSWER✔✔-one to many relationship | | |
The values of the following attribute type are NOT permanently stored
| | | | | | | | | | |
in a database. - CORRECT ANSWER✔✔-Derived attribute
| | | | | |
Which of the following statements regarding a weak entity is FALSE:
| | | | | | | | | |
A. A weak entity has zero or one partial keys
| | | | | | | | |
B. Identifying relationship can be many to many
| | | | | | |
C. Identifying relationship can be one to many
| | | | | | |
D. Identifying relationship can be one to one
| | | | | | |
E. Identifying relationship is always mandatory-one on the owner side -
| | | | | | | | | | |
CORRECT ANSWER✔✔-B |
If an ER diagram has 5 entities, what is the minimal number of
| | | | | | | | | | | | |
relationships it has to have (assume that the ERD has no relationships of
| | | | | | | | | | | |
|a degree higher than 2)? - CORRECT ANSWER✔✔-3
| | | | | | |
Based on the Spotify ERD, we can keep track of empty playlists.
| | | | | | | | | | |
