How often Entity relationship modelling is asked

Where it was asked

• Oct/Nov 202428 marks
• Oct/Nov 202331 marks
• Oct/Nov 202234 marks

The questions

1. Oct/Nov 2024, Q1.12 marks · multiple choice

   Indicate whether the following statement is true or false: overlapping subtypes are subtypes containing nonunique subsets of the supertype entity set, meaning each instance of the supertype entity may belong to more than one subtype.

2. Oct/Nov 2024, Q1.22 marks · multiple choice

   Indicate whether the following statement is true or false: in a specialisation hierarchy, every subtype can be directly related to many supertypes.

3. Oct/Nov 2024, Q1.32 marks · multiple choice

   Indicate whether the following statement is true or false: if Capricon TVET College had some departments classified as 'research only' that therefore offered no courses, this would mean the COURSE entity is independent of the DEPARTMENT entity.

4. Oct/Nov 2024, Q1.52 marks · multiple choice

   Indicate whether the following statement is true or false: a multivalued attribute type cannot be created within a DBMS.

5. Oct/Nov 2024, Q420 marks

   Using the transport business rules given below, draw an appropriate entity relationship diagram using UML notation for a unique e-hailing taxi service operating in Mpumalanga, making sure to include all relevant entities, relationships and multiplicities. The business rules are: a single driver may be assigned to several taxis over time, although any one taxi has only one driver at a given time; a customer may take multiple rides, and the e-hailing service offers customers the option to share rides; a single taxi can be used for many different rides; and each ride is linked to exactly one payment, with the customer able to cancel a ride so that the payment is then reversed.