ais_cybertext_chap6_notes

ais_cybertext_chap6_notes - Accounting Information Systems...

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

View Full Document Right Arrow Icon
Accounting Information Systems Introduction to AIS: Chapter 6: Elements of Database Systems LEARNING OBJECTIVES file-oriented approach vs. database approach
Background image of page 1

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

View Full DocumentRight Arrow Icon
discuss fundamental relational database concepts such as composite and foreign keys
Background image of page 2
specify the types of relationships that can be represented in database systems
Background image of page 3

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

View Full DocumentRight Arrow Icon
provide a detailed description of the relational database model Database Models: o Relational Relations (tables) o Tuples (rows-records) o Attributes (columns-fields) o Relationships between tables are implicit (using foreign keys) Rules for tables o Table names must be unique in the database o Every table must have a primary key o Duplicate rows and duplicate columns are not allowed o The order of rows and columns is immaterial discuss database integrity, emphasizing entity and referential integrity in particular Integrity constraints o Entity integrity – primary key field 1) cannot be null and 2) must be unique. o Referential integrity - foreign keys must 1) either be null or 2) match an existing value in the "master" table for the foreign key Detection of error : Tables must conform to a number of integrity constraints. Entity integrity and referential integrity are essential to ensure an error free database. Entity integrity prevents tables from having duplicate or missing primary keys which would prevent rows
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/06/2012 for the course ACCT 458 taught by Professor Gillett during the Fall '09 term at Rutgers.

Page1 / 7

ais_cybertext_chap6_notes - Accounting Information Systems...

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

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