MC Which statement is 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 is always existence dependent. correct A weak entity type can only have one attribute type. incorrect MC A composite aggregation... has a maximum multiplicity of n and a minimum multiplicity of 0 or 1 at the composite side. incorrect has a maximum multiplicity of n and a minimum multiplicity of 0 at the composite side. incorrect has a maximum multiplicity of 1 and a minimum multiplicity of 1 at the composite side. incorrect has a maximum multiplicity of 1 and a minimum multiplicity of 0 or 1 at the composite side. correct 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 All food products are either Fruits&Vegetables or meat. incorrect There are certain supermarket products that are not Fruits&Vegetables, not meat and not non-food. correct A supermarket product can be a food and non-food product at the same time. 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 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 public access modifier (denoted by the symbol '+') is used in case the variable or method can be accessed by any other class. incorrect MC Consider the following EER model of a database which stores information about scientific publications.



Which statement is CORRECT? According to the EER model, a scientific article can be at the same time a peer reviewed paper and a technical report. incorrect According to the EER model, two journals can never have the same title, even when they are being published by different publishers. incorrect According to the EER model, an author can be a reviewer of his/her own peer reviewed paper. correct The EER model has weak entity types, but no existence dependent entity types. incorrect MC Which one of the following is an example of a DISJOINT and PARTIAL specialisation? HUMAN -> BLONDE + BRUNETTE correct HUMAN -> UNIVERSITY DEGREE + COLLEGE DEGREE incorrect HUMAN -> LOVES FISH + LOVES MEAT incorrect HUMAN -> VEGETARIAN + NON-VEGETARIAN incorrect 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 The categorisation can also be represented as an aggregation. incorrect All men and women are patients. incorrect MC Consider the following EER model of a database which stores information about scientific publications.



Which statement is CORRECT? The EER model has weak entity types, but no existence dependent entity types. incorrect According to the EER model, two journals can never have the same title, even when they are being published by different publishers. incorrect According to the EER model, an author can be a reviewer of his/her own peer reviewed paper. correct According to the EER model, a scientific article can be at the same time a peer reviewed paper and a technical report. incorrect MC Which statement is NOT CORRECT? 'Chapter' will automatically be removed when 'Book' is removed. incorrect 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 weak entity type can only have one attribute type. correct MC Which variables types are not directly supported in UML? Variables with unique values (similar to key attribute types in the ER model) correct Derived variables incorrect Composite variables incorrect Multivalued variables incorrect