MIS 3376 FINAL

Why are UML class diagrams are preferred over ER diagrams.

They are "cleaner" in the sense that they are easier to read without the bubbles and cryptic notations of traditional ERDs. They are standardized, so students learn only one set of notations. They provide an introduction to object-oriented design, so students will be better prepared for future development issues. With the rapid adoption of UML as a standard design methodology, students are better prepared to move into future jobs. All of the above

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

True

Data normalization minimizes data redundancy. (T/F)

True

If a table is in 3NF, it is also in 1NF. (T/F)

True

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

True

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

True

The employee - manager association is an example of a reflexive relationship. (T/F)

True

The purpose of class diagrams is to model the interrelationships between the different classes in the database. (T/F)

True

The ___________ operation combines all rows of data from similarly structured tables or queries (i.e., combining results of similar queries run on the distributed databases of an international Bank).

UNION

UML stands for

Unified Modeling Language

With SQL queries, the difference between putting conditions in the WHERE clause versus the HAVING clause is

WHERE applies to original detail rows and HAVING applies to aggregations

What basic question is addressed with the SQL keyword WHERE?

What do you already know (or what constraints are given)

Business rules can be represented in the database through ________________.

associations (or relationships)

An entity listed with its properties is called a(n)

class

Which of the following computations can be included in a query?

combination of aggregation and arithmetic aggregation arithmetic All of the above

A ____________________ is most commonly used on forms to run special code or to open related forms and reports.

command button

The collection of data that is stored in a standardized format designed to be shared by multiple users accessed through a standardized software interface capable of managing files as a single integrated entity is known as

database

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

Tables in first normal form (1NF) __________________

do not have any repeating groups

The ____________ form control is most commonly used to simplify data entry for foreign key values which require obtaining a value from a second table.

drop down list

`Tables in second normal form (2NF) ___________________.

eliminate the possibility of a insertion anomalies

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 of the following are standard elements in human factors design of forms except

form controls to limit user input

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

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)

Missing data in a database is referenced as _____ in a query.

is Null

A database form control that displays a fixed collection of items and enables the user to select only one of the items is:

option button

The ____________ form type is common for business applications and enables users to focus on several attributes for a single object (such as person or item) at one time.

single row

The type of form that is used to display one-to-many relationships is called a _______________.

subform

Which form type displays multiple rows of data on one page, but should be used only when the number of columns is small to reduce the need for horizontal scrolling:

tabular

The most important characteristic of a good form (versus bad) is

the form makes it easy for users to do their job

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

there are no hidden dependencies

Using the basic SQL commands, a condition of the form SaleDate > 'May 1, 2014'

will return rows where the sale took place after May 1, 2014.

Which of the following symbols commonly represents the value 'many' of the multiplicity?

*

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

In a university database, what is the appropriate multiplicity for an association linking offered courses and students? Focus on the numbers placed next to the "Students" side of the association.

1...*

Given the table list below and common assumptions, in which normal form is this list? Customer (CustomerID, FirstName, LastName, Address, City, State, ZIPCode) Sale (SaleID, SaleDate, CustomerID) SaleItems (SaleID, ItemID, Quantity) Item (ItemID, Description, ListPrice, QuantityOnHand)

3NF

When writing SQL WHERE conditions, combining conditions with which operator will tend to reduce the number of matching rows returned?

AND

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 needs to be done for converting one-to-many relationships?

Add primary key from the one-side as a foreign key to the many-side table

A primary key consisting of the two columns * Employee, * Office indicates which of the following relationships?

An employee has many offices and an office can have many employees. An office has many employees but each employee has one office

Which of the following is defined as a relationship between two or more classes?

Association

A table cell contains a(n) ________ value if there is only a single non-repeating item.

Atomic

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

Autonumber

A class diagram displays

Both classes and relationships

Which of the following is the database design problem that should be resolved using data normalization?

Both insertion and deletion anomaly

Basic guidelines for accessibility of applications include all of the following except

Build forms in a size that will easily fit on a variety of screen sizes

An entity listed with its properties is called a(n) ________.

Class

The primary key that is composed from several columns is called a _____________?

Composite Key

What should the primary key be for the Schedule table?

CourseNo

In business applications which of the following relationships is most commonly a many-to-many relationship?

Customer - Item Purchased

In running queries that produce duplicate rows, the keyword used to eliminate the duplicates from the output is

DISTINCT

The phase of a new database project that involves defining tables, relationships, forms, reports and application programs is called the

Design phase

Third normal form is achieved when the design is in second normal form and

Each non-key column depends on nothing but the key.

Second normal form (2NF) is achieved when the design is in first normal form and

Each non-key column depends on the whole key.

which of the following is a variation of a class diagram?

Entity-relationship diagram

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

FROM

To find a list of things that did not happen, such as items that were not sold, given SaleItem and Item tables, use a query that includes

FROM Item WHERE ItemID NOT IN (SELECT ItemID FROM SaleItem)

A good choice for a primary key for the university's student database is the student phone number. (T/F)

False

Databases do not have the ability to do numerical calculations. (T/F)

False

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

False

The primary key need not be unique for a given table. (T/F)

False

The primary steps in formal application development, particularly for large projects, are:

Feasibility, Analysis, Design, Development, Implementation

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

First, Second and Third Normal Form

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

Foreign Key

The SQL __________ clause only applies to the GROUP BY output.

HAVING

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

Hierarchal

Which database management approach is closest to a filing cabinet system where data is sorted and retrieved from the top-down?

Hierarchial

Which of the following is not one of the basic questions that need to be addressed to write a query?

How many rows will be returned?

All of the following are the initial steps in database design except

Identify hardware requirements

Which of the following is the first step of application development?

Identify user requirements

What is the purpose of the SQL clause BETWEEN?

Impose a query constraint covering a range of values

The most important characteristic of a primary key in a table is that

It must be unique in all cases

Joining tables causes the rows to be matched based on the columns in the ______ statement.

JOIN

To handle simple pattern matching tasks SQL provides the _______ command.

LIKE

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

Many to Many

Which of the following types of relationships between two tables is not directly supported by relational database?

Many to one

Copying attributes from a form led to an initial design of: MeetingSchedule (PersonID, Name, Title, (Date/Time, Contact, Phone, Reason)) Parentheses indicate a repeating section. This design can be converted to 1NF as:

MeetingSchedule(PersonID, Name, Title) + Reason(PersonID, Date/Time, Contact, Phone, Reason)

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

Methods

For database design, a class diagram needs to include all of the following elements except

Methods for every class, particularly common items such as insert and delete

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

Network Database

To sort a list totals from high to low, use the SQL phrase

ORDER BY totals DESC

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

Primary Key

____ integrity exists when a value for a foreign key can be entered only if the corresponding value already exists in the originating table

Referential

An association where a column in one table connects to another column in the same table is known as:

Reflexive

Which of the following types of database management storage is the most common in business applications today?

Relational

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 tool is commonly deployed today as a web service to support user access with a web browser from almost any location?

Report writer

Using the basic SQL commands, the desired output columns are listed after which phrase/keyword:

SELECT

The SQL syntax is somewhat picky and the basic clauses must always be used in the proper order:

SELECT, FROM, JOIN, WHERE, GROUP BY, ORDER BY

The most common query system in use today is

SQL

Using common assumptions, which of the following columns would NOT depend on CustomerID?

Sale Date

Database applications often can be developed faster than custom programming in part because a DBMS includes

Security controls to assign access rights and protect the data. A query engine to retrieve data to answer complex questions. A form builder that quickly create forms to display and edit data in the database. A report writer to create reports with custom layouts and subtotals. All of the above

When designing a database table, computed values.

Should not be stored

A composition association is drawn using which symbol _______________.

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

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