Overview Relation Domain Relation Degree Cardinality Catalog Relational
- Slides: 22
Overview • Relation • Domain • ������ Relation • Degree • Cardinality • Catalog ��� Relational Model 2
������ 1 ���� Relation ��� Employee EMPLO YEE Emp. ID 00001 00002 00003 Name Surname Sex ������� M ��������F 00004 ������� F Salary 10, 000 8, 000 12, 000 Dept. ID 01 02 03 9, 500 01 �� Relation “EMPLOYEE” ������ 4 Tuple ���������������� � 00001 – 00004 5 ����� Tuple ������ 6 Attribute ������ “Emp. ID”,
EMPLO YEE Emp. ID Name Surna Sex me 00001 �����M �� � Salary Dept. I D 10, 000 01, 03 00002 ������M 8, 000 02 ��� �� ������� Tuple ���� 00003 ������ F 12, 000 03 �� �� Emp. ID Name ����� Surna Sex Salary 00004 ���� F 9, 500 Dept. I 01 me D � �� 00001 �����M 10, 000 01 �� � 00001 �����M 10, 000 03 �� � 00002 ������M 8, 000 02 12
Degree • ����������� Attribute ��� Relation • ���� Relation “EMPLOYEE” ������� 6 • Relation ��������� 1 ���� “Unary” ���� 2 ���� “Binary” EMPLO YEE Emp. ID Name Surna me Sex 00001 �����M �� � 00002 ������M ��� �� Salary Dept. I D 10, 000 01, 03 8, 000 02 16
Catalog ��� Relational Model • ��������� Catalog ������� Relation ������������ Catalog ���������� Metadata • ����� Catalog ������ 2 Relation TABLE ����� “TABLES” ��� “COLUMNS” Tab. Nam Col. Na … COLUM S ������ Metadata ��� e. Relation me N Tab. Nam Col. Co Row. Co … ��� “EMPLOYEE” DEPART Dept. ID … e “DEPARTMENT” unt DEPART 2 MENT EMPLOY 6 EE … … 3 … 4 … … … MENT DEPART Dept. Na MENT me EMPLOY Emp. ID EE … … 18
EMPLO YEE Emp. ID Name Surna Sex me 00001 �����M �� � 00002 ������M ��� �� Salary Dept. I D 10, 000 01 8, 00003 ������ F 12, 000 �� �� 00004 ���� F 9, 500 SIT Emp. ID�����Site � �� E 00001 BKK 00005 �����M 15, 00004���� CNX 00005������ PHK M 00006 ����� 50, 00006 BKK 02 DEPART MENT Dept. ID Dept. Na me 01 ������ 21 03 02 ������� � 01 03 ������� 04 ������� 02 03 21
TABLE S Tab. Nam Col. Co Row. Co e unt DEPART MENT EMPLOY EE 2 4 6 6 SITE 2 4 COLUM N Tab. Nam Col. Na e me DEPART Dept. ID MENT DEPART Dept. Na MENT me EMPLOY Emp. ID EE EMPLOY Name EE EMPLOY Surna EE me EMPLOY Sex EE EMPLOY Salary 22
- Degree vs cardinality
- Domain codomain range
- Relational calculus symbols
- Object relational and extended relational databases
- Relational algebra and calculus
- Relational query language
- Relational algebra and relational calculus
- Domain relational calculus
- Methodologies for cross-domain data fusion: an overview
- Levelous
- Cardinality vs multiplicity
- Tosca cardinality
- Cardinality and modality in database
- Erd to table conversion
- Cardinality and countability
- Contoh partial participation
- Cardinality and modality
- Cardinality vs multiplicity
- Cardinality in cognos
- Cardinality vs multiplicity
- Language
- Associative entity relationship example
- Crow's foot notation