LIS 3784 A1

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 Painting"?

1:M

An ad hoc query is a ________.

A "spur-of-the-moment" question.

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

Anomaly

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

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

Conceptual

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

Conceptual

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

Constraints

John is working in the customer table and needs to know what customers are located in Florida. To find the information he would _______

Create a new query

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

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

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

________ are considered database architects.

Database designers

A single-user database thatruns on a personal computer is called a(n) ________ database.

Desktop

A database that supports data distributed across several different sites is called a(n) ________ database

Distributed

The most widely used conceptual model is the ________ model.

E-R

One of the advantages of a relational data model is ________

Easier database design

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

End user

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

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

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

Accurate, relevant, and timely ________ is the key to good decision making.

Information

Processed data, or ________, can be used as the foundation for decision making.

Information

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 model

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?

Interview with end users

What is a benefit of using a DBMS?

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

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

M:N

Which of the following products do not provide an enterprise database?

MS Access

What is the name for data about data?

Metadata

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

Method

Data models were developed to ________

Modal real-world objects or events

A(n) ________ allows the user to specify what must be done without specifying how it must be done.

Nonprocedural language

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

Object

________ 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

For most relational database software, the query language is ________

Structured Query Language (SQL)

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

Structured Query Language (SQL)

A relational database is a collection of _______

Tables

Data processing (DP) specialists are in existence because of ________

The need to track data and produce required reports

Data management is a discipline that focuses on ________.

The proper generation, storage, and retrieval of data

Another name for a production database is a ________ database.

Transactional

The hierarchical database model is based on a ________

Tree structure

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

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

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

Which data model was developed most recently?

XML

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

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

Add two records to the part table.

insert into part (part_number, part_description, units_on_hand, item_class, warehouse_number, unit_price) values ('yyy','Widget1','5','SS','1,9,95) ('zzz','Widget2','10','TT',2,10.95);

List all the contents (rows or records) of the ORDERS table.

select * from orders;

Add two records to the part table. Schema and data replicated here for review:

INSERT INTO part(part_number, part_description, units_on_hand, item_class, warehouse_number, unit_price)VALUES('yyy','Widget1','5','SS',1,9.95),('zzz','Widget2','10','TT',2,10.95); INSERT INTO partVALUES('yyy','Widget1','5','SS',1,9.95),('zzz','Widget2','10','TT',2,10.95);

The hierarchical database model depicts a set of ________ relationships

One-to-many

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

Performance tuning

Which model operates at the lowest level of abstraction?

Physical

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

To list all the contents (rows or records) of the ORDERS table, you would use ____.

SELECT * FROM ORDERS;

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

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

Schema

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

Segment

A record consists of a ________

Set of one or more fields

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

implementation

Remove part number CB03 from the PART table.

select * from part; delete from part where part_number='cb-03'; select * from part;

Modify the city, state, and zip code of sales rep number 06.

select * from sales_rep; update sales_rep set city='Tallahassee', state='FL', zip_code='32304'; where slsrep_number='06'; select * from sales_rep;

List how many vehicles each dealership owns (display dealer id, name, and *number* of vehicles for each dealership), use JOIN USING.

select dlr_id, dlr_name, count(veh_type) from dealership join vehicle using (dlr_id) group by dlr_id;

List the averagetotal sales for each sales rep in each dealership, include dealer ID, name, sales reps' id, and first andlast names, use NATURAL JOIN

select dlr_id, dlr_name, srp_id, srp_lname, srp_fname, avg(srp_tot_sales) from dealership natural join slsrep group by dlr_id, srp_id having dlr_id=1;

List all dealership names, as well as all sales reps first, last names, and their total sales for each dealership (use JOIN ON)

select dlr_name, srp_fname, srp_lname, srp_tot_sales from dealership join slsrep on dealership.dlr_id = slsrep_id;

List each dealership's total sales, include dealer's name and total sales(captured in dealership_history table), use NATURAL JOIN.

select dlr_name, sum(dhs_ytd_sales) as total_sales from dealership natural join dealership_history group by dlr_id;

EQUI-JOIN (old-style join), returns rows with matching values in where clause, does *not* require common named attributes: 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;

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;

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_price from order_line order by quoted_price asc;

Create an alias for an attribute name.

select slsrep_number as slsrep_num from sales_rep where slsrep_number='06';