Introduction to database Flashcards
are important to most information system since they
are used to store, manipulate, and retrieve data
Databases
in early 1960’s he developed IDS (Integrated Data Store) used network data model
Charles Bachman
IMS, late 1960’s
Information Management System
he developed rational database model in 1970
Dr. Edgar F. Codd
was develop by IBM Corporation Inc. in San Jose California IN LATE 1970’s
Structured English Query Language (SEQUEL)
ANSI
American National Standard
ISO
International Standard Organization
it is a software package that allows users to design,
create, access, maintain, and view data.
Database management system
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.
Database
referred to as any raw facts or concepts that have
meaning in the user’s environment and can be
stored on a computer media.
Data
is defined as data that have been processed so as the meaning of the data be vividly understood by
those who use them.
Information
It is the smallest meaningful unit of data and consist of a group of one or more characters that has a specific meaning.
Field
The set of fields containing data about a single person.
Record
Characteristics and property of information
Metadata
An attributes or group of attributes that will uniquely identify each entity in the entity type, and each record in the corresponding database table.
Primary Key
A primary key consisting of just one field/attribute.
Atomic PK
A primary key consisting of more than one attributes.
Composite PK
A field or combination of fields whose values match with the values under the primary key field of another table.
Foreign Key
Each Attribute that could be defined as the primary key.
Candidate Key
One of the candidate key is assigned as primary key and the other are called ________
Alternate Key
DISADVANTAGES OF FILES PROCESSING SYSTEM
- Program Data Dependence
- Duplication of Data
- Limited Data Sharing
- Lengthy Development Times
- Excessive Program Maintenance
It emphasizes the integration and sharing of data through-out the organization or at least across major
segments of the organization.
Database Approach
The first step in converting to a database approach
Develop a list of the high level entities
is an object or concept that is important to the business.
Entity
is a graphical model that shows the high-level entities for the organization and associations among those entities.
Enterprise Data Model
is an application program (or set of related programs) that is used to perform a series of activities on behalf of database users
Database Application
data descriptions are stored in central location.
Repository
are designed to support one user.
Personal Databases
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.
Workgroup
is designed to support the collaborative efforts of such team who work on given software object or component at a given time.
Workgroup Database
a functional unit within an organization.
Department
designed to support the various functions and activities of a department.
Department Databases
a worldwide network that connects users multiple platforms easily through an interface known as web browser.
Internet Databases
It is a computer network that uses internet protocol technology to share information, operational systems, or computing services within an organization.
Intranet Databases
it uses the access of the access of the internet technology but it is not universal as the case with an internet application.
Extranet Databases
