BI 330 Test 1 Review

¡Supera tus tareas y exámenes ahora con Quizwiz!

In crow's foot style E-R diagrams, a hash mark across the relationship line near an entity indicates:

Both a minimum cardinality of one and a maximum cardinality of one

An ID-dependent entity is:

Both a special type of weak entity and an entity in which the identifier of the entity includes the identifier of another entity

Which of the following is not a function of the database application in a database system?

Control concurrency

Which of the following is a function of the database application in a database system?

Create and transmit queries

The creation of a database and its tables is a function of which component of the database system?

DBMS

Which of the following functional dependency diagrams accurately represents the following situation:

(BuildingName, RoomNumber) → (Capacity, Department)

Given only the following excerpt of an E-R model:

+<-Entity B

Microsoft Access 2013 database files are stored using the file extension:

.accdb.

Which of the following would not be contained in a use case?

A prototype of the system performing a given task

Which of the following is not true about a relation?

A relation may have duplicate column names.

Given only the following excerpt of an E-R model: Which of the following is known to be true?

A single instance of ENTITY B may be related to many instances of ENTITY A.

The default file format for Microsoft Access 2013 database files is the:

Access 2007 format.

Microsoft Access is a good tool for creating mock-ups of forms and reports because:

Access wizards make it easy to create the forms and reports.

Given the relations: STUDENT (SID, StudentName, Major, AdvisorID) ADVISOR (AdvisorID, AdvisorName, Office, Phone) such that each student is assigned to one advisor, which of the following is true?

AdvisorID is a foreign key.

Which of the following is true about a relation?

All entries in any column must be of the same kind.

A candidate key is:

All of these

A database may be used to help people:

All of these

A primary key is:

All of these

Although Microsoft Access is a personal database, it is still subject to the following modification problem(s):

All of these

Given the below functional dependency, MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage)

All of these

In the normalization process, if you find a candidate key that is not a determinant then you should:

All of these

Which of the following is true about a key?

All of these

Which of the following problems associated with storing data in a list is avoided by storing data in a relational database?

All of these

Microsoft Access can be used to prototype databases for which of the following DBMS products?

All of these Answers: Microsoft Access SQL Server MySQL Oracle Database

Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system?

All of these are sources for user requirements.

Which of the following is not a basic component of a database system?

ERD

Given only the following excerpt of an E-R model:

Many instances of ENTITY A may be related to one instance of ENTITY B.

Given the below functional dependency, MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage) which of the following statements is not known to be true?

MedicineName is a determinant.

In the normalization process, if you find a candidate key that is not a primary key then you should:

None of these

Which of the following is not true about null values?

Null values cannot be avoided.

Which of the following is a function of the DBMS in a database system?

Perform backup and recover

Which of the following would not be an example of database metadata?

Queries against records in the database tables

Which of the following terms is synonymous with "tuple"?

Row

The statement SELECT STUDENT StudentNumber FROM Student WHERE Student is an example of:

SQL

SQL stands for:

Structured Query Language.

Which of the following terms is synonymous with "relation"?

Table

Which of the following is true about identifiers of entities?

The value of an identifier may identify a set of entity instances.

Which of the following activities is not performed during the implementation phase of developing a database system?

Transforming the data model into a database design

Which of the following is not a basic element of the E-R Model?

Use cases

A use case can be used to perform which of the following tasks?

Validate the data model

Which of the following is not a stage in the development of a database system?

Validation

In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates:

a maximum cardinality of many.

In crow's foot style E-R diagrams, a circle across the relationship line near an entity indicates:

a minimum cardinality of zero.

A dashed line between entities indicates:

a nonidentifying relationship.

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called:

a referential integrity constraint

A relational database is:

a self-describing collection of related tables.

In crow's foot style E-R diagrams, a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent:

a supertype / subtype relationship.

The Microsoft Access 2013 form editor is a(n):

banded form editor.

The Microsoft Access 2013 report editor is a(n):

banded report editor.

During the normalization process, the remedy for a relation that is not well formed is to:

break it into two or more relations that are well formed.

In Microsoft Access, a relationship between two tables is created:

by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window.

A key that contains more than one attribute is called a(n

composite key.

A key that contains more than one attribute is called a(n):

composite key.

The Microsoft Access application generator is not responsible for:

creating tables.

The representation of the content, relationships, and constraints of the data needed to support the system requirements is the:

data model.

Microsoft SQL Server is an example of a:

database management system.

The number of entity classes involved in a relationship is known as the relationship's:

degree

In the Entity-Relationship data model, all instances of an entity of a given type are grouped into:

entity classes.

One important relational design principle is that:

every determinant must be a candidate key.

When the primary key of one relation is placed into a second relation, it is called a:

foreign key

The first step of the normalization process is to:

identify all the candidate keys of a relation.

In the normalization process, it is not necessary to:

identify all the foreign keys of a relation.

In Microsoft Access, relationships between tables are created:

in the Relationships window.

The component of a database that makes it self-describing is the:

metadata.

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the:

minimum cardinality.

The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a:

surrogate key.

A relational database stores data in the form of:

tables

In Microsoft Access, the relationship between two tables is not actually created until:

the Create button in the Edit Relationships dialog box is clicked.

Microsoft Access is a personal database system, and a personal database system is characterized by:

the DBMS product taking the role of the DBMS and the database application generator.

In the normalization process, if you find that every determinant in a relation is a candidate key then you have determined that:

the relation is well formed.

Today almost every commercial database is based on:

the relational model.

Microsoft Access can be used to build a prototype database, which allows users:

to validate the data model by demonstrating the consequences of data modeling decisions.


Conjuntos de estudio relacionados

Chapter 9: Groups in the Organization

View Set

Introduction to MasteringAstronomy

View Set

Biology - Unit 3- ch 4, 6, 27 and videos

View Set

Financial Statements, Taxes, and Cash Flow

View Set

Z370 Knowledge Checks Chapter 16, 12, 3, 4, 6, 5, 2)

View Set

Westward Expansion and Industrial Revolution

View Set

Ch. 15. Sales Promotion, Point of Purchase ADV, and Support Media

View Set

Exam II BCIS 5420 Final Dataset Combined

View Set