Home > Link, Microsoft SQL Server, MSBI, Optimization, Query, Script, SQL PraRup, SQL Query, SQL Server, TSQL, Vishal Pawar > BISQL – Laymen to SQL Developer # 10 – DBMS [Database Management System] #1 – Introduction, Database Environment, Working of a Simple Centralized Database System

BISQL – Laymen to SQL Developer # 10 – DBMS [Database Management System] #1 – Introduction, Database Environment, Working of a Simple Centralized Database System

Hi Folks,

This post is part of Series Database Management Systems

Currently running topic for this series is listed as below :

Series of Database Management Systems

>>Chapter 1 : DBMS [Database Management Systems]<You are Here>

Continuing from my previous post on this series, If you have missed any link please visit link below

We are going to Cover the Following Points in this article

  • Introduction
  • Database Environment
  • Working of a Simple Centralized Database System

Introduction

image

Database Environment

Let us take an example of name, roll number, class, section, attendance and marks of the students of any class. One can have the note of these data in a sequential address book or it can be stored on a hard disk, using a laptop and software like Microsoft Excel. Here name, roll number, class, section, attendance and marks of the students are considered as data and the set of this related data having a specific implicit meaning is called a database.

image

Database Environment

Various Procedures Carried on in a DBMS
1. The process of specifying the data types, structures and constraints is called Defining the database
2. The process of storing the data on some storage medium
3. Manipulating the Database-involves the retrieval (activity of finding) of required data and modifying it depending on the requirement.

E.g. EMPLOYEE database –
i) Defining of a database

image

ii) Constructing the Database

image

iii) Manipulating the Database
E.g. for some queries
1. List all employees whose salaries are greater than 20000
2. List all employees whose names start with “P”
3. Delete records whose Emp_name is Prasad

Working of a Simple Centralized Database System

image

Simple Centralized Database System

Database is stored in a central location.  
Users have access to the common database.  
Users can access the data from the central location from their own machines using suitable programs. These required programs are installed on individual computer terminals of the users, as shown in the figure above.

Hope you will like Series of Database Management Systems series !

If you have not yet subscribe this Blog , Please subscribe it from “follow me” tab !

So that you will be updated @ real time and all updated knowledge in your mail daily for free without any RSS subscription OR news reading !!

Happy Learning and Sharing !!

For More information related to BI World visit our all Mentalist networks Blog

SQL Server Mentalist … SQL Learning Blog

Business Intelligence Mentalist … Business Intelligence World

Microsoft Mentalist … MVC,ASP.NET, WCF & LinQ

MSBI Mentalist … MS BI and SQL Server

NMUG Bloggers …Navi Mumbai User Group Blog

Architectural Shack … Architectural implementation and design patterns

DBA Mentalist …Advance SQL Server Blog

MVC Mentalist … MVC Learning Blog

Link Mentalist … Daily Best link @ your email

Infographics Mentalist … Image worth explaining thousand Words

Hadoop Mentalist … Blog on Big Data

BI Tools Analysis … BI Tools

Connect With me on

| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS | About Me |

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: