Info Systems in Organizations – Chapter 5
To represent relationships, are added to tables.
A. entity keys
B. normalized keys
C. foreign keys
D. locking keys
E. value keys
If a student is allowed to have multiple majors, and advisors for each major are assigned to multiple students, this would be an example of a(n) relationship.
A. 1:N
B. N:M
C. 1:1
D. one-of-a-kind
E. 0:M
Prior to implementing a database in a DBMS, the developers perform _ in order to improve the structure of the database tables. structuring normalization transformation data analysis modeling If Falcon Security chooses to use a SQL DBMS such as Access, it will be able to .
A. store the video footage in the same database as the metadata
B. face some risk and uncertainty while developing the database with
C. use a new, unfamiliar product to create the database
D. gain knowledge and experience with a new form of database
E. store only the metadata about each video in the database
The elements that make up a database application are: forms, application programs, reports, and .
A. backups
B. queries
C. data views
D. relationships
E. performance monitors
The following are all processing operations of a DBMS except _.
A. insert data
B. auto correct data
C. delete data
D. read data
E. modify data
In the context of a database, _ is data that describes the content of the database.
A. meta-elements
B. key data
C. metadata
D. mega data
E. predictive data
Which of the following is NOT a purpose of a database management system (DBMS)?
A. Establish relationships between tables.
B. Port the data to the Internet.
C. Enable the data to be backed up.
D. Enable data to be added and modified.
E. Create tables.
In data modeling, a(n) is something that the users want to store data about.
A. primary key
B. attribute
C. relationship
D. entity
E. foreign key
The three essential elements of the definition of a database are .
A. fields; relationship among fields in tables; metadata
B. tables; metadata; validation rules
C. tables; relationship among rows in tables; metadata
D. validation rules; data; tables
E. tables; relationship among rows in tables; validation rules