Ism671 - Data Management - Learning Area

Front 1

What is the standard language used to access and manipulate data in relational database management systems (RDBMS)?

2

Back 1

SQL

Front 2

What is the acronym for Structured Query Language?

2

Back 2

SQL

Front 3

The relational database concept was first developed by

2

Back 3

E. Codd at IBM Research in a classic paper in 1970.

Front 4

Who was the first to market relational database incorporating SQL?

2

Back 4

Oracle

Front 5

What happened in 1986 for SQL

2

Back 5

American National Standards Institute (ANSI) approved a standard for the SQL relational query language.

Front 6

How many standard SQL updates have been released since 1986

2

Back 6

4 in '89, '92, '99, '03

Front 7

Which vendors support SQL?

2

Back 7

Most vendors use SQL; Oracle, IBM, Microsoft

Front 8

What are the three types of SQL commands?

2

Back 8

Data Definition Language (DDL)

Data Manipulation Language (DML)

Data Control Language (DCL)

Front 9

Data Definition Language (DDL)

2

Back 9

DDL commands are used to define a database, such as creating, altering, and dropping tables and establishing constraints.

Front 10

Data Manipulation Language (DML)

2

Back 10

DML commands are used to maintain and query a database, such as updating, inserting, modifying and querying the data in a database. DML commands are the core commands of SQL.

Front 11

Data Control Language (DCL)

2

Back 11

DCL commands are used to control a database, such as granting or revoking privileges to access the database or objects, storing or removing transactions that would affect the database.

Front 12

Which two of the SQL command types will we use in this class?

2

Back 12

DDL and DML

Front 13

Which SQL command type are the core commands?

2

Back 13

DML

Front 14

What was SQL's first name?

2

Back 14

System R then sequel then SQL

Front 15

What type of SQL commands do creating, altering, and dropping?

2

Back 15

Data Definition Language (DDL)

Front 16

What type of SQL commands do updating, inserting, modifying, and querying data?

2

Back 16

Data Manipulation Language (DML)

Front 17

Data Integrity

1

Back 17

Data that is accurate, up-to-date, and protected against unauthorized access.

Front 18

Data Accessibility

1

Back 18

Data is readily available only to people with permission who have a need to see and use the data.

Front 19

Two types of data found in businesses

1

Back 19

Structured and Unstructured

Front 20

Structured Data

1

Back 20

Data that can be put into a Relational Database.

More specifically it is data found in a table like what we have been using in class (RDBMS) with Rows/Record and Columns/Fields. Fields contain specific types of data and Records identify specific individual entities. Information can be accessed rapidly by going to the correct row and column.

Front 21

Unstructured Data

1

Back 21

Data that cannot be put into a relational database such as documents like letters, memorandums, and reports.

Front 22

Document Management Systems

1

Back 22

*improve the storage, maintenance, and management of documents.

*control access to documents

*Keep track of document versions

*find documents using keywords

*supports collaborative work on documents

*controls dissemination of documents

Example: SharePoint

Front 23

Relational Database Concept

1

Back 23

Data is organized into one or more two dimensional tables in which each table contains the data relating to a specific type of entity.

Front 24

Entity

1

Back 24

a noun that has an independent, separate, or self-contained existence.

Example: A student, an employee, a room, a computer, a class, etc.

I think of entities as tables, but that is probably not exactly correct.

Front 25

Attributes

1

Back 25

a characteristic of an entity

Example: first name, last name, email address, shoe size, major, minor, employee id, etc.

Front 26

Three Step process to create a database

1

Back 26

1. Identify the entities needed

2. Identify the attributes needed for each entity

3. Identify the relationships that exist among the entities.

Front 27

One-to-many relationship

1

Back 27

Example: a building has many rooms but there is only one building

Front 28

Parent- Child relationship

1

Back 28

When the identification of one entity relies on the identification of another entity

Example: Room entity depends on the building entity. You cannot say where the room is without identifying the building.

Front 29

Data

1

Back 29

*Facts concerning objects and events that could be recorded and stored on computer media.

Example: student name, address, telephone number

Front 30

Information

1

Back 30

* Data that has been processed in such a way that the knowledge of the person who uses the data is increased.

* Data that has meaning

Front 31

Metadata

1

Back 31

data that describe the properties or characteristics of end-user data and the context of the data.

Example: Properties - data name, definitions, length, allowable values, ect. Context - data source, where the data are stored, ownership, usage, ect.

Front 32

Database

1

Back 32

an organized collection of logically related data usually found in tables.

Front 33

Relational Database

1

Back 33

a database where the data is organized into one or more two dimensional tables in which each table contains the data relating to a specific type of entity.