Lecture 1 Concepts of Database and Relational Database

Lecture 1 Concepts of Database and Relational Database System 412 753 Database Management Master of Arts Program in Library and Information Science 1

. 1 SDLC & DBLC SDLC Concepts Processes Data 1. Feasibility study DBLC Concepts Processes 1. Initial study 2. System analysis Procedures Network/sharing Management 3. System design 2. Database design 4. System development 3. Implementation & loading 5. Implementation Data 6. Testing 4. Testing & Evaluation 7. Operation 5. Operation 8. Maintenance 6. Maintenance 2

2. Database Initial Study l 2. 2 Typical Questions for Database Initial Study What data will be included in the database? , And how many set of data are there? l How is each data set related to each other? l How will the database be used? l What kind and format of reports will be produced from the database? l 4

. 3 Database Design l 3. 1 Conceptual design �� (Schema) �� Hierarchical, Network �� Relational l �� : Entity relationship diagram (E-R Diagram) l 5

. 3 Database Design l 3. 3 Physical design �� Logical design �� l �� l �� l l �� : Data dictionary, Input-Output design, User Interface design 7

Entity-Relationship Diagram : E-R Diagram l Entity �� 8

Entity-Relationship Diagram : E-R Diagram Property : �� entity l Identity : property �� l 9

Entity-Relationship Diagram : E-R Diagram l Relationship : entity set �� entity set 2 set �� entity l Relationship �� 2 entity set �� 10

Entity-Relationship Diagram : E-R Diagram l Relationship : entity set �� entity set 2 set �� entity l Relationship �� Identity �� entity set �� 11

�� Normalization l 1 NF (First Nornal Form) : l l l 1. �� Attribute �� Relational key 2. Attribute �� Relation Key �� Repeating Group 3. �� Attribute �� Relational key �� Relation �� 14

�� Normalization l 3 NF (Third Normal Form) : l . 1 �� Attribute 16