Database Management Exam 1(All Accurately solved)
The mapping cardinality between Publisher and Book is usually
A) 1:m
B) m:1
C) 1:1
D) m:m
E) 1:0 correct answers A) 1:m
An attribute must be the following except for which one:
A) a column of a table
B) a record
C) a field
D) single-valued correct answers B) a record
What a logical data model is used for:
A) For representing data requirements
B) For representing business logics
C) For representing how data is organized in a database
D) For representing how functions are performed correct answers C) For representing how data
is organized in a database
What is the difference between an ERD and a relational model (check all that apply)
A) They are used in different stages of the database development
B) An ERD tells how records are organized and a relational model shows data requirements
C) A relational model tells how records are organized and an ERD shows data requirements
D) They use different sets of concepts, terminologies, and notations E) They use unrelated sets of
concepts, terminologies, and notations correct answers A) They are used in different stages of
the database development
C) A relational model tells how records are organized and an ERD shows data requirements
D) They use different sets of concepts, terminologies, and notations
What is not correct about a record?
A) it is made of many values observed from one entity
B) it is usually linked to other records
C) it is made of a single value
D) it is also called a tuple
E) It is usually identifiable through some parts of the record correct answers C) it is made of a
single value
What is not true about a hierarchical database?
A) records are linked by pointers
B) records are organized as an inverted tree
C) records are not identified by keys
D) it is not a dominant type of databases nowadays correct answers C) records are not identified
by keys
, A relational database gets its name because
A) records are stacked into relations
B) all records are related
C) records are linked by relationships, rather than pointers
D) Edgar F. (Ted) Codd named it as such for no reason
E) All records are called relations correct answers A) records are stacked into relations
Identify Objects for Data Modeling: Which of the following are objects for the problem domain
of inventory management? (check all that apply)
A) products, warehouses, inventories, accounts
B) orders, shipments, invoices, packing slips, employees, locations
C) price, quantity, balance, business, services
D) minimum reorder level, balance, inventory system, company
E) suppliers, checkouts, check-ins correct answers A) products, warehouses, inventories,
accounts
B) orders, shipments, invoices, packing slips, employees, locations
E) suppliers, checkouts, check-ins
Identify Object Attributes: Which of the following are attributes of orders in an e-commerce
system? (check all that apply)
A) order date
B) promised date
C) ship date
D) total order amount
E) order quantity correct answers A) order date
B) promised date
D) total order amount
In the relational model, relationships between relations or tables are created by using:
A) composite keys
B) determinants
C) candidate keys
D) foreign keys correct answers D) foreign keys
What is the best entity-relationship diagram to model students, dorms, rooms for student
housing?
A) Dorm -- (1:m) -- Room --(1:m) -- Student
B) Dorm -- (1:m) -- Room --(m:m) -- Student
C) Student -- (m:1) -- Dorm --(1:m) -- Room
D) Dorm -- (1:m) -- Student--(m:1) -- Room correct answers A) Dorm -- (1:m) -- Room --(1:m)
-- Student
Identify Objects for Data Modeling: Which of the following are objects for the problem domain
of student registration? (check all that apply)
A) tuition, financial services, fees, credit hours, registrar
The mapping cardinality between Publisher and Book is usually
A) 1:m
B) m:1
C) 1:1
D) m:m
E) 1:0 correct answers A) 1:m
An attribute must be the following except for which one:
A) a column of a table
B) a record
C) a field
D) single-valued correct answers B) a record
What a logical data model is used for:
A) For representing data requirements
B) For representing business logics
C) For representing how data is organized in a database
D) For representing how functions are performed correct answers C) For representing how data
is organized in a database
What is the difference between an ERD and a relational model (check all that apply)
A) They are used in different stages of the database development
B) An ERD tells how records are organized and a relational model shows data requirements
C) A relational model tells how records are organized and an ERD shows data requirements
D) They use different sets of concepts, terminologies, and notations E) They use unrelated sets of
concepts, terminologies, and notations correct answers A) They are used in different stages of
the database development
C) A relational model tells how records are organized and an ERD shows data requirements
D) They use different sets of concepts, terminologies, and notations
What is not correct about a record?
A) it is made of many values observed from one entity
B) it is usually linked to other records
C) it is made of a single value
D) it is also called a tuple
E) It is usually identifiable through some parts of the record correct answers C) it is made of a
single value
What is not true about a hierarchical database?
A) records are linked by pointers
B) records are organized as an inverted tree
C) records are not identified by keys
D) it is not a dominant type of databases nowadays correct answers C) records are not identified
by keys
, A relational database gets its name because
A) records are stacked into relations
B) all records are related
C) records are linked by relationships, rather than pointers
D) Edgar F. (Ted) Codd named it as such for no reason
E) All records are called relations correct answers A) records are stacked into relations
Identify Objects for Data Modeling: Which of the following are objects for the problem domain
of inventory management? (check all that apply)
A) products, warehouses, inventories, accounts
B) orders, shipments, invoices, packing slips, employees, locations
C) price, quantity, balance, business, services
D) minimum reorder level, balance, inventory system, company
E) suppliers, checkouts, check-ins correct answers A) products, warehouses, inventories,
accounts
B) orders, shipments, invoices, packing slips, employees, locations
E) suppliers, checkouts, check-ins
Identify Object Attributes: Which of the following are attributes of orders in an e-commerce
system? (check all that apply)
A) order date
B) promised date
C) ship date
D) total order amount
E) order quantity correct answers A) order date
B) promised date
D) total order amount
In the relational model, relationships between relations or tables are created by using:
A) composite keys
B) determinants
C) candidate keys
D) foreign keys correct answers D) foreign keys
What is the best entity-relationship diagram to model students, dorms, rooms for student
housing?
A) Dorm -- (1:m) -- Room --(1:m) -- Student
B) Dorm -- (1:m) -- Room --(m:m) -- Student
C) Student -- (m:1) -- Dorm --(1:m) -- Room
D) Dorm -- (1:m) -- Student--(m:1) -- Room correct answers A) Dorm -- (1:m) -- Room --(1:m)
-- Student
Identify Objects for Data Modeling: Which of the following are objects for the problem domain
of student registration? (check all that apply)
A) tuition, financial services, fees, credit hours, registrar
