Study Guide for Exam 1

17 cards   |   Total Attempts: 182
  

Cards In This Set

Front Back
Surrogate key?
Random key with no business meaning
N-ary?
Relationship that associates data from more than two tables
Primary Key?
Relationship that associates data from more than two tables
Backend Processing
Processing that is done by the DBMS is typically referred to as
Linking or intersection entity.
Term best describes the entity Student Tutor
First Normal Form
Table that meets the requirements of a relation is said to be in which normal form
Table
Table that meets the requirements of a relation is said to be in which normal form
Class/Subclass or Supertype/Subtype
Whats is the special association that indicates that one entity can be broken down into multiple special cases?
Foreign Key
What is the special association that indicates that one entity can be broken down into multiple special cases?
Relationships
Whats is the special association that indicates that one entity can be broken down into multiple special cases?
ERD
Whats is the special association that indicates that one entity can be broken down into multiple special cases?
Attribute
Whats is the special association that indicates that one entity can be broken down into multiple special cases?
Maximum cardinality
Whats is the special association that indicates that one entity can be broken down into multiple special cases?
Referential integrity is
No orphan data
Data Independence
Ability to modify the data structure and not have to change the programs using that data is called: