Презентация на тему N-ary relations and their applications. (Rosen 8.2)

Презентация на тему Презентация на тему N-ary relations and their applications. (Rosen 8.2), предмет презентации: Математика. Этот материал содержит 20 слайдов. Красочные слайды и илюстрации помогут Вам заинтересовать свою аудиторию. Для просмотра воспользуйтесь проигрывателем, если материал оказался полезным для Вас - поделитесь им с друзьями с помощью социальных кнопок и добавьте наш сайт презентаций ThePresentation.ru в закладки!

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

Слайд 1
Текст слайда:

n-ary Relations and Their Applications

Rosen 8.2


Слайд 2
Текст слайда:

n-ary relations

We can have relation between more than just 2 sets

A binary relation involves 2 sets and can be described by a set of pairs
A ternary relation involves 3 sets and can be described by a set of triples


An n-ary relation involves n sets and can be described by a set of n-tuples

Relations are used to represent computer databases

Also used to represent constraints!


Слайд 3
Текст слайда:

n-ary relations

n-ary Relations


Слайд 4
Текст слайда:

n-ary relations

n-ary Relations

Note: N is the set of natural numbers {0,1,2,3,…}

An example

Note: R could be considered as an extensional representation of the
ternary relation a

The relation has degree 3

The domains of the relation are the set of natural numbers


Слайд 5
Текст слайда:

n-ary relations

n-ary Relations

Note: N is the set of natural numbers {0,1,2,3,…}
Z is the set of integers {…,-2,-1,0,1,2,…}

An example

Note: R could be considered as an extensional representation of the
ternary relation a

The relation has degree 4


Слайд 6
Текст слайда:

Relational databases

Database is made up of records.
Typical operations on a database are

find records that satisfy a given criteria
delete records
add records
update records

Some everyday databases
student records
health records
tax information
telephone directories
banking records

Databases may be represented
using the relational model


Слайд 7

Слайд 8

Слайд 9
Текст слайда:

Relational databases

The relational data model

Database made up of records, they are n-tuples, made up of fields

Student record might look as follows

(name,metricNo,faculty,gpa)

(Jones,200401986,Arts,4.9)
(Lee,200408972,Science,3.6)
(Kuhns,200501728,Humanities,5.0)
(Moore,200308327,Science,5.5)

relations (in relDB) also called tables

gpa is an attribute


Слайд 10
Текст слайда:

Relational databases

The relational data model

Example from the book

Attributes: name, metric No, Dept and GPA


Слайд 11
Текст слайда:

Relational databases

The relational data model

primary key:
An attribute/domain/column is a primary key when
the value of this attribute uniquely defines tuples
i.e. no two tuples have the same value for that attribute

Name cannot be a primary key, neither can Dept or GPS
metricNo is a primary key


Слайд 12
Текст слайда:

Relational databases

The relational data model

The current collection of n-tuples (records) in the relation (table)
is called the extension of the relation

The permanent aspects of the relation (table) such as the attribute names
is called the intention of the relation


Слайд 13
Текст слайда:

Relational databases

The relational data model

A composite key is a combination of attributes
That uniquely define tuples


Слайд 14
Текст слайда:

Relational databases

Operations on n-ary relations

Selection


Слайд 15
Текст слайда:

Relational databases

Operations on n-ary relations

Selection


Слайд 16
Текст слайда:

Relational databases

Operations on n-ary relations

Projection

It strips out specific columns


Слайд 17
Текст слайда:

Relational databases

Operations on n-ary relations

Projection


Слайд 18
Текст слайда:

Relational databases

Operations on n-ary relations

Join

Joins two tables/relations together, matching up on specific attributes


Слайд 19
Текст слайда:

Relational databases

Operations on n-ary relations

Join


Слайд 20
Текст слайда:

Explain the previous slide

Explain how what we do differs from what will
be presented in IM2


Обратная связь

Если не удалось найти и скачать презентацию, Вы можете заказать его на нашем сайте. Мы постараемся найти нужный Вам материал и отправим по электронной почте. Не стесняйтесь обращаться к нам, если у вас возникли вопросы или пожелания:

Email: Нажмите что бы посмотреть 

Что такое ThePresentation.ru?

Это сайт презентаций, докладов, проектов, шаблонов в формате PowerPoint. Мы помогаем школьникам, студентам, учителям, преподавателям хранить и обмениваться учебными материалами с другими пользователями.


Для правообладателей

Яндекс.Метрика