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

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now