Notice»

Recent Post»

Recent Comment»

Recent Trackback»

Archive»

« 2024/3 »
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31

Business database building

Education | 2011. 2. 23. 10:26 | Posted by 스마트 안전보건
What is wrong with flat files?

Redundancy

Multiple value problems - many supplier of ordered item

Update anomalies- change ph#

Insertion anomalies - new supplier

Deletion anomalies - delete supplier


Relational Database

Two or more tables that are linked together through common fields

Each table in can be joined with more than one table

Each row called a tuple

Each column has an allowable set of values called a domain

스크린샷_2011-02-22_오후_12.55.34.png

스크린샷_2011-02-22_오후_12.55.44.png 


Entity Relationship modeling

A database is a collection of entities

Entities contain properties called attributes - example - “title” for books

Relationship relate entity classes

▫ Book is writtenBy an Author

스크린샷_2011-02-22_오후_12.56.30.png

Purpose of Attributes

Describe important properties of entity

Help uniquely identify individual entities

▫ this is the primary key

▫ publisher id number, customer id number

Describe relationship between entities in different entity classes


Entity models to Relational Databases

We implement the abstract ER model to create a concrete database

▫ entity classes transform to relations

▫ attributes transform to fields

▫ entity sets transform to rows or tuples in relations

▫ one-to-many relationships modeled with foreign keys

▫ many-to-many relationships modeled with new table schemes

스크린샷_2011-02-22_오후_12.58.13.png 

스크린샷_2011-02-22_오후_12.58.23.png


Design Phase I: Create ER Diagram
Identify the entity 
Identify the A++ attribute - the primary key 
Identify relationships 
Identify cordinality
1 to many
many to many

e.g., Runner and Race
Runners participate races (many to many relationship)
A runner receives prizes (one to many relationship)

 

Design Phase II: Create table structure
Entities - tables
Attributes - columns
1 to many relationships

Many to many relationships

스크린샷_2011-02-22_오후_6.21.40.png

이 글은 스프링노트에서 작성되었습니다.

'Education' 카테고리의 다른 글

Typography (Typeface)  (0) 2011.02.26
4 basic design principles  (0) 2011.02.25
2011 Horizon Report (Ed. Tech.)  (0) 2011.02.19
TechTrends journal  (0) 2011.02.19
Relational Database Fundamentals  (0) 2011.02.18
: