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.
