Shared Flashcard Set

Details

Chapter 6
Relational Database Design: Converting Conceptual Models to Relational Databases
9
Accounting
Graduate
05/13/2012

Additional Accounting Flashcards

 


 

Cards

Term
Conceptual Model
Definition
represents reality in an abstracted form that can be used in developing an IS ina wide variety of formats
Term
Logical Model
Definition
represents reality in the format requred by a particular database model
Term
Physical Model
Definition
created specifically for a particular database software package
Term
Foreign Key
Definition
a primary key from a different table that has been postied into the table to create a link between the two tables
Term
rows
Definition
table extensions or tuples
Term
columns
Definition
attributes, table intentions or schema
Term
Entity Integrity
Definition
primary key in a table must not contain a null value
Term
Referential Integrity
Definition
a foreign key must either be null or already exist in another table
Term
One Fact, One Place
Definition
reduce redundancy, addresses load
Supporting users have an ad free experience!