Lecture 8 Implementing REA Models-Student

Lecture 8 Implementing REA Models-Student - Implementing...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Implementing REA Models Agenda Rules for good relational database design Establishing relationships Rules for Good Database Design 1. Entities become tables Each table must have a primary key, Each record must have a primary key value. (0,M) (0,1) Sale Cash Receipt Rules for Good Database Design 2. Relationships must be established. Post a create a relationship table or post a foreign key. (0,M) (0,1) Sale Cash Receipt Rules for Good Database Design 3. Referential integrity must exist. Rules for Good Database Design What problem exists? Customer Customer # Customer Name Customer Street Address Customer City Customer State C201 Pacific Foods 2 Coconut St. Honolulu Hawaii C202 Lawrence's Island Caf 4 Coconut St. Honolulu Hawaii C203 Island Shops 6 Coconut St. Honolulu Hawaii C204 Hawaiian Dairy Ice Cream 11 Coconut St. Honolulu Hawaii Sale Inv# Date Customer # 101 11/10/2010 C202 102 11/10/2010 C203 103 11/15/2010 C301 104 11/19/2010 C204 Rules for Good Database Design 4. Avoid redundancy Rules for Good Database Design S a l e In v # D a t e C u s t o m e r # 1 0 1 1 1 / 1 0 / 2 0 1 0 C 2 0 2 1 0 2 1 1 / 1 0 / 2 0 1 0 C 2 0 3 1 0 3 1 1 / 1 5 / 2 0 1 0 C 3 0 1 1 0 4 1 1 / 1 9 / 2 0 1 0 C 2 0 4 In v e n t o r y P r o d u c t ID # P r o d u c t D e s c r ip t io n P r o d C u r S e l l P r P 1 G r a d e A G o ld P in e a p p le $ 3 .0 0 P 2 S u r f B o a r d P e n d a n t $ 7 .0 0 P 3 P in e a p p le L o llip o p s...
View Full Document

Page1 / 25

Lecture 8 Implementing REA Models-Student - Implementing...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online