Database
What is
database?
A database
is an organized collection of data. The data is typically organized to model
relevant aspects of reality (for example, the availability of rooms in hotels),
in a way that supports processes requiring this information (for example,
finding a hotel with vacancies).
Database
management system
It is a
software system for manipulating database.
What are the
components of database?
Data item
Unit of data contained in a record,
describing a particular attribute (such as name, age, address) and requiring
one or several bits, bytes, or words to represent an entity.
Relationships
A
relationship, in the context of databases, is a situation that exists between
two relational database tables when one table has a foreign key that references
the primary key of the other table. Relationships allow relational databases to
split and store data in different tables, while linking disparate data items.
Constraints
Constraints
are mostly a collection of indexes and triggers that restrict certain actions
on a table.
Schema
It is structure
described in a formal language supported by the database management system
(DBMS) and refers to the organization of data to create a blueprint of how a
database will be constructed (divided into database tables).
DBMS
(Database management system)
What are the
functions of DBMS?
Define,
create and organize a database
Input data
Process data
Maintain
data integrity and security
Query
database
What are the
examples of DBMS?
Microsoft
Access
Oracle
IBM DB2
MySQL
Database
system
The DBMS
software together with the Database is called a database system. It can be
defined as
an organization of components that defines and regulate the collection,
storage,
and maintain
information.
What are the
advantages of database system?
Controlled
redundancy
Data
consistency
Enforcing
data integrity
Data sharing
Ease of
application development
Data security
Multiple
user interfaces
Backup and
recovery
Program data
independence
Data
abstraction
Support
multiple views of the data.
Database
terminology
Field
Record
Key field
Table
Relational database
Objects
Building
database using MS Access
What is
ACCESS?
Access is the
database-management program, part of the Microsoft Office suite, which enables
you to maintain databases.
