Question 1

Which of the following statements about an associative entity is false?

Accepted Answer

Associative entity has a primary identifier.

Answer

Associative entity occurs if there’s a ternary relationship.

Answer

Associative entity is also known as a relationship entity.

Answer

Associative entity occurs for most of the many to many relationships.

Question 2

Which of the following is the main difference between an EERD and ERD?

Accepted Answer

EERD include inheritance; however, ERD does not.

Answer

All of the above.

Answer

EERD has more entities than ERD.

Answer

EERD has associative entities; however, ERD does not.

Question 3

Which of the following statements is true for the diagram below? Group them accordingly.

Question 4

Which of the following accurately describes the difference between total and partial inheritance? Group them accordingly.

Question 5

Which of the following statements accurately describes the difference between disjoint and overlap constraints?

Accepted Answer

Disjoint constraints ensure that an instance of the supertype can belong to only one subtype at a time, whereas overlap constraints allow for the possibility that an instance can be a member of multiple subtypes simultaneously.

Answer

Both disjoint and overlap constraints restrict an instance of the supertype from belonging to more than one subtype.

Answer

Disjoint constraints dictate that a subtype can be related to multiple supertypes, while overlap constraints restrict a subtype to only one supertype.

Answer

Disjoint constraints specify that an instance of the supertype can be a member of multiple subtypes simultaneously, whereas overlap constraints ensure an instance can belong to only one subtype at a time.

Question 6

Ata hospital, staff are rostered for an operation. Every operation would include one staff who is a surgeon, one duty doctor and multiple nurses.

Considering the business rule above, which of the following diagrams is correct?

Accepted Answer

https://uploads.quizalize.com/072f6768-21d0-4a01-a5e7-d8948a03386c/question/e6e94963df0a215a9981f813c71782c9b0dcdd0a.jpg

Answer

https://uploads.quizalize.com/072f6768-21d0-4a01-a5e7-d8948a03386c/question/44fe22952e99ddc1b0bcc49ea6df1a7024e12c75.jpg

Question 7

There are two types of books. Paper and e-books. Books are identified by an ISBN. Name and price of books are recorded. If it is a paper book, weight of the book is recorded. For e-books, downloadURL is recorded. Orders contain multiple paper books or e-books or both. Orders are identified using OrderID. Date and time are recorded for each order.

Considering the business rule above, which of the following diagram is correct?

Accepted Answer

https://uploads.quizalize.com/072f6768-21d0-4a01-a5e7-d8948a03386c/question/df3e561d56abc7cc541f64c87ee25ed0e560ca8d.jpg

Answer

https://uploads.quizalize.com/072f6768-21d0-4a01-a5e7-d8948a03386c/question/809eb3dbbde0c53e176891a7881e42c6947772a9.jpg

Related quizzes

Related quizzes