Explain the concept of logical design and list the steps involved
Logical design is the second stage in the database design process. The logical design goal is to design an enterprise-wide database that is based on a specific data model but independent of physical-level details. Logical design requires that all objects in the conceptual model be mapped to the specific constructs used by the selected database model.
The logical design is generally performed in the following four steps:
1 . Mapping the conceptual model to logical model components
2 . Validating the logical model using normalization
3 . Validating the logical model integrity constraints
4 . Validating the logical model against user requirements
You might also like to view...
) Information such as the report title, the writer's name, and the submission date are usually found
A) on the title page. B) on the title fly page. C) on the cover. D) in the letter of transmittal. E) in the letter of authorization.
The group with primary responsibility for development of a single set of accounting standards around the world is the
a. FASB b. SEC c. IFRS d. IASB
An expression of the hourly labor pay cost per function or job classification that is expected to exist during the next accounting period is the definition of a
a. direct labor time standard. b. direct materials quantity standard. c. direct labor rate standard. d. variable overhead rate.
Which of the following is used for long-term purchases on multiple dates over a period of time?
A. blanket purchase order B. standard purchase order C. planned purchase order D. electronic purchase order