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