Chapter 6

Chapter 6 - Attribute Hierarchy for the Entity CLIENT...

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

View Full Document Right Arrow Icon
11 Attribute Hierarchy for the Entity CLIENT Attributes describe an entity – a client has a name, address, contact_person and phone-number.
Background image of page 1

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

View Full DocumentRight Arrow Icon
22 Key Attributes A unique attribute/value is needed to locate the desired record in the database. An attribute with a unique value is known as a key attribute. In implementing the database, the key attribute becomes the primary key.
Background image of page 2
33 Symbols used in E-R and REA Diagrams
Background image of page 3

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

View Full DocumentRight Arrow Icon
44 Relationship Types in the REA Model of the Client Billing Business Process
Background image of page 4
55 Example of a Relation
Background image of page 5

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

View Full DocumentRight Arrow Icon
66 An Integrated REA Model for the Client Billing and Human Resources Processes
Background image of page 6
77 Steps in Mapping an REA Model to a Relational DBMS 1. Create separate relational table for each entity. 2. Determine the primary key for each relation. The primary key must uniquely identify any row within the table. 3. Determine the attributes for each of the entities. 4. Implement the relationships among the entities by ensuring that the primary key in one table also exists as an attribute in every table for which there
Background image of page 7

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

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

Page1 / 18

Chapter 6 - Attribute Hierarchy for the Entity CLIENT...

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

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