PARTICIPATION ACTIVITY4.3.9: Database design.1)'Cardinality' refers to relationships only.TrueFalse2)In ER diagrams, maxima and minima are drawn for relationships only.TrueFalse3)Maxima and minima usually depend on business rules.TrueFalse4)In the analysis phase, cardinality is always determined after discovery is complete.TrueFalse

Consider the following scenario•A company provides catering services for clients who need special-occasion, celebratory dinners. For each dinner, a number of dishes are to be offered. The dinner will be held at a venue. The company will provide staff to serve meals at the venue.•The company needs a database to store data related to this business activitya. Identify and list the entitiesb. Identify pairs of entities where a direct relationship existc.-For each pair of relationship draw the entity relationship diagram justifying the choice of cardinalities

In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in R and that the cardinality of E1 is greater that the cardinality of E2. Which one of the following is true about R?

Choose the correct answerWhich of the following indicates the maximum number of entities that can be involved in a relationship?OptionsMaximum cardinalityMinimum cardinalityERDMaximum cardinality

In the context of DBMS, what does "cardinality" refer to?a.The size of the database on diskb.The number of columns in a tablec.The number of rows in a tabled.The degree of participation of entities in a relationship

In ER diagrams, maxima and minima are drawn for relationships only.