Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management Systems Designing And Building Business Applications

Authors: Gerald V. Post

1st Edition

0072898933, 978-0072898934

More Books

Students also viewed these Databases questions

Question

What does Processing of an OLAP Cube accomplish?

Answered: 1 week ago