Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database - Normalization > Chapter 1 - Intro To Database > Flashcards

Chapter 1 - Intro To Database Flashcards

1
Q

Database

A

A collection of data organized to provide efficient management of the data as well as easy access to and updating of the data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Flat file database

A

A file containing records that have no structured interrelationship.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Name the problems of a flat file database

A

Repetition of data, separation of data, incompatibility of files, data dependence and inflexibility of the application programs that access the data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What approach does the flat file database use?

A

Decentralized

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How does a flat file database collect the data?

A

In lines of text with each value separated by a tab character or a comma And with each row represented by a new line.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

System catalog or data dictionary

A

Part of the database that describes the data in the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What type of structure does a database use?

A

Tabular

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Program data independence

A

Application programs that are written to access the database need not be concerned with how the database is defined or how it holds the data. Because the data is stored in a separate mechanism application programs also become completely independent entities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What type of definitions are in object oriented programming?

A

Internal and external definition.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What kind of approach does database allow?

A

Centralized

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Relational database

A

A collection of data organized as a set of formally described tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Database management system

A

Allows users to define create and maintain databases while providing controlled access to the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

SQL Stands for what?

A

Structured query language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Structured query language

A

A language used to create professional high-performance corporate databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

DDL

A

Data definition language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Data definition language

A

Permits the database designer to specify the data types held in the database as well as constraints on the data.

17
Q

DML

A

Data manipulation language

18
Q

Data manipulation language

A

Allows users to retrieve, insert, update and delete data in the database.

19
Q

What are the five advantages of using a DBMS?

A
  1. Provides a security system.
  2. Provides in integrity system for preserving the consistency of the data.
  3. Provides a concurrency control system for shared access of the database.
  4. Provides a recovery system for restoring the database to a previous state in case of hardware or software failure.
  5. Provides a data dictionary for describing the data within the database
20
Q

Database administrator

A

The person who directs or performs all activities related to maintaining a database environment.

21
Q

View

A

A view is a subset of the data in a database views are useful when users do not need to see or access all of the data in the database.

22
Q

Why is repetition of data needed in a database?

A

To improve performance and most important, redundant data is needed to model data relationships.

23
Q

Name the 10 advantages of using a DBMS.

A
  1. Management of data redundancy.
  2. Consistency of data.
  3. Data sharing.
  4. Increased data integrity.
  5. Increased data security.
  6. Adherence to standards.
  7. Increased data access.
  8. Increased productivity.
  9. Managed concurrency.
  10. Increased data backup and recovery.
24
Q

Name four of the disadvantages of using a DBMS.

A
  1. Complexity.
  2. Size of the software.
  3. Cost.
  4. Increased impact in case of DBMS failure.
25
Q

Who proposed the first relational data model in 1970?

A

Dr. E. F. Codd

26
Q

What was the name of the first IBM Proto typical relational database?

A

System R

27
Q

What products came out of the system R project?

A

DB2, SQL/DS from IBM and Oracle.

28
Q

What project took place at the University of California at Berkeley around the same time as the system R project?

A

The interactive graphics retrieval system. INGRES

29
Q

In 1976 the IBM UK scientific center developed what project?

A

The Peterlee Relational Test Vehicle.

Database - Normalization (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions