Class 5- RDMS

Class 5- RDMS - ACCT361 Relational Database Management...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style ACCT-361 Accounting Information Systems Relational Database Management Systems (RDMS)
Background image of page 1

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

View Full Document Right Arrow Icon
Our hands-on learning for this  chapter . . . n We will begin Assignment #7 during today’s Class (#5) n To complete Assignment #7, we will: q Create a new Access database q Create tables n Primary keys and attributes q Create relationships and enforce referential integrity q Create composite primary keys q Enter data directly into tables.
Background image of page 2
Discussion n Assignment 5 – Process Modeling n *:* relationships and linking tables
Background image of page 3

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

View Full Document Right Arrow Icon
System Model Levels n A Conceptual model represents reality in an abstracted form that can be used in developing an information system in a wide variety of formats (e.g. relational, object-oriented, flat- file, etc.) q It is hardware and software independent q It is independent of any logical model type n A Logical model represents reality in the format required by a particular database model (e.g. relational or object-oriented) q Is still hardware and software independent q Depends on the chosen logical model type n A Physical model is created specifically for a particular database software package q Is dependent on hardware, software, and on the chosen logical model type
Background image of page 4
Conceptual Model (we use ER diagrams and REA  Sales personnel Customer Inventory Receive customer order Cashier Collect payment Cash Shipping personnel Shipping firm Ship Order (1,*) (1,*) (1,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (0,*) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1) (1,1)
Background image of page 5

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

View Full Document Right Arrow Icon
Logical model based on an RDMS logical model  type n Maintenance/Master Tables q INVENTORY: Inventory Item # , Description, Reorder Point, Current Price, Standard Cost, Beg Qty, Beg Qty Date, etc. . . q CUSTOMER: Customer # , Name, Address, etc. . . q EMPLOYEE: Employee # , Name, Address, etc. . . n Event Tables q RECEIVE CUSTOMER ORDER: Sales Order # , [Customer #], [Salesperson #], Date, Instructions, Cancel by Date, etc. . . q ORDER/INVENTORY: [Sales Order # ], [Inventory # ], Qty Ordered
Background image of page 6
File Versus Database Environments n Computer processing components: q data and instructions n Two methods for designing the interface between program instructions and data. q File-oriented processing - A specific data file is created for each application. q Data-oriented processing - Create a single data repository to support numerous applications. n Disadvantages of file-oriented processing: q Redundant data and programs q The format for similar fields may vary because the programmer used inconsistent field formats.
Background image of page 7

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

View Full Document Right Arrow Icon
Comparison of File Structures Mailing list: Customer Number, Customer Name, Customer Address . . . Order file:
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.

{[ snackBarMessage ]}

Page1 / 33

Class 5- RDMS - ACCT361 Relational Database Management...

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