MGIS 320 Midterm

The compound criteria (conditions) are created by using ____.​

AND, OR

A good ____ should provide an opportunity for users to incorporate integrity constraints when the database is designed.

DBMS

A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database.​

DBMS

A(n) ____ frees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data.

DBMS

A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet or an accounting ledger.​

Data File

During the ____ process, a database expert determines the structure of the required database.​

Database Design

In the following table, which attribute could be the foreign key? Empoyee (FirstName, LastName, HireDate, DepartmentID, EmployeeNum)

DepartmentID

Combining the following two tables would result in ____.​ Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum) Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)

Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode)

In the following table, which attribute could be the primary key? Employee (FirstName, LastName, HireDate, DepartmentName, EmployeeNum)

EmployeeNum

A(n) ____ is a person, place, object, event, or idea for which you want to store and process data.​

Entity

A visual way to represent a database is with a(n) ____.

Entity-Relationship Diagram

A column whose value uniquely identifies a given row in the table is the foreign key.​

False

A enterprise-level database model is more detailed than a project-level database model.

False

An entity is also defined as an attribute.

False

An unnormalized relation is a table that has more than one row.​

False

During the database design process, DBMS Selection should be done between logical design stage and physical design stage.

False

In a one-to-many relationship, the primary key of the "many" side table becomes the foreign key of the "one" side table.​

False

In a relation, the order of rows is important.​

False

In a relation, the order of the columns is important.

False

In an AND criterion, the overall criterion is true if either of the individual criteria is true.​

False

In an entity-relationship diagram, rectangles represent foreign keys.​

False

In relational database, repeating group means duplicated rows.

False

In the top-down design method, specific user requirements are synthesized into a design.​

False

One way to indicate a one-to-many relationship is to place a crow's foot at the "one" side of the relationship.​

False

Physical design is hardware independent.

False

Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly, rather than having to access it through the DBMS.​

False

Redundancy wastes space because you are storing different types of data in the same place.

False

Relationship is an association between two attributes.

False

The bottom-up design method begins with a general database design that models the overall enterprise and repeatedly refines the model to achieve a design that supports all necessary applications.​

False

The comparison operators are +, *, %, and /.​

False

The concept of grouping means that statistics will be calculated for individual records.​

False

There is a greater impact of failure in a nondatabase, file-oriented system.​

False

To create forms to use with a database you must write a program.​

False

To list the records in a query's results in a particular order, you need to group the records.​

False

​In an E-R diagram, a dashed line represents an identifying relationship and a solid line represents a nonidentifying relationship.

False

​____ are screen objects used to maintain, view, and print data from a database.

Forms

Which of the following statements is correct?​

In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files.

A database has ____ if the data in it satisfies all established integrity constraints.​

Integrity

Which operation will allow you to extract data from more than one table?​

Join

The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.​

Primary

The type of information collected on the survey form that describes how data is updated is ____.

Processing information

Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.​

RDBMSs

Storing the same data in more than one place is called ____.

Redundancy

RDBMS stands for ____.

Relational Database Management System

Based on the statement below, which of the following could be the primary key? Rep (RepNum, LastName, FirstName, Street, City, State, PostalCode Commission, Rate)

RepNum

Forms and ________ are two tools provided by the DBMS.

Reports

In the following table, indicate the foreign key(s). SaleLine (SaleID, ProductID, Quantity, Price)

SaleID and ProductID

In the following table, indicate the primary key. SaleLine (SaleID, ProductID, Quantity, Price)

SaleID+ProductID

____ is the prevention of unauthorized access to the database.​

Security

A relation is a(n) ____.​

Table

____ means that an entity has a minimum cardinality of zero.​

The entity is not required in the relationship.

____ means that an entity has a minimum cardinality of one.​

The entity is required in the relationship.

After the information-level design is completed, ____ is the next step.​

The physical-level design

A DBA can assign passwords to prevent unauthorized users from accessing the data.​

True

A database file requires a large amount of disk space and internal memory.

True

A database will not only hold information about multiple types of entities, but also information about the relationships among these multiple entities.

True

A foreign key is a column or collection of columns in one table that is required to match the value of the primary key in another table, or be null.

True

A good DBMS has many features that allow users to gain access to data in a database without having to do any programming.​

True

A person or a group of people in charge of a database within an organization is often called the DBA (database administration).

True

A program, or collection of programs, through which users interact with a database is known as a DBMS.

True

A query is a question represented in a way that the DBMS can recognize and process.

True

A relational database handles entities, attributes, and relationships by storing each entity in its own table.​

True

A relational database is a collection of relations.

True

A relationship that is not necessary for identification is called a(n) non-identifying​ relationship.

True

A(n) relational database is a collection of tables.​

True

Access automatically adds double quotation marks around values in the design grid that are formatted as Short Text fields when you run the query or move the insertion point to another cell in the design grid.​

True

An E-R model is made of entities, attributes and relationships.

True

An advantage of using the database approach to processing is that it facilitates consistency.​

True

An attribute is a characteristic or property of an entity.

True

An attribute is known as a column in relational databases.

True

An entity is an information category.

True

An entity-relationship (E-R) model is an approach to representing data in a database.

True

Base on the database project scope, there are two types of design: centralized design and decentralized design.

True

By using bridge table, we transfer one many-to-many relationship to two one-to-many relationships.

True

Cardinality refers to the number of entity occurrences that must be included in a relationship.​

True

Columns in a table are often called fields.

True

Comparing with structured data, unstructured data doesn't have a pre-defined data model.

True

Conditions that data must satisfy are called criteria.

True

Connectivity and Cardinality together represent business rules.

True

During the conceptual-level design, designers must consider the characteristics of the particular DBMS that the organization will use.​

True

Each column in a table should have a unique name.

True

Eliminating redundancy not only saves space but also makes the process of updating data much simpler.​

True

In Relational Database Notation, you should indicate table name, all columns and primary key.

True

In an E-R diagram, lines represent relationships between connected entities.​

True

In an E-R diagram, rectangles represent entities.​

True

In an E-R diagram, the dot at the end of a line indicates the "many" part of the one-to-many relationship between two entities.

True

In an OR criterion, the overall criterion is true if either of the individual criteria are true.​

True

In an one to many relationship between two entities, each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to only one occurrence of the first entity.​

True

It is through foreign keys that you can create relationships among tables and enforce certain types of integrity​ constraints in a database.​

True

Logical design is DBMS dependent.

True

Major sort key is the first sort field.

True

Metadata is data about data.

True

QBE is a visual approach to writing queries.​

True

Relationship is the association between entities.

True

Sharing data is one advantage of database processing.​

True

Software packages, called database management systems, can do the job of manipulating databases for you.

True

The attributes of an entity become the fields or columns in a table.​

True

The basic relationships among entities are: one-to-many, many-to-many, and one-to-one.​

True

The comparison operators are also known as relational operators.

True

The data in data warehouses cannot be changed once entered.

True

The field on which records are sorted is called the sort key.

True

The primary key is a unique identifier.​

True

The problem of inconsistency in data is a direct result of redundancy.

True

The relationships between tables are handled through common columns.

True

The term connectivity is used to describe the relationship classification.

True

To handle the many-to-many relationship, you create a bridge table whose primary key is the combination of the primary keys of the original tables.​

True

When a structure satisfies all the properties of a relation except for the first item—in other words, some entries contain repeating groups and thus are not single-valued—it is referred to as a(n) ​unnormalized relation.​

True

When you need to change data, redundancy makes your changes more cumbersome and time-consuming.

True

​A computed field is a field that is the result of a calculation using one or more existing fields.

True

​The relationship between different entities (in different tables) is handled by their common columns.

True

Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be used in a query.​

aggregate

There are three unique identifiers (A, B, and C) in a table, if we select A to be the primary key, then B becomes _____ keys.

alternate

There are three unique identifiers (A, B, and C) in a table, if we select A to be the primary key, then C becomes _____ key.

alternate

If there are three unique identifiers (A, B, and C) in a table, they are called _____ keys.

candidate

​____ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.

data independence

An integrity constraint is a rule that ____.

data must follow in the database

A query that deletes data is a(n) ____ query.​

delete

Referential integrity is about _____ key.

foreign

One disadvantage of a database system is ____.​

greater impact of failure

Which of the following stages does not belong to database design process.

hardware selection

A relationship that is necessary for identification is called a(n) ____.​

identifying relationship

An entity that does not require a relationship to another entity for identification is called a(n) ____.​

independent entity

A ____ query creates a new table using the query results.​

make-table

If one student can take one to many courses and one course can be taken by one to many students, what's the relationship between student and course?

many to many

If one occurrence of A entity is associated with many occurrences of B entity while one occurrence of B entity is associated with many occurrences of A entity, then we call the relationship between A and B is ____.

many-to-many

On a Crow's Foot Notation E-R diagram, the number closest to the rectangle represents ____ cardinality.​

maximum

If you are sorting records by more than one field, the less important field is called the ____.​

minor sort key

If one course is taught by only one professor and one professor can teach one to many courses, what's the relationship between course and professor?

one to many

If one customer can have only one membership and one membership only belongs to one customer, what's the relationship between customer and membership?

one to one

If one occurrence of A entity is associated with many occurrences of B entity while one occurrence of B entity is associated with one occurrence of A entity, then we call the relationship between A and B is ____.

one-to-many

If one occurrence of A entity is associated with one occurrences of B entity while one occurrence of B entity is associated with one occurrence of A entity, then we call the relationship between A and B is ____.

one-to-one

Entity integrity is about ____ key.

primary

The most popular database model is ________________.

relational database model

When designing a database, you might find it helpful to design a(n) ____ to obtain the required information from users.​

survey form

Rows are also called ____.​

tuples

A query that changes data is a(n) ____ query.​

update

When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____.​

write both the table name and the column name, separated by a period