Database Management System

Introduction to Database Management System:
Every organization have their own kind of data related to their activities, employee, transaction and business which needs to be stored, manipulated and retrieved whenever needed. To keep the record of such types of data a database management system is needed in any organization. Database Management system(DBMS) is a collection of software programs that allow a user to define the data types, structures, storage for the data and manipulate data by query and update operations. Some of the popular DBMS are MS Access, Oracle, MySQL, MS-SQL server etc.

Features of DBMS:

· Large volume of data can be manage easily

· Data security and integrity

· Data sharing

· Reduces data redundancy (duplication of data)

· Easier data management and administration

· Provides concurrent access to data

· Recovering data from the crash

· Support centralized control

Advantages of DBMS:

· It reduces data redundancy. Duplication of data is reduced as a result storage space can be saved and used to store large volume of unrepeated data.

· It allows sharing data according to the need.

· Centralized security can be applied to the DBMS.

· It has high data integrity. Data can be retrieve in a complete form easily using DBMS.

Disadvantages of DBMS:

· Initially investment in hardware, software and training is costly.

· It is difficult to provide security, recovery and integrity service.

· Expenditure on hardware maintenance, software upgrade, backup and recovery forever remains.

Terms related to database management system: before learning about DBMS we must be clear about some terms related to DBMS.

· Data: Data is defined as the raw facts and figures such as Anjali, Itahari, B.Ed. ,1etc. which do not give clear understanding but is further processed to get clear meaning. In other word it is the smallest unit of information.

· Record or Information: Information is the collection of interrelated data processed to convert into meaningful outcome. Record gives the complete information. For example, from the above example, we can process the data as Anjali from Itahari is student of B.Ed. has roll number 1 which now gives a clear meaning.

· Database: Database is the collection if inter-related records which are systematically organized. Database and be manual (non- computerized like paper files, telephone directory or school's attendance register file) or digital (computerized). Its main purpose is to store, organize and retrieve whenever needed.

· Table: The core component of a database is a table. A table is also called the building block of a database. A table itself is made up of rows and columns. Each row in the database is called a record and each column is called as field that combine together to form a complete table.

L.Name	F.Name	Address	contact
Rai	Anjali	Itahari	984675453
Tamang	Muna	Dharan	987654321

Here, the entry for Anjali Rai is a record. L.Name, F.Name, Address, Contact contains a piece of information. These are called fields. Records are made up of fields.

click the link below to learn more

Day One: chapter one

Day Two:chapter two

Day Three: chapter three

Day Four:Introduction to Microsoft Access

Day Five: Data type in MSAccess

Day Six: Relationship types, database record, tuples,fields, naming rules of MSAccess

Day Seven: Database keys and data type

Day Eight: Object of MSAccess, types of Query

Day Nine: Form and Report In MSAccess

Day Ten: MSAccess Form

click the link below to test yourself