Ch 09: Enhanced ER (EER) Modeling

5 Questions5 MCQs0 Short Questions0 Long Questions
🎯 Exam Practice Papers
SEMESTER PASS

CS403 - Database Management Systems Examination Practice

Timed practice exam simulation for CS403 - Database Management Systems.

📘 VU MID TERM EXAMLectures 1 to 22
⏱️ 60 Mins

Mid Term Examination

Covers syllabus of Lectures 1 to 22 with 30 high-yield MCQs in a timed exam environment.

📝30 MCQs
⏱️60 Minutes
📗 VU FINAL TERM EXAMLectures 23 to 45
⏱️ 90 Mins

Final Term Examination

Comprehensive semester exam preparation with 45 MCQs covering Lectures 23 to 45 with complete course coverage.

📝45 MCQs
⏱️90 Minutes
Showing 1 – 5 of 5 Questions
Page 1 of 1
Q1
❓ MCQ📘 CS403📑 Lec 9🏷️ 09.2. Degree of Relationship (Unary, Binary, Ternary)Medium🔁⭐💡🌟📄🎓VU🏛️VU
Consider the ERD segment representing a '1:1 Sponsored Person' relationship. Since only a single entity type ('Person') participates in this association, which classification does this relationship fall under?
💻 sql Snippet
-- ERD Mapping: Person Sponsors Person (1:1 Unary Relationship)
-- STUDENT ROOMMATE or EMPLOYEE MANAGES are similar examples.
  1. A.Binary relationship
  2. B.Unary (recursive) relationship
  3. C.Ternary relationship
  4. D.N-ary relationship
Q2
❓ MCQ📘 CS403📑 Lec 9🏷️ 09.1. Relationships in E-R ModelEasy🔁⭐💡📄🎓VU🏛️VU
Under conceptual database modeling guidelines, which of the following terms describes a logical association among two or more participating database entity types?
💻 text Snippet
-- Conceptual relationship representation:
-- STUDENT (M) <--- ENROLLS ---> (N) COURSE
  1. A.Value Sets
  2. B.Cardinality
  3. C.Relationships
Q3
❓ MCQ📘 CS403📑 Lec 9🏷️ 09.1. Relationships in E-R ModelMedium🔁⭐💡📄🎓VU🏛️VU
Select the correct statement among the following on proper naming of schema constructs in Entity-Relationship modeling:
  1. A.Entity type names apply to all entities of that type and therefore plural names should be selected.
  2. B.In the narrative description of database requirements, verbs tend to indicate the names of relationship types.
  3. C.Nouns arising from a database requirement description can always be considered as names of attributes.
  4. D.Additional nouns which are appearing in the narrative description represent weak entity type names.
Q4
❓ MCQ📘 CS403📑 Lec 9🏷️ 09.1. Relationships in E-R ModelEasy🔁⭐💡📄🎓VU🏛️VU
In Entity-Relationship (ER) database modeling, which of the following is defined as a semantic association or connection among multiple entity types?
  1. A.Attribute
  2. B.Relationship
  3. C.Entity Instance
  4. D.Candidate Key
Q5
❓ MCQ📘 CS403📑 Lec 9🏷️ 09.1. Relationships in E-R ModelEasy🔁⭐💡📄🎓VU🏛️VU
In Entity-Relationship (ER) database modeling, which of the following is defined as a semantic connection or association among entities where there has to be a relationship between two entities?
  1. A.Value Sets
  2. B.Cardinality
  3. C.Relationships
  4. D.Attributes