This module discussed the objectives of database design strategy and explored two distinct approaches to database design.
You discovered that a database has a three-tier architecture, and that one tier, namely the logical schema,
is the province of the designer.
You looked at a brief overview of the stages in the database life cycle (DBLC).
Finally, you learned about CASE tools that assist in designing databases.
Having completed the lessons in this module, you should be able to:
Describe the overall strategy of database design
Describe the subject approach to database design
Describe the application approach to database design
Define user view, logical schema, and physical schema
Describe the design stages in the database life cycle
Describe the post-design stages in the database life cycle
Explain the use of CASE tools in database design
This module introduced you to the following terms:
- business objects: Items in a business environment that are related, and about which data need to be stored (i.e. , customers, products, orders, etc.).
- Business rules: A set of rules or conditions describing the business polices that apply to the data stored on a company databases.
- conceptual model: A description of the structure of a database.
- data flow diagram: A diagram illustrating the flow of data in an organization, including data sources, data storage, and data transformation processes.
- data integrity: A term used to describe the quality (in terms of accuracy, consistency, and validity) of data in a database, in the sense that values required to
enforce data relationships actually exist.
Problems with data integrity occur when a value in one table that’s supposed to relate to a value in another can not because
the second value either has been deleted or was never entered.
- data redundancy: Duplication of data in a database.
- entity-relationship (ER) diagram: A diagram used during the design phase of database development to illustrate
the organization of and relationships between data during database design.
- information system: Interrelated components (e.g., people, hardware, software, databases, telecommunications,
policies, and procedures) that input, process, output, and store data to provide an organization with useful information.
- logical design: The second stage in the DBLC: creating a logical schema, followed by data normalization.
- logical schema: The overall logical plan of a database; typically a completed ER diagram.
- normalization: The process of applying increasingly stringent rules to a relational database to correct any problems associated with poor design.
- physical design: The third stage in the DBLC: tweaking data design elements to optimize database performance.
- physical schema: The underlying physical storage of data in a database, managed by the RDBMS.
- system administrator: The person responsible for administering a multi-user computer system; duties range from setting up and
configuring system components (e.g., an RDBMS) to performing maintenance procedures (e.g., database backups) on the system.
- user view: Specifies which users are permitted access to what data in a database.
The next module explores the stages in the database life cycle.
Before moving on to the next module, click the Quiz link below to check your knowledge of database design strategy and tools.
DB Strategy - Quiz