Login
Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Overview Of Database

Sandeep Tiwari
15/12/2017 0 0

A Database is a collection of related data organised in a way that data can be easily accessed, managed and
updated. Any piece of information can be a data, for example name of your school. Database is actualy a place
where related piece of information is stored and various operations can be performed on it.

1. DBMS:

A DBMS is a software that allows creation, definition and manipulation of database. Dbms is actualy a tool used
to perform any kind of operation on data in database. Dbms also provides protection and security to database. It
maintains data consistency in case of multiple users. Here are some examples of popular dbms, MySql, Oracle,
Sybase, Microsoft Access and IBM DB2 etc.

2. Components of Database System:

The database system can be divided into four components.

i. Users: Users may be of various type such as DB administrator, System developer and End users.

ii. Database application: Database application may be Personal, Departmental, Enterprise and Internal

iii. DBMS: Software that allow users to define, create and manages database access, Ex: MySql, Oracle etc.

iv. Database: Collection of logical data.

3. Functions of DBMS:

i. Provides data Independence.

ii. Concurrency Control.

iii. Provides Recovery services.

iv. Provides Utility services.

v. Provides a clear and logical view of the process that manipulates data.

4. Advantages of DBMS:

i. Segregation of applicaion program.

ii. Minimal data duplicacy.

iii. Easy retrieval of data.Reduced development time and maintainance need.

5. Disadvantages of DBMS:

i. Complexity.

ii. Costly.

iii. Large in size.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

What Is Power Query?
Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft...
PowerPivot For Excel
PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous...
What Are Macros?
i. Macros are little programs that run within Excel and help automate common repetitive tasks. Macros are one of Excel's most powerful, yet underutilized feature. Using macros, you can save hours and boost...
What Is Phython?
Python is a general-purpose interpreted, interactive, object-oriented, and high-level programming language. It was created by GuidovanRossum during 1985- 1990. Like Perl, Python source code is also available...
Power View
Power View is now a feature of Microsoft Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions. Power View...

Looking for Database Training classes?

Find best Database Training classes in your locality on UrbanPro.

Do you offer Database Training classes?

Create Free Profile »
Sponsored

Find Best Database Training classes?

Find Now »