MC	Consider the following EER model of a database which stores information about scientific publications.<br><br><img class="img-fluid" src="http://www.pdbmbook.com/static/quiz/fig3_10.png"><br><br>Which statement is CORRECT?	According to the EER model, an author can be a reviewer of his/her own peer reviewed paper.	correct	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, a scientific article can be at the same time a peer reviewed paper and a technical report.	incorrect	The EER model has weak entity types, but no existence dependent entity types. 	incorrect	
MC	Given the following EER specialisation:<br><br><img class="img-fluid"  src="http://www.pdbmbook.com/static/quiz/fig3_6.png"><br><br>According to the model, which of the following statements is CORRECT?	A supermarket product can be a food and non-food product at the same time.	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 meat product does not have any attributes types.	incorrect	
MC	<img class="img-fluid" src="http://www.pdbmbook.com/static/quiz/fig3_1.png"><br><br>Given the ER model above, which of the following statements is CORRECT?	A director of a movie can also act in the same movie.	correct	Producer is an existence dependent entity type.	incorrect	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	
MC	Which variables types are not directly supported in UML?	Derived variables	incorrect	Composite variables	incorrect	Variables with unique values (similar to key attribute types in the ER model)	correct	Multivalued variables	incorrect	
MC	Given the following EER categorisation:<br><br><img class="img-fluid" src="http://www.pdbmbook.com/static/quiz/fig3_7.png"><br><br>Which statement is CORRECT?	The categorisation can also be represented as a specialisation.	incorrect	A patient only inherits the 'Name' and 'Date of Birth' attribute types from the superclass that the current entity belongs to.	correct	All men and women are patients.	incorrect	The categorisation can also be represented as an aggregation.	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	Given the following EER categorisation:<br><br><img class="img-fluid" src="http://www.pdbmbook.com/static/quiz/fig3_7.png"><br><br>Which statement is CORRECT?	The categorisation can also be represented as an aggregation.	incorrect	All men and women are patients.	incorrect	The categorisation can also be represented as a specialisation.	incorrect	A patient only inherits the 'Name' and 'Date of Birth' attribute types from the superclass that the current entity belongs to.	correct	
MC	Which one of the following is an example of a DISJOINT and PARTIAL specialisation?	HUMAN -> LOVES FISH + LOVES MEAT	incorrect	HUMAN -> BLONDE + BRUNETTE	correct	HUMAN -> UNIVERSITY DEGREE + COLLEGE DEGREE	incorrect	HUMAN -> VEGETARIAN + NON-VEGETARIAN	incorrect	
MC	Which statement is CORRECT?	In case a ternary relationship type is represented as 3 binary relationship types, then semantics will get lost.	correct	A ternary relationship type cannot have attribute types.	incorrect	3 binary relationship types between 3 entity types can always be replaced by 1 ternary relationship type between the 3 participating entity types.	incorrect	A ternary relationship type can always be represented as 3 binary relationship types without loss of semantics.	incorrect	
MC	<img class="img-fluid" src="http://www.pdbmbook.com/static/quiz/fig3_2.png"><br><br>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'. <br><br>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 'PRODUCER' 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 'MOVIE' entity type.	incorrect