MC	Which statement is CORRECT?	The Boyce-Codd normal form is more strict than the fourth normal form. 	incorrect	The referential integrity constraint poses that a primary key should never have a NULL value. 	incorrect	A prime attribute type is an attribute type that is part of a candidate key. 	correct	A superkey is a key that cannot have any of its attribute types removed. This is also called a minimal key. 	incorrect	
MC	Given the following relations:<br><br>Cinema(<u>name</u>, street, number, zip code)<br><br>Show(<u>movieID, <i>cinema name</i></u>, movie name, date, time)<br>'cinema name' is a foreign key referring to 'name' in 'Cinema'. This value cannot be NULL.<br><br>Which statement is CORRECT?	This relation is in 2NF, but not in 3NF. 	incorrect	This relation is in 3NF, but not in BCNF. 	incorrect	A movie can only be shown in one cinema. 	incorrect	A cinema can show multiple movies. 	correct	
MC	Consider the following ER model for a course administration.<br><br><img class="img-fluid" src="http://www.pdbmbook.com/static/quiz/fig6_12.png"><br><br>Which statement is NOT CORRECT?	When mapping the ER relationship type enrollment between Session and Student to the relational model, a new relation needs to be introduced. The 4 cardinalities of this ER relationship type can be perfectly mapped to the relational model.	incorrect	When mapping the ER relationship type teaches between Session and Teacher to the relational model, a new relation needs to be introduced. The 4 cardinalities of this ER relationship type can be perfectly mapped to the relational model.	correct	Both the ER and the relational model cannot enforce that a teacher can only teach sessions of courses for which he/she is qualified.	incorrect	When mapping the ER relationship type organizes between Course and Session to the relational model, the primary key "cnb" of the Course relation will be included as a NOT NULL foreign key in the Session relation. The 4 cardinalities of this ER relationship type can be perfectly mapped to the relational model.	incorrect	
MC	Which statement is CORRECT?	The first normal form is more strict than the Boyce Codd normal form.	incorrect	A relation is in 3NF if it is in BCNF and no prime attribute type of R is transitively dependent on the primary key. 	incorrect	A prime attribute type is an attribute type that is part of a candidate key. 	correct	The second normal form is more strict than the Boyce Codd normal form	incorrect	
MC	Given this relation in 1NF:<br><br>Reservation(customerID, roomID, customer name, room name, date, time)<br><br>Which of the following statement is correct?	A customer must have a unique name.	incorrect	The same room can be booked by the same customer on different dates and/or time.	incorrect	A customer can book multiple rooms at the same date and time.	correct	This relation is also in 2NF.	incorrect	
MC	Which statement is CORRECT?	A relation cannot have more than 1 foreign key.	incorrect	A foreign key can be NULL.	correct	A foreign key of a relation A cannot refer to the primary key of the same relation A.	incorrect	Every relation must have a foreign key.  	incorrect	
MC	Given the following relational model (primary keys are underlined, foreign keys in italics):<br><br>STUDENT(<u>studentnumber</u>, studentname, street name, street number, zip code, city)<br>ENROLLED(<u><em>student_number</em>, <em>course_number</em></u>)<br>COURSE(<u>course number</u>, course name)<br>PROFESSOR(<u>professor number</u>, professor name)<br>TEACHES(<u>course number, professor number</u>)<br><br>Which statement is CORRECT?	The model does not allow a course to be taught by multiple professors.	incorrect	The model does not allow a course to be followed by multiple students.	incorrect	The model does not allow a professor to teach multiple courses.	incorrect	The model can be further normalized.	correct	
MC	<img class="img-fluid" src="http://www.pdbmbook.com/static/quiz/fig2_6_3.png"><br>Which statement is NOT CORRECT when mapping the above EER model to a relational model?	The total EER specialization can be mapped to the relational model without loss of semantics. 	incorrect	A new relation should be created to model the EER relationship type between flight and airline.	correct	The Airline's primary key should be included as a NOT NULL foreign key in the relation 'Flight'.  	incorrect	A new relation should be created to model the EER relationship type between customer and commercial flight.	incorrect	
MC	Given this relation in 1NF:<br><br>Reservation(customerID, roomID, customer name, room name, date, time)<br><br>Which of the following statement is correct?	A customer can book multiple rooms at the same date and time.	correct	The same room can be booked by the same customer on different dates and/or time.	incorrect	A customer must have a unique name.	incorrect	This relation is also in 2NF.	incorrect	
MC	Given the following relational model (primary keys are underlined, foreign keys are in italics)<br><br>BOOK(<u>ISBN</u>, title, pages, price, <em>publishername</em>)<br>AUTHOR(<u>authorname</u>, date_of_birth)<br>WRITES(<u><em>authorname</em></u>, <u><em>ISBN</em></u>)<br>PUBLISHER(<u>publishername</u>, streetnumber, streetname, <em>zipcode</em>)<br>CITY(<u>zipcode</u>, city)<br><br>The assumptions are: <ul><li>Each book has a unique ISBN number</li><li>Each author has a unique name</li><li>Each publisher has a unique name</li><li>A book can have multiple authors</li><li>An auther can write more than one book</li><li>A publisher can publish more than one book</li><li>A book can have multiple publishers</li><li>A publisher has only one address</li></ul>Which statement is CORRECT?	The relational model is in third normal form.	incorrect	The relational model is in first normal form but not in second normal form.	incorrect	The relational model is not in first normal form.	correct	The relational model is in second normal form but not in third normal form.	incorrect