Brainscape's Knowledge GenomeTM

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


See full index

Database Management System > Introduction to database > Flashcards

Introduction to database Flashcards

1
Q

are important to most information system since they
are used to store, manipulate, and retrieve data

A

Databases

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

in early 1960’s he developed IDS (Integrated Data Store) used network data model

A

Charles Bachman

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

IMS, late 1960’s

A

Information Management System

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

he developed rational database model in 1970

A

Dr. Edgar F. Codd

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

was develop by IBM Corporation Inc. in San Jose California IN LATE 1970’s

A

Structured English Query Language (SEQUEL)

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

ANSI

A

American National Standard

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

ISO

A

International Standard Organization

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

it is a software package that allows users to design,
create, access, maintain, and view data.

A

Database management system

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

It can be generally defined as a collection of interrelated data that is organized in such a way that data can easily be stored, manipulated, and retrieved by users.

A

Database

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

referred to as any raw facts or concepts that have
meaning in the user’s environment and can be
stored on a computer media.

A

Data

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

is defined as data that have been processed so as the meaning of the data be vividly understood by
those who use them.

A

Information

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

It is the smallest meaningful unit of data and consist of a group of one or more characters that has a specific meaning.

A

Field

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

The set of fields containing data about a single person.

A

Record

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

Characteristics and property of information

A

Metadata

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

An attributes or group of attributes that will uniquely identify each entity in the entity type, and each record in the corresponding database table.

A

Primary Key

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

A primary key consisting of just one field/attribute.

A

Atomic PK

17
Q

A primary key consisting of more than one attributes.

A

Composite PK

18
Q

A field or combination of fields whose values match with the values under the primary key field of another table.

A

Foreign Key

19
Q

Each Attribute that could be defined as the primary key.

A

Candidate Key

20
Q

One of the candidate key is assigned as primary key and the other are called ________

A

Alternate Key

21
Q

DISADVANTAGES OF FILES PROCESSING SYSTEM

A
  • Program Data Dependence
  • Duplication of Data
  • Limited Data Sharing
  • Lengthy Development Times
  • Excessive Program Maintenance
22
Q

It emphasizes the integration and sharing of data through-out the organization or at least across major
segments of the organization.

A

Database Approach

23
Q

The first step in converting to a database approach

A

Develop a list of the high level entities

24
Q

is an object or concept that is important to the business.

A

Entity

25
Q

is a graphical model that shows the high-level entities for the organization and associations among those entities.

A

Enterprise Data Model

26
Q

is an application program (or set of related programs) that is used to perform a series of activities on behalf of database users

A

Database Application

27
Q

data descriptions are stored in central location.

A

Repository

28
Q

are designed to support one user.

A

Personal Databases

29
Q

It is a relatively small team of people who collaborate on the same project or application or on a group of similar projects or application.

A

Workgroup

30
Q

is designed to support the collaborative efforts of such team who work on given software object or component at a given time.

A

Workgroup Database

31
Q

a functional unit within an organization.

A

Department

32
Q

designed to support the various functions and activities of a department.

A

Department Databases

33
Q

a worldwide network that connects users multiple platforms easily through an interface known as web browser.

A

Internet Databases

34
Q

It is a computer network that uses internet protocol technology to share information, operational systems, or computing services within an organization.

A

Intranet Databases

35
Q

it uses the access of the access of the internet technology but it is not universal as the case with an internet application.

A

Extranet Databases

Database Management System (1 decks)

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