Class_8-9_REA_to_Access_Tables_lecture_n

Class_8-9_REA_to_Access_Tables_lecture_n - Relational...

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

View Full Document Right Arrow Icon
Relational Databases and Implementing REA Models in Microsoft Access Sept 28, 2011 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
IMPLEMENTING AN REA DIAGRAM IN A RELATIONAL DATABASE Once an REA diagram has been developed, it can be used to design a well-structured relational database.
Background image of page 2
IMPLEMENTING AN REA DIAGRAM IN A RELATIONAL DATABASE The three steps to implementing an REA diagram in a relational database are: Create a table for: Each distinct class in the diagram. Each many-to-many relationship. Assign attributes to appropriate tables. Use foreign keys to implement one-to-one and one-to-many relationships
Background image of page 3

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

View Full DocumentRight Arrow Icon
Employees (Supervisor) Order Inventory Employees Suppliers Inventory Call on Customer Take Cust. Order Employees (Salesperson) Customer Employees (Salesperson) Sales Receive Inventory Customer Suppliers Employees (Cashier) Receive Cash Employees (Cashier) Disburse Cash Cash Employee Time Time Worked Employees (as Payees) Our integrated diagram has eight event entities. 1 * 1 * 1 1 * * 1 1 1 * * * 1 1 * * 1 * * * 1 * * * * * 1 * * 1 * * * * * 1 1 1 * * * 1 1 1 * * * 1 1 * 1 1 * 1 *
Background image of page 4
Employees (Supervisor) Order Inventory Employees Suppliers Inventory Call on Customer Take Cust. Order Employees (Salesperson) Customer Employees (Salesperson) Sales Receive Inventory Customer Suppliers Employees (Cashier) Receive Cash Employees (Cashier) Disburse Cash Cash Employee Time Time Worked Employees (as Payees) 1 * 1 * 1 1 * * 1 1 1 * * * 1 1 * * 1 * * * 1 * * * * * 1 * * 1 * * * * * 1 1 1 * * * 1 1 1 * * * 1 1 * 1 1 * 1 * There are three distinct agent entities. The first is the customer.
Background image of page 5

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

View Full DocumentRight Arrow Icon
Employees (Supervisor) Order Inventory Employees Suppliers Inventory Call on Customer Take Cust. Order Employees (Salesperson) Customer Employees (Salesperson) Sales Receive Inventory Customer Suppliers Employees (Cashier) Receive Cash Employees (Cashier) Disburse Cash Cash Employee Time Time Worked Employees (as Payees) 1 * 1 * 1 1 * * 1 1 1 * * * 1 1 * * 1 * * * 1 * * * * * 1 * * 1 * * * * * 1 1 1 * * * 1 1 1 * * * 1 1 * 1 1 * 1 * The second agent class is the supplier.
Background image of page 6
Employees (Supervisor) Order Inventory Employees Suppliers Inventory Call on Customer Take Cust. Order Employees (Salesperson) Customer Employees (Salesperson) Sales Receive Inventory Customer Suppliers Employees (Cashier) Receive Cash Employees (Cashier) Disburse Cash Cash Employee Time Time Worked Employees (as Payees) Our integrated diagram has eight event entities. 1 * 1 * 1 1 * * 1 1 1 * * * 1 1 * * 1 * * * 1 * * * * * 1 * * 1 * * * * * 1 1 1 * * * 1 1 1 * * * 1 1 * 1 1 * 1 * The third agent class is the employee. We label the types of employees to make the diagram more understandable, but they all go in one 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
Four Functions of a RDBMS and Their Implementation in Access 1. Tables Data organization/structure Tools for creating and manipulating the structure of the Tables that form the database Access: Table Design View for modifying table structures; Datasheet View for presenting raw data in table 8
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 51

Class_8-9_REA_to_Access_Tables_lecture_n - Relational...

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