Suppose I need to model a school system where students must participate in at least one extra-curricular activity

Subject:Computer SciencePrice:2.86 Bought5

Share With

Suppose I need to model a school system where students must participate in at least one extra-curricular activity. Each activity must have at least two participants. What is the appropriate minimum cardinality between entities STUDENT and ACTIVITY?

A) 1-1

B)1-M

C)M-N

D) optional-optional

E)optional-mandatory

F)mandatory-mandatory

 

Suppose I need to model a recipe database. Each ingredient in my database must appear in at least one dish and each dish has one or more ingredients. What is the appropriate maximum cardinality between entities DISH and INGREDIENT?

A) 1-1

B) 1-M

C) M-N

D) optional-optional

E) optional-mandatory

F) mandatory-mandatory

 

A referential integrity constraint policy that insure that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called:

A) Incremental Updates

B) Incremental Deletes

C) Cascading Updates

D) Cascading Deletes