ch02 - Chapter 2 Data Models and Relational Databases...

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

View Full Document Right Arrow Icon
Chapter 2 Data Models and Relational Databases
Background image of page 1

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

View Full DocumentRight Arrow Icon
Learning Objectives Identify primary and foreign keys for each entity and relevant relationships in the data model, Create tables that are properly linked with foreign keys or through relationship table(s), Examine a table design for any anomalies, and Normalize a table to the third normal form.
Background image of page 2
The Database Development Process Begins with enterprise modeling Setting the range and general contents of organizational databases Follows with conceptual data modeling Analyzing overall entities’ requirements based on transaction cycles Involves with logical database design Transforming the conceptual data model into a logical data model using relational data models
Background image of page 3

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

View Full DocumentRight Arrow Icon
Enterprise Modeling Figure 2-1 Overall REA Model for an Accounting Information System* Revenue Cycle Sale Duality Cash Receipt Financing Cycle Cash Receipt Duality Cash Disbursement Human Resource/ Payroll Cycle Labor Acquisition Duality Cash Disbursement Expenditure Cycle Purchase Duality Cash Disbursement Conversion (Production) Cycle Machine Operation Duality Finish Goods Inventory Labor Operation Duality Material Issurance Duality Financial Reporting System Cash Cash Cash Data Data Data Data Data Labor Materials Finished Goods
Background image of page 4
Conceptual Data Modeling (1,N) (1,1) (0,N) (1,1) (1,1) (1,N) (0,N) (1,N) (1,N) (1,1) (1,1) (0,N) (1,N) (1,N) (0,1) (0,N) (1,1) (1,1) (1,N) (1,1) (1,1) (1,N) (1,1) (1,1) (0,N) (1,1) Sale Inventory Cash (Bank Account) Cash Receipt Customer Outflow Inflow Duality Jesse Inflow Outflow Purchase Cash Disbursement Artist/Seller Duality Outside Participation Outside Participation Inside Participation Inside Participation Outside Participation Outside Participation Inside Participation Inside Participation Revenue Cycle Expenditure Cycle
Background image of page 5

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

View Full DocumentRight Arrow Icon
Complete REA Diagram for Cherokee’s Revenue Cycle (1,N) (0,1) (0,N) (1,1) (1,1) (1,N) (1,1) (1,1) (1,N) (1,1) (1,1) (0,N) (1,1) Sale Inventory Cash (Bank Account) Cash Receipt Jesse Customer Outflow Inflow Inside participation Outside participation Duality Outside participation Inside participation Resource Events Agents
Background image of page 6
Structure of a Relational Database The primary construct is called a relation or a table.
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.

This note was uploaded on 06/03/2010 for the course ECO 1000 taught by Professor Lee during the Spring '10 term at Queens University.

Page1 / 24

ch02 - Chapter 2 Data Models and Relational Databases...

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