Conceptual Logical Physical Design

Question 1

first stage in database design, the process that uses data modeling techniques to create database structure model

Answer 1

Conceptual Design

Question 2

All that is needed is there, all that is there is needed

Answer 2

Data Rule

Question 3

Discover the characteristics of the of the data elements

Answer 3

Data Analysis and Requirements

Question 4

Focus of the database designer

Answer 4

Information needs
Information users

Question 5

a brief and precise description of a policy, procedure, or principle within a specific organization’s environment.

Answer 5

Business rule.

Question 6

The process of defining business rules and developing the conceptual model using ER diagrams.

Answer 6

Entity Relationship Modeling and Normalization

Question 7

one of the last steps in the conceptual design stage, and it is one of the most critical.
In this step, the ER model must be verified against the proposed system processes to corroborate that they can be supported by the database model

Answer 7

Data Model Verification

Question 8

a subset of a database that is stored at a given location. The database fragment may be a subset of rows or columns from one or multiple tables.

Answer 8

database fragment