FINAL 389

Question 1

Database:

Answer 1

collection of data which can be used…

alone, combined / related to other data to provide answers to the user’s questions.

Question 2

Database Management Systems (DBMS)

Answer 2

not a database.
to access info from a database, you need a DBMS.

set of computer programs that enable users to create, modify, and utilize database information

Question 3

What do DBMS do?

Answer 3

provide management of database

control access to data

contain a query language to retrieve info easily.

Question 4

DBMS examples:

Answer 4

Microsoft Access, Microsoft SQL Server, Oracle

Question 5

Steps in Database design:

Answer 5

• Requirement Analysis
• Conceptual Database design
• Physical Database design.

Question 6

Requirement analysis

Answer 6

step in database design that asked the question, “what does the user want?”

Question 7

Conceptual database design:

Answer 7

step in database design.

defining the entities and attributes, and the relationships between these —> ERD

Question 8

physical database design:

Answer 8

implementation of the conceptual design using a database management system

Question 9

Data Definition Language (DDL)

Answer 9

the language used to create and format the fields in a database.

Question 10

Examples of DDL function:

Answer 10

• Determine field size (#of characters)
• Assign field name
• Set data type (text, numeric, date, etc)
• Identify primary key
• Establish default value.

Question 11

Data Manipulation Language (DML)

Answer 11

Language used for data maintenance

updating (change)
inserting (add)
deleting (remove)

Question 12

Schema

Answer 12

The entire database

Question 13

Subschema

Answer 13

A set of the database (called a view)

Question 14

Queries:

Answer 14

Allow users to extract some portion of the data in the database.

Reports

Question 15

What else can queries do?

Answer 15

be used to change or delete a record.

Question 16

OLAP

Answer 16

Online Analytical Processing

Question 17

OLAP definition

Answer 17

allows users to summarize data by different dimensions

i.e. time, customer, region

Question 18

OLAP also has “____” capability, which does what?

Answer 18

drill down.
allows users to click on data and see one less level of aggregation.

Total Company sales.
Drill down to sales by district.
Drill down to sales by store.

Question 19

SQL

Answer 19

Structured Query Language

Question 20

SQL is…

Answer 20

standardized language used to query relational data bases.

many software packages support SQL, including access.

Question 21

SQL Keywords:

Answer 21

SELECT
FROM
GROUP BY
WHERE
ORDER BY

Question 22

SELECT

Answer 22

used to identify the COLUMN that will be displayed

Question 23

FROM

Answer 23

used to identify the TABLE

Question 24

WHERE

Answer 24

used to select which ROWS. Conditions are also used.

to link tables and conditions.

Question 25

example of linkage

Answer 25

table name.column name = table name.column name

Question 26

Where do math operations go?

Answer 26

SELECT because they create new fields.

Question 27

GROUP BY

Answer 27

used to identify which field is subject to a mathematical operation.

Question 28

ORDER BY

Answer 28

used to sort the answer in ascending or descending order (sort output)