Город МОСКОВСКИЙ
00:23:15

#ERD #ERD_BANK_DATABASE ER Diagram- HOW TO DESIGN? | ER Diagram for Bank Database System

Аватар
Базы данных и MySQL Работа с графовыми структурами
Просмотры:
23
Дата загрузки:
08.12.2023 01:53
Длительность:
00:23:15
Категория:
Обучение

Описание

#ERD #ERD_BANK_DATABASE ER Diagram- HOW TO DESIGN? | ER Diagram for Bank Database System
Steps to Design ER Diagrams:
1) Identify the entity sets (including weak entity set)
Employees
Customers
Accounts
Branch
Loan
Payment (Weak entity set)

2) Identify all attributes of each entity set.
Ex:
Employee: Emp_id, Ename,Address, Email_id, DOJ, etc

3) Identify the relationship that exist between two entity sets.
Ex: In between Customer and Account, there is a Depositor relationship.

4) Join the entity set to relationship set and entity set to attributes via lines.

5) Show the mapping cardinality constraints in between different entity sets.

Source: Database System Concepts | 6th Edition Book by Henry F Korth

Рекомендуемые видео