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
41. The mxed strategy database design approach starts with the identification of set of major entities and then spreading out.
- TRUE
- FALSE
42. The objective of developing a prototype of the system is to demonstrate the understanding of the user requirement and the functionality that will be provided in the proposed system.
- TRUE
- FALSE
43. The organised database structure gives advantage such as
- data redundancy
- data independence
- data security
- all of these
44. Structured system analysis and design (SSAD) is a software engineering approach to the specification, design. construction, testing and maintenance of software for
- maximizing the reliabiity and maintainability of the system
- reducing software life-cycle costs
- both (a) and (b)
- none of these
45. The database development life cycle (DDLC) is to meet strategic or operational inormation needs of an organisation and is a process of
- designing
- implementing
- maintaining
- all of these
46. The phisical 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
47. Which of the following is the SDLC phase that starts after the software is released into use?
- integration and testing
- development
- maintenance
- none of these
48. SDLC stands for
- software development life cycle
- scientific design life cycle
- scientific design of linear characterstics
- structured distributed life cycle
49. DDL stands for
- distributed database life cycle
- database development life cycle
- direct digital line connectivity
- none of these
50. The logical 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.