Generic Design and Modeling Databases: Concepts and Conceptual Design Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level 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
Expertise Level
Beginner