DBMS06a Database Design 010

What is the purpose of data modelling in the database design process?

• To implement the internal database storage structure

• To describe the data, relationships, and constraints in a semi-formal representation

• To build the database user interfaces

• To create a high-level and abstract design phase

What are the characteristics of a database management system (DBMS)?

• Logical, coherent, and internally consistent

• Provides backup and recovery facilities

• Designed, built, and populated with data for a specific purpose

• Allows for multiple views of data and supports data independence

What is the purpose of high-level conceptual data models in database design?

• To represent the user's view of the database

• To define the internal database storage structure

• To implement the database user interfaces

• To provide flexible data-structuring capabilities

What is the main characteristic of external models in database design?

• Represent the user's view of the database

• Provide flexible data-structuring capabilities

• Contain data stored in the database

• Present a community view of the entire database

What is the purpose of a conceptual model in database design?

• To implement the internal database storage structure

• To represent the user's view of the database

• To present a community view of the entire database

• To provide a high-level and abstract design phase

What is the main characteristic of external models in database design?

• Contain data stored in the database

• Provide flexible data-structuring capabilities

• Represent the user's view of the database

• Present a community view of the entire database

What is the purpose of a conceptual model in database design?

• To represent the user's view of the database

• To provide a high-level and abstract design phase

• To present a community view of the entire database

• To implement the internal database storage structure

What is the main characteristic of external models in database design?

• Present a community view of the entire database

• Contain data stored in the database

• Represent the user's view of the database

• Provide flexible data-structuring capabilities

What is the purpose of a conceptual model in database design?

• To provide a high-level and abstract design phase

• To present a community view of the entire database

• To implement the internal database storage structure

• To represent the user's view of the database

What is the main characteristic of external models in database design?

• Provide flexible data-structuring capabilities

• Contain data stored in the database

• Present a community view of the entire database

• Represent the user's view of the database