Quiz
AIS 7
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (21)
1The best choice for the primary key in an “Employees” table would be his or her:
- ALast name
- BFirst name
- CPhone number
- DEmployee number
2From the following choices, the best example of a primary key for an employee table would be his or her:
- ASocial Security number
- BPhone number
- CLast name
- DOffice number
3The foreign key in one database table will always be a _______ key in a linked table.
- ASecondary key
- BDomestic key
- CPrimary key
- Dall of these are always true
4The terms "parent record," "child record," and "sibling record" describe the records in a:
- AHierarchical database
- BNetwork database
- CRelational database
- DFlat file
5A major advantage of relational databases is:
- AAll records are stored together
- BNo pointers are used
- CThe ability to add tables and relationships after the database becomes operational
- DIt closely resembles a flat file
6Which of these would be an example of an “agent” in the REA framework?
- ASalesperson
- BCustomer
- CManager
- Dall of these are possibilities
7Which of these would be an example of a “resource” in the REA framework?
- AEquipment
- BInventory
- CCash
- Dall of these are possible examples of resources
8In the REA framework, which of these would be recorded as an “event?”
- AHiring a new president of the company
- BTaking an initial sales order from a customer
- CBuying a piece of equipment for cash
- Dall of these would be recorded as events
9In the REA framework, an account receivable would be classified as a(n):
- AAsset
- BEvent
- CResource
- Dnone of these
10In the REA framework, a database designer should create a ____ for each entity.
- ARecord
- BTable
- CSecondary key
- DAll of these
11Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons. All of these would be likely data fields in a customer order table except:
- ACustomer name
- BCustomer number
- CDate of order
- DOrder number
12The purpose of the E-R model is to help database designers:
- AIdentify data redundancies
- BCreate databases in third normal form
- CDesign databases and depict data relationships
- DAnswer structured queries about the data in accounting databases
13Within a database context, the relationship between “natural parent” and “child” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
14Within a database context, the relationship between “military officer” and “private” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
15Within be:
a database context, the relationship between “students” and “classes” would most likely- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
16As described in the chapter, all of these are normalization “forms” except:
- AFirst normal form
- BSecond normal form
- CThird normal form
- Dall of these are normal forms
17The reason why database designers normalize data is:
- ATo eliminate data errors
- BTo scale data properly
- CTo create backup copies of data
- DTo create efficient database tables
18In the context of databases, the term data redundancy refers to:
- AStoring the same information in several records
- BRepeating data on multiple reports
- CUsing foreign keys which duplicate the values of primary keys
- Dall of these are possible examples of data redundancy
19A database is in third normal form if it is second normal form and:
- AIt contains no data redundancies
- BIt contains no foreign keys
- CIt contains no transitive dependencies
- Dall of these
20An example of a transitive dependency in a database is:
- AStudent > grade
- BTelephone area code > phone number
- CAirline > flight number
- DParking Code > parking fine amount
21An example of a transitive dependency in a database is:
- AStudent > university course number
- BParking ticket code > total of student parking fines
- CProduct number > product price
- DAge > social security number
Information
- Description
- 1 AIS Quiz on AIS 7, created by Rebecca Escobar on 11/12/2016.
- Author
- Rebecca Escobar
- Language
- English
- Views
- 5
- Tags
- Rating
- No ratings yet Rate this quiz