Introduction to database

Question 1

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

Answer 1

Databases

Question 2

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

Answer 2

Charles Bachman

Question 3

IMS, late 1960’s

Answer 3

Information Management System

Question 4

he developed rational database model in 1970

Answer 4

Dr. Edgar F. Codd

Question 5

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

Answer 5

Structured English Query Language (SEQUEL)

Question 6

ANSI

Answer 6

American National Standard

Question 7

ISO

Answer 7

International Standard Organization

Question 8

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

Answer 8

Database management system

Question 9

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.

Answer 9

Database

Question 10

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

Answer 10

Data

Question 11

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

Answer 11

Information

Question 12

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

Answer 12

Field

Question 13

The set of fields containing data about a single person.

Answer 13

Record

Question 14

Characteristics and property of information

Answer 14

Metadata

Question 15

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

Answer 15

Primary Key

Question 16

A primary key consisting of just one field/attribute.

Answer 16

Atomic PK

Question 17

A primary key consisting of more than one attributes.

Answer 17

Composite PK

Question 18

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

Answer 18

Foreign Key

Question 19

Each Attribute that could be defined as the primary key.

Answer 19

Candidate Key

Question 20

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

Answer 20

Alternate Key

Question 21

DISADVANTAGES OF FILES PROCESSING SYSTEM

Answer 21

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

Question 22

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

Answer 22

Database Approach

Question 23

The first step in converting to a database approach

Answer 23

Develop a list of the high level entities

Question 24

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

Answer 24

Entity

Question 25

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

Answer 25

Enterprise Data Model

Question 26

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

Answer 26

Database Application

Question 27

data descriptions are stored in central location.

Answer 27

Repository

Question 28

are designed to support one user.

Answer 28

Personal Databases

Question 29

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.

Answer 29

Workgroup

Question 30

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

Answer 30

Workgroup Database

Question 31

a functional unit within an organization.

Answer 31

Department

Question 32

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

Answer 32

Department Databases

Question 33

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

Answer 33

Internet Databases

Question 34

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

Answer 34

Intranet Databases

Question 35

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

Answer 35

Extranet Databases