MIS 3376 Final

In a university environment, what is the appropriate multiplicity for an association linking courses with their list of pre-requisite courses? Focus on the numbers placed next to the 'Pre-requisite courses' side of the association.

0..*

A difference between a list box and a combo box is ______________.

A combo box allows the user to enter a value that is not in the list, which is not allowed in a list box

What SQL operator would you use in the following WHERE statement to restrict the result such that saledate is greater than all the values returned from the subquery? WHERE saledate > __________________ (subquery result)

ALL

Assume you want to add the student roster to the database, capturing which student is enrolled in which course. What is the best way to incorporate this data?

Add another table with only two columns, CourseNo, StudentID, which is then associated with the Schedule table

What should the primary key be for the Schedule table?

CourseNo

Assuming that the appropriate primary key is used in Schedule, what normal form is it in?

First, Second & third Normal Form

The database design that uses a hierarchical data structure, but incorporates multiple data entry points is called a ________________.

Network database

The primary difference between the Relational database (RDB) and Object Oriented database (OODB) models is ____________________.

OODB incorporates methods in with the definition of the data structure, while RDB does not

Which SQL command is used to control the order that records are displayed in a query?

ORDER BY

The database model that utilizes multiple tables interconnected through common attributes to store and manage information is called a ______________.

Relational Database

The database design that consists of multiple tables that are linked together through matching data stored in each table is called a ___________________.

Relational database

Which standard user controls on a Control Menu Box allow the user to move the scroll horizontally and vertically within the displayed window?

Scroll Bars

A composition association is drawn using which symbol _______________.

Small closed diamond at the end of a line connecting two tables

A bad choice for a primary key for the university's student database is the student phone number.

True

A single-row form would be appropriate for a banking application where you only want to display a single user's record at one time.

True

From a Human Factors Design perspective, issues surrounding aesthetics involves support for physically handicapped users.

True

From a Human Factors Design perspective, it is good practice for forms to provide Feedback through either visual, text and sound.

True

Individual objects are stored as rows in a table.

True

Tables with no composite primary keys (i.e., primary keys that are based on a single column) are always in second normal form.

True

The employee - manager association is an example of a reflexive relationship

True

The purpose of class diagrams is to model the interrelationships between the different classes in the database.

True

To include a title at the top of each page in a report, the required text would be placed in the page header.

True

Using an IN operator is an alternative it using a group of OR clauses in a WHERE statement.

True

WHERE is used to place a constraint on non-aggregated properties.

True

What basic question is addressed with the SQL keyword WHERE?

What output do you want to see

Assume you are dealing with a purchasing database involving a single table. This table contains information on the customer, sale, and items purchased, where the sales order number is the primary key.Using this database design, the system will prevent you from entering any information on new products unless they are involved in a sale. This is an example of ______________.

an insertion anomaly

Business rules can be represented in the database through ________________.

associations (or relationships)

A data type that creates unique numbers for key columns in Microsoft Access is ___________.

autonumber

When building a database, the data dealing with an entity is modeled as a _____ .

class

When the clicks a ______________, a predefined event is triggered, and some action will be performed.

command button

Assume you are creating a database to handle the data associated with instruction at a university. What is the most appropriate special association to model the different elements contained in each classroom (i.e., projection equipment, blackboard type, computer support, etc)?

composition association

The process to properly define the database tables to provide flexibility, minimize redundancy, and ensure data integrity is called ___________________.

data normalization

Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a _________________.

database management system (DBMS)

Tables in first normal form (1NF) __________________.

do not have any repeating groups

Referential Integrity Constraints are used to ________________.

ensure that foreign keys can be entered only if the corresponding value exists in the originating table

The term referring to a physical item existing in the real world that you want to track is called ____________________.

entity

All queries can be designed to avoid subqueries.

false

One of the first phases of a new database project that involves critical areas, expensive hardware or software within the organization is called ___________.

feasibility study

The fields in one table that link to the primary key in another table are called _________.

foreign key

The tool which assists in generating input screens is referred to as ____________.

forms generator

Tables in third normal form (3NF) _______________.

have all non-key fields depend on nothing but the primary key

Tables in second normal form (2NF) ___________________.

have all non-key fields depend on the whole primary key

The association role defines ____________________.

how tables are related in the database

Data integrity constraints are used to _____________________.

improve the quality of data entered for a specific property (i.e., table column)

Data integrity can be improved by which of the following means ____________.

incorporating business rules when defining the data

A problem created with repeating groups is ___________________.

inefficient use of space

Tables in fourth normal form (4NF) if the table is in 3NF and ____________.

there are no hidden dependencies

A Tabular Form presents the data in a form similar to a spreadsheet.

true

A bound control is linked to the contents of a specific table property, allowing the contents to be displayed and changed.

true

A primary goal of a database system is to share data with multiple users.

true

A subquery uses the same syntax as a regular query.

true

A switchboard form is designed to provide the user interface to your database application.

true

DBMS stores data efficiently with little wasted space.

true

Data normalization minimizes data redundancy.

true

If you use a GROUP BY command, you can not see the non aggregated data in the same query.

true

In a university database, the normal multiplicity for a relationship between courses and students would be many to many.

true

Including the DISTINCT operator in a query will always result it less than or equal to the number of records returned when the DISTINCT operator is not used.

true

It is possible to use a WHERE if the query contains a GROUP BY.

true

N-ary associations are used to convert Many to Many relationships to multiple 1 to Many relationships.

true

Nested queries can be split into separate parts and then combined to get the final result.

true

Properties of an object are stored as columns in a table.

true

Query-by-Example provides visually oriented tools for developing queries.

true

Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required.

true

Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is optional.

true

Specifying an asterisk (*) for the association multiplicity on a class diagram indicates that the quantity of the item is unknown, and can have many items associated with it.

true

The developer can follow a specific set of procedures and rules to ensure that a table is in 1NF, 2NF and 3NF.

true

To build and manage databases you need a data definition language, data manipulation language, and a data query language.

true

To use the SQL HAVING keyword you must also use the GROUP BY keyword.

true

UNION and INTERSECT are operators used to compare tables having similar structure (i.e., having common field names and data types).

true

Which of the following is not true about the Query by Example (QBE) method of accessing data in a database?

Can totally replace the need to learn and use SQL

Database system modelers use this type of diagram to graphically represent both the data structure and how the different objects are interrelated.

Class Diagram

The type of form that displays multiple records at a time in rows and columns is called a _______________.

tabular form

If you want to get a list of your customers that have purchased from you in the last year, but you only want to list each customer once, how can you prevent multiple listings of the same customer?

DISTINCT

Which component of the database management system (DBMS) most affects the performance (speed)?

Database Engine

Which SQL command is used to specify the tables used in the query?

FROM

A Subquery and a View are two terms for the same concept.

False

A good choice for a primary key for the university's student database is the student phone number.

False

Aggregation associations are used to convert Many to Many relationships to multiple 1 to Many relationships.

False

Databases do not have the ability to do numerical calculations.

False

If a table is in 3NF, it is also in 1NF.

False

In a university database, the normal multiplicity for a relationship between courses and students would be one to many.

False

Most databases allow multiple records that are identical (i.e., records that have the same values for all properties).

False

SQL does not permit a given table from being included in a query more than once.

False

The primary key need not be unique for a given table.

False

Using an ALL operator is an alternative it using a group of OR clauses in a WHERE statement.

False

To aggregated data so you can use set-based operations (i.e., COUNT, AVERAGE, MAX, etc.) you would use which SQL command?

GROUP BY

The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of 'database' system?

Hierarchical

What is the purpose of the SQL clause BETWEEN?

Impose a query constraint covering a range of values

Direct manipulation of objects is a consequence of what advancement in computer systems?

Increase emphasis of graphical user interfaces

Which SQL command is used to indicate how tables are linked together?

JOIN

Which SQL command would you use to match field values to a template value (i.e., finding all customers with a last name starting with "G")?

LIKE

The term used for the functions and procedures that work on class data is ______.

Methods

Human factors design research has found all of the following important factors to consider when building forms and reports EXCEPT which of the following?

Support of multiple users

If you wanted to ensure that the title and project name is printed on the top of every page, this information would be placed in ______________.

page header

The property (or set of properties) that uniquely defines each row in a table is called the ___________________.

primary key

Two different terms are used to describe the characteristics of interest for an entity. They are attributes and _____________.

properties

If you want to include some introductory material for your report which is only printed once at the front of the document, it would be placed in the __________________.

report header

The SQL command TOP is used to ________________________.

restrict the output to a limited number of record

The role of the query system is to __________________.

retrieve and manipulate data

Not all queries can be constructed in a single SELECT statement. They have to be built up using the results of one query as building blocks for the larger query. What is the term used for these smaller queries that are integrated together to build the final query?

subquery