Question
1) The Entity-Relationship (E-R) model is _____. A) a diagramming technique that describes record structures (i.e. the fields that make up the records of a
1) The Entity-Relationship (E-R) model is _____.
A) | a diagramming technique that describes record structures (i.e. the fields that make up the records of a file) |
B) | an alternative to indexing and hashing as a means for providing direct access in files |
C) | a diagramming technique that describes entities, their attributes, and the relationships between them |
D) | an alternative to file design in which attributes are used instead of fields |
E) a diagramming technique that relates entities to each other, attributes to each other, and relationships to each other
2) All of the following events and factors in the early 1980s led to the introduction of relational database management, except ____.
A) | the introduction of personal computers |
B) | the fact that hierarchical and network DBMSs were too complex for the PC environment |
C) | the need for a DBMS approach that would make the database design process simpler than that of the hierarchical and network approaches |
D) | improvements in relational DBMS performance |
E) | improvements in mainframe computer performance. |
3) Performance issues delayed the introduction of relational database management systems as viable commercial products.
A) True B) False
4) The domain of values of the new column added to the relation to represent the unary one-to-many relationship is the same as that of the relations primary key.
A) True B) False
5) Representing a unary many-to-many relationship in a relational database requires the addition of one column to the relation that represents the single entity involved in the relationship.
A) True B) False
6) A unary many-to-many relationship involves two entities.
A) True B) False
7) A read or retrieve operation is the only one of the four fundamental operations that can be performed on a file that does change the data.
A) True B) False
8) Data redundancy _____.
A) | can occur across multiple files but not within a single file |
B) | can occur within a single file but not across multiple files |
C) | is a positive feature in the simple linear file environment but is a negative feature in the database environment |
D) | is a negative feature in the simple linear file environment but is a positive feature in the database environment |
E) | None of the above. |
9) An entity is the set of facts in a record.
A) True B) False
10) When different kinds of data (data about different entities) are merged in one file, a deletion anomaly _____.
A) cannot occur |
B) | causes a loss of data that may not be stored anywhere else |
C) | is helpful in reducing the amount of redundant data present |
D) | causes additional redundant data to appear |
E) | occurs as the result of an insertion anomaly |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started