MGIS 320 - midterm exam

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(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

____ 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

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

DepartmentID

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

Forms

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

Join

If you are sorting records by more than one field, the field on which records are sorted first is called ____.​

Major sort key

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

RDBMSs

RDBMS stands for ____.

Relational Database Management System

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

SaleID + ProductID

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

SaleID and ProductID

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

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

candidate

An integrity constraint is a rule that ____.

data must follow in the database

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

database design

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

delete

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 unnormalized relation is a table that has more than one row.​

false

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

false

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

false

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

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 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

Referential integrity is about _____ key.

foreign

One disadvantage of a database system is ____.​

greater impact of failure

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 database has ____ if the data in it satisfies all established integrity constraints.​

integrity

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

make-table

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

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

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

maximum

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 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 country can have only one president and one president only belongs to one country, what's the relationship between country and president?

one to one

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 ____ 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

The most popular database model is ________________.

relational database model

Forms and ________ are two tools provided by the DBMS.

reports

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

survey form

____ 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 composite key is a multi-attribute key.

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 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

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 entity-relationship (E-R) modeling is an approach to representing data as entities, attributes and relationships in a database structure.

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

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

Each column in a table (relation) 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 a one-to-many relationship, the primary key of the "many" side table becomes the foreign key of the "one" side table.​

true

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

true

In an AND criteria, both criteria must be true for the compound criteria to be true.

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 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

Metadata is data about data.

true

Microsoft 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

Microsoft Access is a RDMBS.

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

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 +, *, %, and /.​

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 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 create an OR criteria in QBE: Place the criteria for multiple fields on different Criteria rows in the design grid.

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

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

true

​An entity is an information category.

true

​The comparison operators are also known as relational operators.

true

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

true

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

update

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

user interface design