Term
| What is redundancy and why should it be avoided in relational databases? |
|
Definition
| Redundancy is the unnecessary repeating of data in a database. Should be avoided to save space and prevent errors due to having to update several places for one change |
|
|
Term
| What is Data Independence |
|
Definition
| The separation of the data definition from the program. It enables one to change the data definition without altering the program |
|
|
Term
| What is Referential Integrity |
|
Definition
| Specifies that each non-null foreign key must match a primary key value in a related table |
|
|
Term
| What does cascade delete do if referential integrity is enforced and cascade delete is set? |
|
Definition
| If a record in a primary table is deleted all corresponding records in related tables are deleted. |
|
|
Term
| What are the properties of a primary key |
|
Definition
Unique
Not Null
Non Changing
Minimal |
|
|
Term
| Give an example of a business event that would trigger some function |
|
Definition
| Cust orders something. It decrements orders on hand and maybe triggers an auto order of that product if it brings inventory under threshhold |
|
|
Term
| Example of insertion anomaly in table |
|
Definition
| A course cannot be added with out a student |
|
|
Term
| Example of insertion anomaly from table |
|
Definition
| If you update Ben Thompson's phone on first row it won't update on last row |
|
|
Term
| Give an example of deletion anomaly |
|
Definition
| If you delete course HI1043 you also delete the instructor |
|
|
Term
| In the client/server model, where does the database reside |
|
Definition
|
|
Term
| Tables in first normal form (1NF) |
|
Definition
| do not have any repeating groups |
|
|
Term
| One of the first phases of a new database project that involves critical areas, expensive hardware or software within the organization is called |
|
Definition
|
|
Term
| Which component of the DBMS most affects the performance (speed) |
|
Definition
|
|
Term
| The term referring to a physical item existing in the real world that you want to track is called |
|
Definition
|
|
Term
| Two different terms are used to describe the characteristics of interest for an entity. They are Properties and |
|
Definition
|
|
Term
| Database system modelers use this type of diagram to graphically represent both the data structure and how the different objects are interrelated |
|
Definition
|
|
Term
|
Definition
| Have all non-key fields depend on nothing but the primary key |
|
|
Term
| The process to properly define the database tables to provide flexibility, minimize redundancy and ensure data integrity is called |
|
Definition
|
|
Term
| Business rules can be represented in the database through |
|
Definition
|
|
Term
| Missing data in a field is a |
|
Definition
|
|
Term
| In a university environment, what is the appropriate multiplicity for an association liking courses with their list of prerequisite courses? focus on the numbers placed next to the 'Prerequisite courses' side of the association |
|
Definition
|
|
Term
| a data type that creates unique numbers for key columns in Microsoft Access is |
|
Definition
|
|
Term
| Tables in second normal form |
|
Definition
| have all non-key fields depend on the whole primary key |
|
|
Term
| Which of the following can be addressed by enforcing a data integrity constraint |
|
Definition
| Valid input for the gender property is either M, F, Unknown |
|
|
