Course Description
Database design is an important process for creating databases. In any organization, the process sets the foundation for good database implementation and ensures that everything required for the business is provided. It also ensures that the database will perform as expected for the users. In this course, you will learn how to design a database, including what database modeling and the design life cycle are. You will also learn how to meet the requirements for a database, how to analyze it, and how to work through the conceptual design phase.
Learning Objectives
Relational Database Design
- start the course
- describe the logical data model that is used during the design process of a database
- describe the physical data model that is used during the design process of a database
- describe the design methodology and outline the characteristics of a well-designed database
- use data modeling to represent real-world concepts
- describe the three-schema database architecture
- describe the three-schema database architecture mappings and data independence provisioning
Requirements Gathering
- describe the first two phases of the database design life cycle
- describe the last two phases of the database design life cycle
- identify the objectives for gathering information for the requirements of the database design phase
- describe the different techniques used for requirements gathering when designing a database
- identify the advantages and disadvantages of the techniques used to conduct interviews for database design
- identify the factors, types of questions, and who the interviewees will include when planning the interviews for database design
Conceptual Design
- describe what a conceptual design and an ERD are when designing a database
- define entities, attributes, and relationships for a conceptual ERD for designing a database
- determine the entities and attributes for a conceptual ERD for designing a database
- determine attributes for a conceptual ERD for designing databases
- determine the relationships between entities in a conceptual ERD for designing a database
- integrate views into an ERD for designing a database
- perform view integration into an ERD by performing step 1: preintegration analysis and step 2: comparison of schemas
- perform view integration into an ERD by performing step 3: conformation of schemas and step 4: merging and restructuring schemas
- create an ERD for a database based on a scenario
Practice: Designing a Database
- identify the steps for designing a database and create an ERD