LIS3784 Test 1

What type of relationship is expressed with the phrase "Employee manages Store"?

1:1

What type of relationship is expressed with the phrase "Painter paints Paintings"?

1:M

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____.

1NF

A table that is in 1NF and includes no partial dependencies is said to be in ____.

2NF

A table that is in 2NF and contains no transitive dependencies is said to be in ____.

3NF

____ is a generic entity type that is related to one or more entity subtypes.

An entity supertype

The ____ attribute(s) make up the primary key in the table definition:CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)

CRS_CODE and CLASS_SECTION

____ are important because they help to ensure data integrity.

Constraints

What is the name for the most current (and most used) notation of the ERD?

Crow's Foot notation

The ________ receives all application requests and translates them into the complex operations required to fulfill requests.

DBMS

Remove part number CB03 from the PART table;

DELETE FROM PART WHERE PART_NUMBER='CB03';

The most widely used conceptual model is the ________ model.

E-R

________ are the people who use application programs to run the organization's daily operations.

End users

___ might be represented with a multivalued attribute.

Household phone numbers

____ yields only the rows that appear in both tables.

INTERSECT

What is a benefit of using a DBMS?

It helps create an environment for end users to have access to more data.

____ data can have only a true or false (yes or no) values.

Logical

What type of relationship is expressed with the phrase "Student takes Class"?

M:N

Why are entity integrity and referential integrity important in a database?

Referential integrity means that, if the foreign key contains a value, that value refers to an existing valid tuple (row) in another relation. Entity integrity ensures that each row is uniquely identified by the primary key.

List the order line number, part number, number ordered, and quoted price from the ORDER_LINE table in ascending order by quoted price.

SELECT ORDER_NUMBER, PART_NUMBER, NUMBER_ORDERED, QUOTED_PRICEFROM ORDER_LINEORDER BY QUOTED_PRICE;

From an end-user perspective, any SQL-based relational database application involves three parts: a user interface, a set of tables stored in the database, and the ________.

SQL engine

________ independence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

Structural

________ is the de facto query language and data access standard supported by the majority of DBMS vendors.

Structured Query Language

For most relational database software, the query language is ________.

Structured Query Language (SQL)

____ combines all rows from two tables, excluding duplicate rows.

UNION

Modify the city, state, and zip code of sale's rep number 06.

UPDATE sales_repSET city='Tallahassee', state='FL', zip_code='32304'WHERE slsrep_number='06';

Which data model was developed most recently?

XML

Denormalization

___ yields better performance.

Briefly explain why a data dictionary is necessary, and what should be included in a data dictionary.

a detailed description of all tables in the database created by the user and designer ... contains at least all of the attribute names and characteristics for each table in the system (metadata).

A ____ could be a derived attribute.

a person's age

Briefly describe a candidate key

a superkey without unnecessary attributes--that is, a minimal superkey.

select slsrep_number as slsrep_numfrom sales_repwhere slsrep_number=06; Here, slsrep_num i

an alias, that is, an alternate name given to a column or table.

A table that displays data redundancies most likely yields ____.

anomalies

: A data ________ develops when all of the required changes in the redundant data are not made successfully.

anomaly

A(n) ____ is the equivalent of a field in a file system.

attribute

A(n) ________ of the overall database design is required to overcome the fact that data are viewed in different ways by different people.

blueprint

: A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

business rule

An atomic attribute ____.

cannot be further subdivided

A ____ identifier is composed of more than one attribute.

composite

A(n) ________ model is independent of both hardware and software.

conceptual

The ERD represents the ____ database as viewed by the end user.

conceptual

The ________ model presents a global view of the entire database.

conceptual

A(n) ____ is a restriction placed on the data.

constraint

The basic building blocks of all data models are entities, attributes, relationships, and ________.

constraints

Because all data access programs are subject to change when any of the file's data storage characteristics change (that is, changing the data type), the file system is said to exhibit ________.

data dependence

Where does the DBMS store the definitions of data elements and their relationships?

data dictionary

Data redundancy produces ____.

data integrity problems

A ________ focuses primarily on storing data used to generate information required to make tactical or strategic decisions.

data warehouse

The design of a ________ database recognizes the use of historical and aggregated data.

data warehouse

A ________ system is composed of software, hardware, data, procedures and people.

database

The set of possible values for an attribute is a ____.

domain

ne of the advantages of a relational data model is ________.

easier database design

The extended entity relationship model (EERM) is sometimes referred to as the ____.

enhanced entity relationship model

A CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of ____ integrity.

entity

A customer ________ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit.

entity

A(n) ____ is anything about which data are to be collected and stored.

entity

As a general rule, a noun in a business rule will translate into a(n) ________ in the model.

entity

Which model represents the end users' view of the data environment?

external

Classes are organized as a class ________.

hierarchy

Database models can be grouped into two categories: conceptual models and ________ models.

implementation

Data ________ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.

independence

Each row in the relational table is known as an entity ________.

instance

Which model is the representation of the database as "seen" by the DBMS?

internal

A relation is a matrix consisting of a series of row and column ________.

intersections

What is the fastest and most direct source of business rules?

interviews with end users

The relational database model enables you to view data ____ rather than ____.

logically, physically

What is the name for data about data?

metadata

In the OO data model, a class ________ represents a real-world action such as finding a selected PERSON's name.

method

Data models were developed to ________.

model real-world objects or events

A(n) ____ join links tables by selecting only the rows with common values in their common attribute(s).

natural

A derived attribute ____.

need not be physically stored within the database

In the object-oriented data model (OODM), both data and their relationships are contained in a single structure known as a(n) ________.

object

The hierarchical database model depicts a set of ________ relationships.

one-to-many

Within a specialization hierarchy, every subtype can have ____ supertype(s) to which it is directly related.

only one

A(n) ____ might be represented with a single-valued attribute.

person's social security number

Which model operates at the lowest level of abstraction?

physical

One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.

primary

In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable

primary keys

An attribute that is part of a key is known as a(n) ____ attribute.

prime

The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________.

query language

What is the name for an answer to a query that the DBMS sends back to the application?

query result set

All fields for a specific entity can be grouped together as a ________.

record

How is an entity represented in an ERD?

rectangle

Data ________ exists when the same data are stored unnecessarily at different places.

redundancy

A relational table must not contain a(n) ____.

repeating group (i.e., multi-valued attributes)

Within the network model, the ________ is the conceptual organization of the entire database as viewed by the database administrator.

schema

: A ____ key is defined as a key that is used strictly for data retrieval purposes.

secondary

A ________ is the equivalent of a file system's record type.

segment

List all dealership names, vehicle types and makes for each dealership (use EQUI-JOIN, aka "old-style" join):

select dlr_name, veh_type, veh_make from dealership, vehicle where dealership.dlr_id = vehicle.dlr_id;

A record consists of a ________.

set of one or more fields

A ____ attribute can have only one value.

single-valued

The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).

specialization hierarchy

A relational database is a collection of ________.

tables

Data management is a discipline that focuses on ________.

the proper generation, storage, and retrieval of data

Normalization works through a series of stages called normal forms. For most purposes in business database design, ____ stages (aka "forms") are as high as you need to go in the normalization process.

three

The hierarchical database model is based on a ________.

tree structure

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________.

tuning

In a text-based ER description, primary keys are indicated by ___

underlining

XML databases have emerged to address the need to manage ________ data within the native XML format.

unstructured

The ERDM is primarily geared to business applications, while the OODM tends to focus on ________ applications.

very specialized engineering and scientific