Course Details

Previous Page


Generic Design and Modeling Databases: Concepts and Conceptual Design


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/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.

Target Audience
People who want to get an understanding of the concepts and practices involved in designing relational databases

Prerequisites
None

Expected Duration (hours)
2.2

Lesson Objectives

Generic Design and Modeling Databases: Concepts and Conceptual 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
  • 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
  • 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
  • identify the steps for designing a database and create an ERD
  • Course Number:
    df_gdmd_a01_it_enus