INSY 3304 QUIZES (CH.1-2)
The external model is the representation of the database as "seen" by the DBMS. True False
F
Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user. True False
F
In Chen notation, entities and relationships have to be oriented horizontally; not vertically. False True
F
In an SQL-based relational database, each table is dependent on every other table. False True
F
One advantage of a database system over previous data management approaches is that the database system is considerably less complex. False True
F
The DBMS reveals much of the database's internal complexity to the application programs and users. False True
F
A data model is usually graphical. True False
T
An implementation-ready data model should contain a description of the data structure that will store the end-user data. True False
T
Business rules must be rendered in writing. False True
T
In an SQL-based relational database, rows in different tables are related based on common values in common attributes. False True
T
A noun in a business rule translates to a(n) _____ in the data model. a) entity b) constraint c) attribute d) relationship
a
The _____ data model is said to be a semantic data model. a) object-oriented b) relational c) network d) entity relationship
a
A(n) _____ is bidirectional. a) entity b) relationship c) constraint d) attribute
b
In the _____ model, each parent can have many children, but each child has only one parent. a) relational b) hierarchical c) network d) entity relationship
b
A data warehouse contains historical data obtained from the _____. a) desktop database b) enterprise databases c) operational databases d) workgroup databases
c
A(n) _____ is a restriction placed on the data. a) attribute b) entity c) constraint d) relationship
c
A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. a) operating system b) database management system c) application d) query
c
Most data that can be encountered are best classified as _____. a) structured b) unstructured c) semistructured d) historical
c
Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models. a) relational b) hierarchical c) XML Hybrid d) file system
c
VMS/VSAM is an example of the _____. a) relational data model b) XML data model c) file system data model d) hierarchical model
c
_____ are normally expressed in the form of rules. a) Relationships b) Attributes c) Constraints d) Entities
c
End-user data is _____. a) information about a specific subject b) knowledge about the end users c) accurate, relevant and timely information d) raw facts of interest to the end user
d
The _____ data model uses the concept of inheritance. a) relational b) network c) entity relationship d) object-oriented
d
The organization of data within folders in a manual file system is determined by _______. a) the title of the documents in the folder b) its date of creation c) the data processing specialist d) its expected use
d
The database structure in a DBMS is stored as a _____. b) collection of queries c) single file d) set of key/value pairs e) collection of files
e
