Exam Review Flashcards
1
Q
What are business rules?
A
- Specifications that preserve the integrity of a conceptual or logical data model
- Stored as part of the database
2
Q
What are the 4 types of business rules?
A
- entity integrity
- referential integrity
- domains
- triggering operations (last resort)
3
Q
What is entity integrity?
A
Each instance of an entity must have a unique identifier that is not null (primary key)
4
Q
What is referential integrity?
A
- Rules governing the relationships between entities
- Refer to the foreign keys which link tables
5
Q
What are domains?
A
Associated with constraint thats that restrict the values permitted in a column
6
Q
What is triggering operations?
A
- Rules that are invoked on the action of data manipulation operations (INSERT, UPDATE, DELETE)
7
Q
What are stored procedures?
A
pieces of executable code stored in the database.
8
Q
What is a cursor?
A
iterates through a select set one entry at a time
9
Q
What are some extra features of stored procedures?
A
Stored Procedures:
- can be passed values
- not attached to a specific table
- must be called by programs, triggers, or manually
10
Q
What are triggers?
A
- attached to a specific table
- can’t pass values
- run automatically based on an event (insert, update, delete) ** event driven **
11
Q
What is a ROLLBACK TRANSACTION?
A
cancels an event
