DBMS-Enhanced Entity-Relationship (EER) Model Questions and Answers
The DBMS Enhanced Entity-Relationship (EER) Model questions with answers help students understand advanced database modeling techniques like specialization, generalization, and aggregation. These database programming questions and answers are important for placements and competitive exams where data modeling and schema design play a key role. Practicing EER model MCQs improves your conceptual understanding and helps you perform better in DBMS interviews and tests by TCS, IBM, and Infosys. Learn the extended concepts of ER modeling with clear explanations and real-world examples.
DBMS-Enhanced Entity-Relationship (EER) Model
Showing 10 of
57 questions
51. The conceptual database design is the process of
- deriving the physical structure of the database
- creating a conceptual and external schemas for the high-level data model
- analysing overall data requirements.
- None of these.
52. Which of the following design is both hardware and software independent ?
- physcal database design
- logical database design
- conceptual database design
- none of these
53. Which of the following design is both hardware and software independent ?
- physical database design
- logical database design
- conceptual database design
- none of these
54. Which of the following design is both hardware and software independent ?
- physical database design
- logical database design
- conceptual database design
- none of these
55. The bottom-up database design approach starts at the
- fundamental level of attributes
- development of data models that contains high-level abstractions
- indentification of set of major entities
- all of these
56. The top-down database design approach starts at the
- fundamental level of attributes
- development of data models that contains high-level abstractions.
- identification of seet of major entities.
- all of these
57. A functional dependency (FD) is a property of the information represented by the relation.
- TRUE
- FALSE