1. What technique is used to model the situation that Student may have multiple addresses? A) Associative Entity (gerund)B) Weak entitiesC) Super/sub typesD) Recursive relationships 2.There is m:m relationship between students and classes. Which technique is used forrepresenting the student grade? A) Associative Entity (gerund)B) Weak entitiesC) Super/sub typesD) Recursive relationships 3. An associative Entity (gerund) may be used whenever there are data that depends on twoentities even when their relationship is 1:m. True or FalseA) TrueB) False 4. (check all that apply) When do you use recursive relationships?A) the relationship between employees and their supervisorsB) the relationship between employees and their dependentsC) the relationship between employees and their departmentsD) the relationship between employees and their team membersE) the relationship between employees and their job assignments 5. How is a gerund converted into a relational model?A) ignore the gerund in the conversionB) convert the gerund into a table without primary keyC) Convert the gerund into a table duplicate the primary keys of its both ends as a part of the compositeforeign key for the gerund tableD) convert the gerund into a table and duplicate the primary keys of its both ends as a part of thecomposite primary key for the gerund table 6. How do you convert a recursive m:m relationship into relational tables?A) duplicate the primary key twice inside the same tableB) duplicate the primary key once inside the same tableC) create a junction table and duplicate the primary key twice in the junction tableD) create a junction table and duplicate the primary key once in the junction table 7. How do you convert a weak entity into a relational table? A) merge the weak entity records with the strong entity records into one tableB) create a table for the weak entity but get the primary of the strong entity table as a part of the primarykey for the weak entity tableC) create a junction table and duplicate the primary keys of both weak and strong entity tables in thejunction tableD) Create a table for the weak entity but put its primary into the strong entity table 8. (check all that apply) The ER model for a small bank system has Customer, Account, CheckingAccount, Employee, Check, Transactions, etc. as entities. Which of the following is correct use of weakentities?A) Check is a week entity of Checking AccountB) Checking Account is a weak entity of AccountC) Transaction is a weak entity of AccountD) Accout is a weak entity of Customer 9. (check all that apply) The ER model for a small bank system has Customer, Account, CheckingAccount, Employee, Check, Transactions, etc. as entities. Which of the following is correct use ofrecursive relationships?A) Checking account is a special kind of checksB) related bank transfers as one for credit and one for debitC) Checks belong to a checking accountD) Employees and their supvervisors 10. In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product,Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storagelocation and its capacity. Sometimes, a customer may need to come back to pickup their items afterchecking out while most of the time they leave the store with their purchases. Which of the following is thebetter design for manage transactions?A) Add an attriute to transaction to indicate whether goods have been pickuped or notB) Create two subtyeps of TransactionC) Create a weak entity Pickup to link with TransactionD) Add a relationship between Transaction and

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question

1. What technique is used to model the situation that Student may have multiple addresses?

A) Associative Entity (gerund)
B) Weak entities
C) Super/sub types
D) Recursive relationships

2.There is m:m relationship between students and classes. Which technique is used for
representing the student grade?

A) Associative Entity (gerund)
B) Weak entities
C) Super/sub types
D) Recursive relationships

3. An associative Entity (gerund) may be used whenever there are data that depends on two
entities even when their relationship is 1:m. True or False
A) True
B) False

4. (check all that apply) When do you use recursive relationships?
A) the relationship between employees and their supervisors
B) the relationship between employees and their dependents
C) the relationship between employees and their departments
D) the relationship between employees and their team members
E) the relationship between employees and their job assignments

5. How is a gerund converted into a relational model?
A) ignore the gerund in the conversion
B) convert the gerund into a table without primary key
C) Convert the gerund into a table duplicate the primary keys of its both ends as a part of the composite
foreign key for the gerund table
D) convert the gerund into a table and duplicate the primary keys of its both ends as a part of the
composite primary key for the gerund table

6. How do you convert a recursive m:m relationship into relational tables?
A) duplicate the primary key twice inside the same table
B) duplicate the primary key once inside the same table
C) create a junction table and duplicate the primary key twice in the junction table
D) create a junction table and duplicate the primary key once in the junction table

7. How do you convert a weak entity into a relational table?

A) merge the weak entity records with the strong entity records into one table
B) create a table for the weak entity but get the primary of the strong entity table as a part of the primary
key for the weak entity table
C) create a junction table and duplicate the primary keys of both weak and strong entity tables in the
junction table
D) Create a table for the weak entity but put its primary into the strong entity table

8. (check all that apply) The ER model for a small bank system has Customer, Account, Checking
Account, Employee, Check, Transactions, etc. as entities. Which of the following is correct use of weak
entities?
A) Check is a week entity of Checking Account
B) Checking Account is a weak entity of Account
C) Transaction is a weak entity of Account
D) Accout is a weak entity of Customer

9. (check all that apply) The ER model for a small bank system has Customer, Account, Checking
Account, Employee, Check, Transactions, etc. as entities. Which of the following is correct use of
recursive relationships?
A) Checking account is a special kind of checks
B) related bank transfers as one for credit and one for debit
C) Checks belong to a checking account
D) Employees and their supvervisors

10. In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product,
Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storage
location and its capacity. Sometimes, a customer may need to come back to pickup their items after
checking out while most of the time they leave the store with their purchases. Which of the following is the
better design for manage transactions?
A) Add an attriute to transaction to indicate whether goods have been pickuped or not
B) Create two subtyeps of Transaction
C) Create a weak entity Pickup to link with Transaction
D) Add a relationship between Transaction and

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Concepts in designing Database
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education