🗊Презентация Relational data model and Create Table statement. Integrity rules. (Module 3.2)

Категория: Информатика
Нажмите для полного просмотра!
Relational data model and Create Table statement. Integrity rules. (Module 3.2), слайд №1Relational data model and Create Table statement. Integrity rules. (Module 3.2), слайд №2Relational data model and Create Table statement. Integrity rules. (Module 3.2), слайд №3Relational data model and Create Table statement. Integrity rules. (Module 3.2), слайд №4Relational data model and Create Table statement. Integrity rules. (Module 3.2), слайд №5Relational data model and Create Table statement. Integrity rules. (Module 3.2), слайд №6

Вы можете ознакомиться и скачать презентацию на тему Relational data model and Create Table statement. Integrity rules. (Module 3.2). Доклад-сообщение содержит 6 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

Слайды и текст этой презентации


Слайд 1





Module 3 
Relational Data Model and 
CREATE TABLE Statement
Lesson 2: Integrity Rules
Описание слайда:
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
Описание слайда:
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
Описание слайда:
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
Описание слайда:
Integrity Rule Violations

Слайд 5





Oracle Relational Diagram
Описание слайда:
Oracle Relational Diagram

Слайд 6





Summary
Identify primary keys and foreign keys
Visualize relationships
Understanding existing databases is crucial to query formulation
Описание слайда:
Summary Identify primary keys and foreign keys Visualize relationships Understanding existing databases is crucial to query formulation



Похожие презентации
Mypresentation.ru
Загрузить презентацию