MC Given the following EER categorisation:

Which statement is CORRECT? A patient only inherits the 'Name' and 'Date of Birth' attribute types from the superclass that the current entity belongs to. correct The categorisation can also be represented as a specialisation. incorrect All men and women are patients. incorrect The categorisation can also be represented as an aggregation. incorrect
MC Given the following EER specialisation:

According to the model, which of the following statements is CORRECT? A meat product does not have any attributes types. incorrect There are certain supermarket products that are not Fruits&Vegetables, not meat and not non-food. correct All food products are either Fruits&Vegetables or meat. incorrect A supermarket product can be a food and non-food product at the same time. incorrect
MC 
In the movie ER model above, we focus on the binary relationship 'PRODUCES'. Suppose we add an attribute type that indicates the time that each producer spent on producing each movie called 'WORKING HOURS'.
Which of the following scenarios is possible? We can migrate the attribute type 'WORKING HOURS' to the 'MOVIE' entity type. incorrect We can migrate the attribute type 'WORKING HOURS' to the 'PRODUCER' entity type. incorrect We can migrate the attribute type 'WORKING HOURS' to either one of the linked entity types. incorrect We can add the attribute type 'WORKING HOURS' to the relationship type PRODUCES. correct
MC Which statement is NOT CORRECT? A private access modifier (denoted by the symbol '-') is used in case the variable or method can only be accessed by the class itself. incorrect In UML, access modifiers can be used to specify who can have access to a variable or method. incorrect A protected access modifier (denoted by the symbol '#') is used in case the variable or method can be accessed by both the class and its superclasses. correct A public access modifier (denoted by the symbol '+') is used in case the variable or method can be accessed by any other class. incorrect
MC Which statement is CORRECT? An association is an instance of a link. incorrect Only binary associations are supported in the UML class diagram. incorrect Qualified associations can be used to represent weak entity types. correct An association is always bidirectional. incorrect
MC Which statement is NOT CORRECT? A protected access modifier (denoted by the symbol '#') is used in case the variable or method can be accessed by both the class and its superclasses. correct OCL constraints can be used for various purposes such as, to specify invariants for classes, to specify pre- and post-conditions for methods, to navigate between classes, or to define constraints on operations. incorrect The changeability property specifies the type of operations which are allowed on either variable values or links. incorrect A composite aggregation has a maximum multiplicity of 1 and a minimum multiplicity of 0 or 1 at the composite side. incorrect
MC 
In the movie ER model above, we focus on the binary relationship 'PRODUCES'. Suppose we add an attribute type that indicates the time that each producer spent on producing each movie called 'WORKING HOURS'.
Which of the following scenarios is possible? We can migrate the attribute type 'WORKING HOURS' to either one of the linked entity types. incorrect We can add the attribute type 'WORKING HOURS' to the relationship type PRODUCES. correct We can migrate the attribute type 'WORKING HOURS' to the 'MOVIE' entity type. incorrect We can migrate the attribute type 'WORKING HOURS' to the 'PRODUCER' entity type. incorrect
MC Which statement is CORRECT? A weak entity type is always existence dependent. correct An existence dependent entity type is always a weak entity type. incorrect An existence dependent entity type always participates in a 1:1 relationship type. incorrect A weak entity type can only have one attribute type. incorrect
MC Which statement is CORRECT? An association is an instance of a link. incorrect Qualified associations can be used to represent weak entity types. correct An association is always bidirectional. incorrect Only binary associations are supported in the UML class diagram. incorrect
MC Which statement is CORRECT? A weak entity type is always existence dependent. correct An existence dependent entity type is always a weak entity type. incorrect A weak entity type can only have one attribute type. incorrect An existence dependent entity type always participates in a 1:1 relationship type. incorrect