Skip to main content

What Is DataBase and How To Use

Introduction  to Database
Data is simply value or set of values. It is an information in unorganized form.
When data is attached with an attribute, it becomes an information.
Database is collection of related information stored , so that it is available to many user for different purpose, Hence data is a organized collection of information.

What Is DataBase and How To Use

Data-Base Management System-
Data-Base Management System is system software for creating and managing database.
The program that stores ,modifies and retrieves data in database on request is called database management system.
The DBMS is allows addition of new record, modification or alteration of existing record or deletion of existing unwanted records.
Hence DBMS is a program that enables user to create and maintain database.
Some commercially available DBMS are ORACLE,DB2 etc.

Popular posts from this blog

What is Relational Database Model

Relational Database Model: 1) The relational database model is developed by “ Edgar F. Codd ” at IBM in 1970. 2) The relational Database Model used the basic concept of a relation or table. 3) A table is a collection of records and each record in a table Contains the same fields. 4) Every row or entity (called Tuple) must have a unique identification or key based on the data. What is Data Base Model 5) The different tables may have the common column name (Attribute), but a single table must not Contain multiple columns (Attributes) with the same name. 6) The relationship between the two tables is implemented using a common and unique attribute in the tables. 7) Columns are attributes that belong to the entity modeled by the table. 8) order of rows (tuples/entity) and columns (attributes) is not important. 9) But every Tuple must be unique. It means that for every record or Tuple in a table there is something that uniquely identified ¡t from any ot...
Read more

What is Entity in Database

What is Entity in Database Entity 1) An entity is an object that exists and is distinguishable from other object. 2) Every entity (also called as tuple) must have a unique identification. It means that for every entity in a table there is something that uniquely identified it from any other entity. 3) For example: “Student Id” in college, Account No. of the customer in a bank etc.   What is Relational Database Model Entity Set: 1) A finite set of entities in the relational database system, represents entity set. 2) Entity Set does not have duplicate entity. 3) The set of all the student having admission in college, all customers of the banks etc . Relationship: I) The association among entities is called a relationship. 2) In other words, a situation exists between two tables when one table has a foreign key that references the primary key of the other table is called Relationship. 3) Each entity has one or more attributes, know...
Read more

What is Normalization in the database

What is Normalization in the database Normalization : 1). Normalization is the process of organizing the tables to minimize data redundancy 2)Redundancy   is storing the same data item in more than one place. Database normalization is a design technique) by which an existing database is modified to minimize redundancy and dependency of data. 4) Edgar F. Codd introduced the concept of normalization in 1970.Objectives   of normalization: Edgar F. Codd stated the objectives of normalization are as follows. To free the collection of relations from undesirable insertion, update and deletion dependencies. 2) To reduce the need for restructuring the collection of relations as new types of data are introduced, and thus increase the life span of application programs. To make the relations model more informative to users. 4 To make the collection of relations neutral to the query statistics. is normalization? Explain 1 NF with suitable example _____ ...
Read more