Relational data model and Create Table statement. Integrity rules. (Module 3.2) презентация
Содержание
- 2. Lesson Objectives Identify 1-M relationships and associated PKs and FKs Find
- 3. Integrity Rules Entity integrity: primary keys Each table has column(s)
- 4. Integrity Rule Violations
- 5. Oracle Relational Diagram
- 6. Summary Identify primary keys and foreign keys Visualize relationships Understanding existing
- 7. Скачать презентацию
Слайды и текст этой презентации
Слайд 1
Описание слайда:
Module 3
Relational Data Model and
CREATE TABLE Statement
Lesson 2: Integrity Rules
Слайд 2
Описание слайда:
Lesson Objectives
Identify 1-M relationships and associated PKs and FKs
Find errors in rows with either orphan FKs or missing FKs
Identify situations for FK requirements
FK is necessary
FK can have the null value
Слайд 3
Описание слайда:
Integrity Rules
Entity integrity: primary keys
Each table has column(s) with unique values
No missing values for primary keys
Ensures traceable entities
Referential integrity: foreign keys
Values of a column in one table match values from a source table
Ensures valid references among tables
Слайд 4
Описание слайда:
Integrity Rule Violations
Слайд 5
Описание слайда:
Oracle Relational Diagram
Слайд 6
Описание слайда:
Summary
Identify primary keys and foreign keys
Visualize relationships
Understanding existing databases is crucial to query formulation
Скачать презентацию на тему Relational data model and Create Table statement. Integrity rules. (Module 3.2) можно ниже:
