HTML

 

DATABASES  AND SQL

 

Database:- it is a combination of two word first data which means raw facts and figures and second base where data is to be stored.

►   Organize collection of data is known as data base.

►   It serves as a base from which the desired or multiple information can be retrieved by further reorganizing or processing the same data.

►   It is created or managed by a system is known as database management system.

►   A DBMS (database management system) or collection of database or database files in an automated way.

►   Now –a-days , organizations are realizing the importance and need of proper storage and manipulation of data as they feel that relevant information on time is the key of good decision-making. And as we know that good decision –making is the key to success for any organization.

DBMS:- it stands for database management system.

►   It is a computerized record keeping system whose purpose is to manage the data and make it available as per the requirement.

►   It can be referred to as a digital filing system.

►   It is a package that enables the users to store, modify and properly maintain the database and that helps to extract useful information from the database as and when required.

►   It is a software designed to gather , handle and process the information.

►   It manipulates different information in such a way that helps to analyze the data and thus help in decision making.

►   It performs the tasks of maintaining databases so that the information is readily available.

►   It helps to manage the data of different sectors like banks, corporate, railways ,airlines ,universities, hospital , space explorations, etc.

►   DBMS is used to build the database and also to manage the databases in different ways like:-

i.                    Adding new records

ii.                  Editing existing records

iii.                Removing unwanted data

iv.                 Sorting data either in ascending or descending

v.                   Extracting the data based on quires

vi.                 Updating and manipulating data item

vii.               Viewing data , generating reports

viii.             Performing calculations on it.

►   The DBMS serves as the intermediary between the user and the database.

►   There are some examples of DBMS packages are MySQL , Oracle, MS-Access, Sybase , dBase , FoxPro, Open Office Base.

►   The person having the centralized control over the database system is called the Database Administration.

►   The database administrator is an I.T.  expert who is responsible for the technical operations and management of database.

Benefits of database management system

There are following benefits of DBMS such as:-

1.      Reduction of Data Redundancy

2.      Reduction in data inconsistency

3.      Sharing of Data

4.      Enforcement of Data Standards

5.       Ensure Data Security

6.      Data Integrity

7.      Interactive interface

 

1.       Reduction of Data Redundancy:- it refers to the duplication or the repetition of data.

►   In non-database systems , each application has its own separate collection of files. It leads to the repetition of the stored data, thus resulting in wastage of space and time.  So in such situation our DMBS helps to us to mange centralized data. And there is  less chances of duplication.

 

2.       Reduction in Data Inconsistency:- In DBMS , the stored database is consistent and remains updated, in case data of any item is changed then the changes are done automatically to all other portions wherever that data has been used. This process is known as propagating update.

 

3.       Sharing of data :- it means that the same data made stored at one place and can be shared by multiple users or for different applications. So it saves our time and cost in creating new record again .

 

4.       Enforcement of Data standards:- in DBMS, access to the database is done in a standardized and systematic manner. Standard may relate to the naming of the data , format of data, report generation, structure of data ,and so on.

 

5.       Ensure Data Security:- A database management system ensures security as only the authorized users are allowed to access the data of a database. To operate different users can be given separate & restricted access levels to the data of a database.

 

6.       Data Integrity :- it means that validity of data. The database management system ensures that only valid data can be entered into the database. There may be certain standard laid down by an organization , which needs to be implemented while storing the data in the database.

 

7.       Interactive interface:- DBMS provides more convenient interface to enter or view data. In conventional systems, usually the data is not arranged properly and as a result, the availability of organized information becomes poor and it becomes too difficult to search the required information from a huge database.

 

ELEMNTS OF DATABASE

Table :- A table is a collection of logically related records.

►   The multiple records of a database are arranged together in a tabular structure to make a table.

►   It is a made up of rows and columns.

►   Column represents a field which contains information of a particular type , whereas a row represents record which contains information of the related fields.

 

NAME	FATHERS NAME	MOTHERS NAME	ADDRESS

 

 

Field :- A field represents one related part of a table.

►                    It contains the logically related data contained in a database.

►                    It is a vertical line in a table.

 

Record:- A record is a collection of multiple data which are stored in related fields that can be treated as a single unit.

►   It represents the data which are entered in a set of different fields which are related to a particular item.

 

COMPONENTS OF DATABASE PACKAGE

There are following components of database package.

1.       TABLES

2.       QUERIES

3.       FORM

4.       REPORT

 

1.       Table :- A table is the   basic element of a database in which data are kept in columns (field) or rows(record). It acts as a container which stores data.

 

2.       Queries :- it is a call or request command which is used to generate some information from tables. And it also helps to whatever you want to do with table. It is the basic tool for retrieving information from the tables of database.

 

►   It also help in the filtration of a large volume of data and displays required format of information.

►   It fetches records from one or more tables of a database so that they can be viewed, analyzed and stored on a common database.

►   It produces information according to specified need.

 

3.       Forms :- it is a layout that provides an interface to view the data or enter new data or to modify the existing data records.

►   A form can be saved separately and when needed it can be modified or deleted within the respective table.

 

4.       Reports :- it displays the information in a format as per user’s need.

►   It is used to view and print information.

►   It can be represent information whose data can be from a single table or from more than one table.

►   Reports can be previewed on screen or on page.

 

 

Field name :- A field name is the identifier of a field as it contains the data that is to be stored in that field. Generally , it represents a particular property of the table entity. For example in a table of student record ‘name’ field describes the name and ‘age’ field describes the age of the student.

►   In other words field name is the name of field.

►   It denotes the contents of that field.

►   Field name can consists of letters , numbers and some special characters like period(.), exclamation marks(!), single apostrophe(‘), square brackets([ ]) etc.

►   The name of field consists of more than two words, then join them by (_) underscore sign.

Field type :- it shows the type of the field and  what kinds of data is to be stored in that particular field and what kinds of operation can be performed on that data.

►   For example , Marks can be only numeric data and not alphabetical, so  data type of the field’ Marks’ should be Numeric.

►   The data type of a field depends upon the values to be entered in that field.

 

Field properties:- it controls the behaviour of the field.

►   They are related directly with the consistency in the data that is entered by user.

►   There are following field properties such as-

§  Entry Required :- This property is applied if the field cannot be kept blank i.e. it ensures that the user always enters some data in the field.

►   Auto value:- it refers to the data or value that is automatically applied in the field. the user has to choose “yes” if this field should contain Auto Increment values. One cannot enter data in the fields of this type.

 

§  Length :- This property is used to specify the length of the data that can be stored in a field.

 

►   For Numeric Fields:- The default length of numeric data type is a field varies with respect to its type.

 

►   For text[Varchar] fields:- The default length of Text[Varchar] is fifty(50) characters.

 

►   For Yes/No[BOOLEAN] field:- The default length of Yes/No[BOOLEAN] is one character.

 

►   For Other[OTHER] Fields:- The default length of Other[OTHER] is 2147483647.

 

§  Default Value:- This property is used to enter a default value (string) in a field.  When the user enters the data in the table then the default value will be used in each new record for the respective field selected.

 

§  Format:- This property is used to determine the format of output of the data.