Chapter 3 - Fundamentals of DB
Systems exam review questions and
answers.
Data requirements - n
Ans✔
The result of this step is a concisely written set of users requirements. These
requirements should be specified in as detailed and complete form as possible.
Qs
Functional requirements - n
Ans✔
Consist of the user defined operations or transactions that will be applied to the
database, including both retrievals and updates.
Qs
Conceptual schema - n
Ans✔
Using a high-level conceptual data model, it includes detailed descriptions of the
entity types, relationships, and constraints;
Qs
True - n
Ans✔
The concepts in a conceptual design do not include implementation details.
Qs
Conceptual design - n
Ans✔
, This approach enables database designers to concentrate on specifying the
properties of the data, without being concerned with storage and implementation
details, which makes it easier to create a good conceptual database design.
Qs
Requirements collection and analysis --> data requirements - n
Ans✔
The first step or phase of database design
Qs
Conceptual design Space --> conceptual schema - n
Ans✔
The second step or phase of database design
Qs
Functional requirements - n
Ans✔
This step or phase runs parallel with the first step or phase of database design-
requirements collection and analysis
Qs
Logical design, or data model mapping - n
Ans✔
The third step or phase of database design, it results in a database schema in the
implementation data model of the DBMS
Qs
Physical design - n
Ans✔
The last step or phase of database design, During which the internal storage
structures, file organizations, indexes, access paths, and physical design
parameters for the database files are specified. In parallel with these activities,
Systems exam review questions and
answers.
Data requirements - n
Ans✔
The result of this step is a concisely written set of users requirements. These
requirements should be specified in as detailed and complete form as possible.
Qs
Functional requirements - n
Ans✔
Consist of the user defined operations or transactions that will be applied to the
database, including both retrievals and updates.
Qs
Conceptual schema - n
Ans✔
Using a high-level conceptual data model, it includes detailed descriptions of the
entity types, relationships, and constraints;
Qs
True - n
Ans✔
The concepts in a conceptual design do not include implementation details.
Qs
Conceptual design - n
Ans✔
, This approach enables database designers to concentrate on specifying the
properties of the data, without being concerned with storage and implementation
details, which makes it easier to create a good conceptual database design.
Qs
Requirements collection and analysis --> data requirements - n
Ans✔
The first step or phase of database design
Qs
Conceptual design Space --> conceptual schema - n
Ans✔
The second step or phase of database design
Qs
Functional requirements - n
Ans✔
This step or phase runs parallel with the first step or phase of database design-
requirements collection and analysis
Qs
Logical design, or data model mapping - n
Ans✔
The third step or phase of database design, it results in a database schema in the
implementation data model of the DBMS
Qs
Physical design - n
Ans✔
The last step or phase of database design, During which the internal storage
structures, file organizations, indexes, access paths, and physical design
parameters for the database files are specified. In parallel with these activities,
