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
Concepts in Designing Database
A database design is the process of data organization based on a database model. The process deals with identifying what data should be stored in a database and how data elements relate to each other.
Entity Relationship Diagram
Complex real-world applications call for large volumes of data. Therefore, it is necessary to build a great database to store data safely and coherently. The ER data model aids in the process of database design. It helps outline the structure of an organization’s database by understanding the real-world interactions of objects related to the data. For example, if a school is tasked to store student information, then analyzing the correlation between the students, subjects, and teachers would help identify how the data needs to be stored.
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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
