Lectures List
capscom technology computer course almora

Database and related concepts

DATABASE

A database is an organized collection of facts.
 
example of database is collection of students record, collection of blog posts, collection of images.
 

Fundamental of records

When we place data of any object in the form of properties is called record
for example we want to store data for the person like 
  1. first_name
  2. last_name
  3. email
  4. password
  5. address
  6. mobile
  7. gender, etc
 

Field

Column containg data in a table is called field.
like name, mobile, gender, email, password, etc.
 

Record

Collection of related fields in a table is called record.
 

File

Collection of related records is called the file.
 

Database

Collection of related files is called the database.
 

Key field

If more than one table has a common field is called key field.
 
for example
users
  1. id
  2. name
  3. email
  4. mobile
 
posts
  1. id
  2. title
  3. data
  4. post
  5. user_id
 
As you can see posts table has a column user_id that belongs to the users table is called the key field.
 
 

DBMS (Database management system)

It is a software package that allows data to be effectively stored, retrieved and manipulated.
 
some common popular DBMS examples are MS Access, SQL Server, Oracle, MYSQL etc.
 

Data

Data are raw facts that can be manipulated.
 

Information 

Processed form of data is called the information.
 

Data processing

There are three stages for data processing
  1. Capturing data from the source.
  2. Store the data
  3. Update and retrieve the data in the form of information.
 

Data management

Data managemenet is the arrangement of all the data and information where we define.
Data administration
Standards for the defining data like how the data will store
Define the way how different users will use the data.
 

Data independence

Data independence allows a database to be changed dynamically.
We can add the data
we can change the structure of schema like
  1. alter columns
  2. delete columns
  3. add new columns
 
 

Types of DBMS users.

There are four types of DBMS users.
 
  1. Naive users(End users)
  2. Online users
  3. Application programmers
  4. DBAs
 

Naive users(End users)

Now days naive users are called end users, end users has very limited access to the database as programmer define at the time of development of system.
For example, who is using facebook to create new profile, add new post and like the post are called the end users.
 

Online users

Online users use the database using computer terminal and they has some basic knowledge about the structure of database
 

Application programmers

These users develop the system and connect the system with the database.
 

Database administrator

These users has complete information about the database like what is the structure of database and how it is formed and how is managing and also know about the system of Current DBMS.
 
 

Data models

A data model is a description of the organization of a database.
 
description of the organization means how data organized in the database.
 
Data models are categorized into three parts.
 
  1. File based data models
  2. Traditional data models
  3. Semantic data models
 
 

File baesd data models

In file based data models records are store in the file.
 

Traditional data models

Traditional data models categorised into three parts
  1. Hierarchical 
  2. Network
  3. Relational
 

Semantic data models

File or traditional based system are used to store the data whereas semantic data models are used to store knowledge that is done by the researchers or artificial intelligence machines.
 
 

Characteristics of a DBMS.

  1. Create relationship between different data
  2. Control the data redundancy
  3. Ensure data can be shared across all the applications
  4. Enforce data access authorization
  5. Allow automatic and intelligent data backup
  6. Has different interface to access and manipulate the data.
Author/Written by: Mr Hemant Singh (Founder)
Terms & Conditions CAPSCOM TECHNOLOGY Pvt. Ltd. का बेहतर रूप से संचालन करने के लिए यहॉ कुछ नियमें और शर्ते लागू है अगर आप कैप्सकॉम टैक्नोलॉजी में पढ़ रहे है तो यह आप पर लागू होता है।