{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lecture+8+Implementing+REA+Models-Student

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

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

View Full Document Right Arrow Icon
Implementing REA Models
Image of page 1

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

View Full Document Right Arrow Icon
Agenda Rules for good relational database design Establishing relationships
Image of page 2
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
Image of page 3

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

View Full Document Right Arrow Icon
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
Image of page 4
Rules for Good Database Design 3.  Referential integrity must exist.       
Image of page 5

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

View Full Document Right Arrow Icon
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
Image of page 6
Rules for Good Database Design 4.  Avoid redundancy
Image of page 7

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

View Full Document Right Arrow Icon
Rules for Good Database Design Sale Inv# Date Customer # 101 11/10/2010 C202 102 11/10/2010 C203 103 11/15/2010 C301 104 11/19/2010 C204 Inventory ProductID# Product Description ProdCurSellPr P1 Grade A Gold Pineapple $3.00 P2 Surf Board Pendant $7.00 P3
Image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.
  • Fall '10
  • EIGHME
  • Relational model, Database normalization, good database design, Customer City Honolulu Honolulu Honolulu Honolulu Customer State Hawaii Hawaii Hawaii Hawaii, ManyMany Relationships, Tony Emily Lee

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern