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 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 either one of the linked entity types. incorrect We can migrate the attribute type 'WORKING HOURS' to the 'PRODUCER' entity type. incorrect MC

Given the ER model above, which of the following statements is CORRECT? A movie can have multiple actors, producers and directors. incorrect A movie can have as many lead actors as there are in the movie. incorrect Producer is an existence dependent entity type. incorrect A director of a movie can also act in the same movie. correct MC Which variables types are not directly supported in UML? Derived variables incorrect Multivalued variables incorrect Variables with unique values (similar to key attribute types in the ER model) correct Composite variables incorrect MC Which statement is CORRECT? Inheritance is not supported in Object-Orientation. incorrect A class only has variables. incorrect Information hiding (also referred to as encapsulation) states that the variables of an object can only be accessed through either getter or setter methods. correct A class is an instance of an object. incorrect MC Which statement is CORRECT? A class only has variables. incorrect A class is an instance of an object. incorrect Information hiding (also referred to as encapsulation) states that the variables of an object can only be accessed through either getter or setter methods. correct Inheritance is not supported in Object-Orientation. 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 1 and a minimum multiplicity of 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 0 or 1 at the composite side. correct 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, 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 According to the EER model, two journals can never have the same title, even when they are being published by different publishers. incorrect MC Which statement is NOT CORRECT? Information hiding means that data can only be accessed via getter and setter methods. incorrect In UML, dependency defines a 'using' relationship which states that a change in the specification of a UML modeling concept may affect another modeling concept that uses it. incorrect An existence dependent entity type always participates in a 1:1 relationship type. correct This aggregation is composite. incorrect MC A composite aggregation... 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 has a maximum multiplicity of n and a minimum multiplicity of 0 or 1 at the composite side. incorrect MC Which statement is CORRECT? A weak entity type can only have one attribute type. incorrect An association is always bidirectional. incorrect A class is an instance of an object. incorrect Information hiding (also referred to as encapsulation) states that the variables of an object can only be accessed through either getter or setter methods. correct