🗊Презентация Conceptual design. Database Management Systems. Lecture 2

Категория: Информатика
Нажмите для полного просмотра!
Conceptual design. Database Management Systems. Lecture 2, слайд №1Conceptual design. Database Management Systems. Lecture 2, слайд №2Conceptual design. Database Management Systems. Lecture 2, слайд №3Conceptual design. Database Management Systems. Lecture 2, слайд №4Conceptual design. Database Management Systems. Lecture 2, слайд №5Conceptual design. Database Management Systems. Lecture 2, слайд №6Conceptual design. Database Management Systems. Lecture 2, слайд №7Conceptual design. Database Management Systems. Lecture 2, слайд №8Conceptual design. Database Management Systems. Lecture 2, слайд №9Conceptual design. Database Management Systems. Lecture 2, слайд №10Conceptual design. Database Management Systems. Lecture 2, слайд №11Conceptual design. Database Management Systems. Lecture 2, слайд №12Conceptual design. Database Management Systems. Lecture 2, слайд №13Conceptual design. Database Management Systems. Lecture 2, слайд №14Conceptual design. Database Management Systems. Lecture 2, слайд №15Conceptual design. Database Management Systems. Lecture 2, слайд №16Conceptual design. Database Management Systems. Lecture 2, слайд №17Conceptual design. Database Management Systems. Lecture 2, слайд №18Conceptual design. Database Management Systems. Lecture 2, слайд №19Conceptual design. Database Management Systems. Lecture 2, слайд №20
Скачать
Вы можете ознакомиться и скачать презентацию на тему Conceptual design. Database Management Systems. Lecture 2. Доклад-сообщение содержит 20 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

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

Слайд 1


Database Management Systems LECTURE 2 Conceptual Design IITU, ALMATY, 2019
Описание слайда:
Database Management Systems LECTURE 2 Conceptual Design IITU, ALMATY, 2019

Слайд 2


Database Design Stages Subject Area Analysis Conceptual Design Logical Design Physical Design
Описание слайда:
Database Design Stages Subject Area Analysis Conceptual Design Logical Design Physical Design

Слайд 3


Conceptual Modeling ER model (entity-relationship model) is a way of graphically representing the logical relationships of entities in order to create a database. The ER model was first proposed by Peter Chen of Massachusetts Institute of Technology (MIT) in the 1970s.
Описание слайда:
Conceptual Modeling ER model (entity-relationship model) is a way of graphically representing the logical relationships of entities in order to create a database. The ER model was first proposed by Peter Chen of Massachusetts Institute of Technology (MIT) in the 1970s.

Слайд 4


To design an ER model you should know … Entities Attributes Relationships
Описание слайда:
To design an ER model you should know … Entities Attributes Relationships

Слайд 5


First notation - Chen’s notation Entities (rectangle shape) Attributes (oval shape) Relationship (rhombus shape)
Описание слайда:
First notation - Chen’s notation Entities (rectangle shape) Attributes (oval shape) Relationship (rhombus shape)

Слайд 6


Example Entities: Students Teachers Subjects Attributes Students (stud_id, name, email, group) Teachers (teach_id, name, email, department) Subjects (id, name, credits)
Описание слайда:
Example Entities: Students Teachers Subjects Attributes Students (stud_id, name, email, group) Teachers (teach_id, name, email, department) Subjects (id, name, credits)

Слайд 7


ER-diagram with Chen’s notation
Описание слайда:
ER-diagram with Chen’s notation

Слайд 8


Different types of Notations Chen’s Notation Bachman notation IDEF1X Martin notation (Crow’s foot) min, max-notation UML class diagram
Описание слайда:
Different types of Notations Chen’s Notation Bachman notation IDEF1X Martin notation (Crow’s foot) min, max-notation UML class diagram

Слайд 9


Different types of Notations
Описание слайда:
Different types of Notations

Слайд 10


Relationships Types: One–to-One One-to-Many Many-to-Many Rows in a table can be linked to rows in other tables by adding a column for the unique key of the linked row (such columns are known as Foreign keys)
Описание слайда:
Relationships Types: One–to-One One-to-Many Many-to-Many Rows in a table can be linked to rows in other tables by adding a column for the unique key of the linked row (such columns are known as Foreign keys)

Слайд 11


One-to-one One instance of an entity (A) is associated with one other instance of another entity (B).
Описание слайда:
One-to-one One instance of an entity (A) is associated with one other instance of another entity (B).

Слайд 12


Example of one-to-one
Описание слайда:
Example of one-to-one

Слайд 13


One-to-many One instance of an entity (A) is associated with one or many instances of another entity (B), but for one instance of entity B there is only one instance of entity A.
Описание слайда:
One-to-many One instance of an entity (A) is associated with one or many instances of another entity (B), but for one instance of entity B there is only one instance of entity A.

Слайд 14


Example of one-to-many
Описание слайда:
Example of one-to-many

Слайд 15


Many-to-many One instance of an entity (A) is associated with one or many instances of another entity (B), and one instance of entity B is associated with one or many instances of entity A.
Описание слайда:
Many-to-many One instance of an entity (A) is associated with one or many instances of another entity (B), and one instance of entity B is associated with one or many instances of entity A.

Слайд 16


Example of many-to-many
Описание слайда:
Example of many-to-many

Слайд 17


Example of many-to-many
Описание слайда:
Example of many-to-many

Слайд 18


Example of many-to-many
Описание слайда:
Example of many-to-many

Слайд 19


Tools Gliffy.com Сreately.com Draw.io MS Visio Erwin etc.
Описание слайда:
Tools Gliffy.com Сreately.com Draw.io MS Visio Erwin etc.

Слайд 20


Books Connolly, Thomas M. Database Systems: A Practical Approach to Design, Implementation, and Management / Thomas M. Connolly, Carolyn E. Begg.- United States of America: Pearson Education Garcia-Molina, H. Database system: The Complete Book / Hector Garcia-Molina.- United States of America: Pearson Prentice Hall Sharma, N. Database Fundamentals: A book for the community by the community / Neeraj Sharma, Liviu Perniu.- Canada
Описание слайда:
Books Connolly, Thomas M. Database Systems: A Practical Approach to Design, Implementation, and Management / Thomas M. Connolly, Carolyn E. Begg.- United States of America: Pearson Education Garcia-Molina, H. Database system: The Complete Book / Hector Garcia-Molina.- United States of America: Pearson Prentice Hall Sharma, N. Database Fundamentals: A book for the community by the community / Neeraj Sharma, Liviu Perniu.- Canada

Скачать

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