Entity-Relationship (E-R) model - ANSWER-Diagramming technique for entities, their attributes, and their relationships
Association between entities is
... [Show More] - ANSWER-Relationship
Binary relationship is between two - ANSWER-Entity types
"Binary" in binary relationship - ANSWER-two entity types
Cardinality of a relationship - ANSWER-Maximum number of entities that can be involved in the relationship
Modality of a relationship is - ANSWER-Minimum number of entities that can be involved in the relationship
One-to-one binary relationship - ANSWER-Involves two entity types
One-to-many binary relationship allows an occurrence of the entity type on the "one
side" of the relationship to be associated with - ANSWER-Multiple occurrences of the entity type on the "many side" of the relationship
Many-to-many binary relationship allows an occurrence of one entity type to be
associated with - ANSWER-Multiple occurrences of another entity type
Each professor is entitled to one parking space. This is an example of a _____ relationship. - ANSWER-One-to-one binary
Each professor has one office. The relationship between campus buildings and professors is a _____ relationship. - ANSWER-One-to-many binary (1 can have many)
Courses and their sections can best be
described as a _____ relationship. - ANSWER-one-to-many binary
Relationship between students and the professors who have been their instructors is a _____ relationship. - ANSWER-one-to-many binary
Intersection data - ANSWER-Describes the relationship between two entities in a many-to-many relationship
Each student at a university takes many courses; each course is taken by many students. The semester that a student took a course and the grade that the student received in the course is called _____ data. - ANSWER-Intersection
An associative entity is an alternate way of expressing a(n) _____. - ANSWER-many-to-many binary relationship
An one-to-one unary relationship _____. - ANSWER-involves a single entity type
An one-to-many unary relationship allows an occurrence of the entity type on the "one side" of the relationship to be associated with _____. - ANSWER-multiple occurrences of the same entity type
A many-to-many unary relationship allows an occurrence of one entity type to be associated with _____. - ANSWER-multiple occurrences of the same entity type
A ternary relationship allows an occurrence of one entity type to be associated with _____. - ANSWER-multiple occurrences of two other entity types
Every professor reports to another professor who is the department chair. This is a _____ relationship. - ANSWER-one-to-many unary
Each student is paired with another student for the purpose of getting assignments and turning in work for the other if he is out of school for any reason. This is a _____ relationship. - ANSWER-one-to-one unary
A university wants to keep track of which professor (1) taught which subject (2) to which student (3). This is a _____ relationship. - ANSWER-ternary
A single piece of data is _____ the business environment. - ANSWER-a fact about
An entity is _____ in the business environment. - ANSWER-an object or event
An entity set is a _____. - ANSWER-Collection of entities of the same type
An attribute is a _____. - ANSWER-Characteristic of an entity
What is a description of a particular entity? - ANSWER-Record occurrence
Which of the following is the unique identifier of an entity? - ANSWER-key
Which of the following does NOT change the contents of a file?
a. retrieve
b. insert
c. delete
d. update
e. all of the above - ANSWER-Retrieve
All of the following are basic principles of the database concept, EXCEPT _____.
a. maintaining redundant data that does not cause data integrity problems
b. the ability to store data in a non-redundant fashion
c. the ability to store data representing entities involved in multiple relationships
d. striving to achieve a high degree of data independence
e. data integration - ANSWER-a. maintaining redundant data that does not cause data integrity problems
All of the following are problems caused by redundant data, except _____.
a. wasted disk space
b. additional processing time for data updates
c. wasted network transmission time
d. potential data integrity problems
e. the possibility of having what should be the same data value in two different files having different values. - ANSWER-wasted network transmission time
Problems caused by two or more users trying to update the same data simultaneously fall primarily under the heading of _____. - ANSWER-concurrency control
Rebuilding a database after it is destroyed by a natural disaster is an aspect of _____. - ANSWER-backup and recovery
When data structures can be modified without affecting the programs that use the data, we say that the environment is highly _____. - ANSWER-data independent
A data definition language (DDL) ____. - ANSWER-specifies what tables will be in the database, what attributes will be in the tables, and which attributes will be indexed
A data manipulation language (DML) is capable of ____. - ANSWER-1. inserting new records or rows into a relation
2. deleting records or rows of a relation
3. retrieving data from a relation
Structured Query Language (SQL) ____. - ANSWER-1. is capable of retrieving data from a relational database
2. is capable of defining the tables, attributes, and indexes of a relational database
The SQL CREATE TABLE command is capable of doing all of the following, EXCEPT ____.
a. building indexes
b. specifying which attributes are unique
c. specifying which attributes serve as the primary key
d. specifying referential integrity constraints
e. specifying which attributes serve as foreign keys - ANSWER-a. building indexes
All of the following are SQL commands, EXCEPT ____.
a. CREATE TABLE
b. CREATE SELECT [Show Less]