CPSC 440 FINAL questions & answers
graded A+
A DBMS can be used for insertion and retrieval of the data in the database. -
correct answer ✔✔True
Joe is an example of - correct answer ✔✔data
Which of the following is a format which data can appear? - correct answer
✔✔Text, Numbers and Image
The term data refers to facts that are recorded and can be accessed - correct
answer ✔✔True
Which of the following requires that the end user knows how to issue commands
to the specific DBMS - correct answer ✔✔Direct interaction
The ERD diagram for RAGUSIUM University is based on the following:
-Each class has between zero and many sections; each section belongs to exactly
one class
-Each student can be enrolled in one or many sections; each student section has
multiple students enrolled
In the ER Diagram Sections with students in rolled should have - correct answer
✔✔|< (mandatory one or many)
, If you had a roller coaster company and your ERD diagram had entities USER and
RIDE what would you add to record duration of the ride - correct answer ✔✔Add
an attribute to RIDE entity
How many entities are involved in a unary relationship - correct answer ✔✔1
How many Columns will this entity have - correct answer ✔✔3
If a 1:M relationship is optional on the M side and mandatory on the 1 side, and if
the table resulting from the 1 side has 3 records, then the table resulting from the
M side CANNOT have less than - correct answer ✔✔0 (no records required)
If an M:N relationship is mandatory on both sides, and if both relations resulting
from the entities involved in the relationship have 3 records, then the resulting
bridge relation CANNOT have less than - correct answer ✔✔3
Observe the ER diagram for the ABC Retailer:
How many Columns will the relation PRODUCT have in the relational schema
mapped from the ABC Retailer ER Diagram - correct answer ✔✔3
Which of the following is a read operation - correct answer ✔✔Retrieving data
from the relation
If A--> B is an existing functional dependency, which of the following is an
augmented functional dependency - correct answer ✔✔A,C --> B
graded A+
A DBMS can be used for insertion and retrieval of the data in the database. -
correct answer ✔✔True
Joe is an example of - correct answer ✔✔data
Which of the following is a format which data can appear? - correct answer
✔✔Text, Numbers and Image
The term data refers to facts that are recorded and can be accessed - correct
answer ✔✔True
Which of the following requires that the end user knows how to issue commands
to the specific DBMS - correct answer ✔✔Direct interaction
The ERD diagram for RAGUSIUM University is based on the following:
-Each class has between zero and many sections; each section belongs to exactly
one class
-Each student can be enrolled in one or many sections; each student section has
multiple students enrolled
In the ER Diagram Sections with students in rolled should have - correct answer
✔✔|< (mandatory one or many)
, If you had a roller coaster company and your ERD diagram had entities USER and
RIDE what would you add to record duration of the ride - correct answer ✔✔Add
an attribute to RIDE entity
How many entities are involved in a unary relationship - correct answer ✔✔1
How many Columns will this entity have - correct answer ✔✔3
If a 1:M relationship is optional on the M side and mandatory on the 1 side, and if
the table resulting from the 1 side has 3 records, then the table resulting from the
M side CANNOT have less than - correct answer ✔✔0 (no records required)
If an M:N relationship is mandatory on both sides, and if both relations resulting
from the entities involved in the relationship have 3 records, then the resulting
bridge relation CANNOT have less than - correct answer ✔✔3
Observe the ER diagram for the ABC Retailer:
How many Columns will the relation PRODUCT have in the relational schema
mapped from the ABC Retailer ER Diagram - correct answer ✔✔3
Which of the following is a read operation - correct answer ✔✔Retrieving data
from the relation
If A--> B is an existing functional dependency, which of the following is an
augmented functional dependency - correct answer ✔✔A,C --> B
