Database Management

Database Management

 

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.