ISTM 210 EXAM 4 QUESTIONS AND ANSWERS
An ___ is anything about which the organization wishes to store data. - answers -entity
Information about the ___ of an entity are stored in ___. - answers -attributes, fields
All the fields containing data about an entity form a ___. - answers -record
A set of all related records form a ___. - answers -file
A set of interrelated, centrally coordinated files form a ___. - answers -database
In access, we are dealing with ___ databases. - answers -relational
A ___ ___ is an attribute in one table that is a primary key in another table. - answers -
foreign key
What are used to link tables together? - answers -foreign keys
Multiple occurrences could lead to inconsistent data - answers -update anomaly
Records in tables that are not complete - answers -insert anomaly
Removing some information removes an entire record - answers -delete anomaly
You want ___ databases. If you have this, you won't have any anomalies. - answers -
normalized
This makes sure that you can't refer to an item in a database that doesn't exist -
answers -referential integrity
What ensures data integrity? - answers -data validation
Sql - answers -structured query language
Two reasons for a minimum or zero: - answers -optional, timing
If you have a many to many relationship, there will be at least ___ tables. - answers -
three
Dbm - answers -database management system
Erm - answers -entity relationship model
An ___ is anything about which the organization wishes to store data. - answers -entity
Information about the ___ of an entity are stored in ___. - answers -attributes, fields
All the fields containing data about an entity form a ___. - answers -record
A set of all related records form a ___. - answers -file
A set of interrelated, centrally coordinated files form a ___. - answers -database
In access, we are dealing with ___ databases. - answers -relational
A ___ ___ is an attribute in one table that is a primary key in another table. - answers -
foreign key
What are used to link tables together? - answers -foreign keys
Multiple occurrences could lead to inconsistent data - answers -update anomaly
Records in tables that are not complete - answers -insert anomaly
Removing some information removes an entire record - answers -delete anomaly
You want ___ databases. If you have this, you won't have any anomalies. - answers -
normalized
This makes sure that you can't refer to an item in a database that doesn't exist -
answers -referential integrity
What ensures data integrity? - answers -data validation
Sql - answers -structured query language
Two reasons for a minimum or zero: - answers -optional, timing
If you have a many to many relationship, there will be at least ___ tables. - answers -
three
Dbm - answers -database management system
Erm - answers -entity relationship model
