Overview of Database Management System _ Studytonight

 (http://ww  (http://www.studytonight.com/) w.studytonight.com/) ONLINE COURSES COURSES (http://studytonight.com/online-courses/) (http://studytonight.com/online-courses/)

Database

" Without SQL, websites will never have any way to handle Databases for data. " LIBRARY (http://studytonight.com/library/) (http://www.addthis.com/bookmark.ph US&s=linkedin&url=http%3A%2F%2Fw STUDYROOM STUDYROOM (http://studytonight.com/studyroom/) (http://stud ytonight.com/studyroom/)

dbms.php&title=Overview%20of%20Dat 12/54467d48bf9e2aa9/2&frommenu=1&

FLASHCAR FLASHCARDS NEW (http://s tudytonight.com/flashcards/)

Ho m e ( h tt tt p :/ :/ /w /w ww ww .s .s t ud ud y to to ni ni gh gh t .c .c o m/ m/ ) Like

7.5k

C or or e J a va va ( ht ht t p: p: // // ww ww w .s .s t ud ud yt yt o ni ni gh gh t .c .c om om /j /j a va va )

C+ + ( ht ht t p: p: / /w /w ww ww .s .s t ud ud yt yt o ni ni gh gh t .c .c om om /c /c pp pp )

D B MS MS ( h tt tt p :/ :/ /w /w ww ww .s .s t ud ud y to to ni ni gh gh t .c .c o m/ m/ db db ms ms )

C Language (http://www.studytonight.com/c) Search

LogIn (http://www.studytonight.com/login)

More... (http://www.studytonight.com/library)

SignUp (http://www.st (http://www.studytonight.com/register) udytonight.com/register) Like 58 Suggest (http://www.studyt (http://www.studytonight.com/suggest) onight.com/suggest)

344

Overview of Database  A Database is Database is a collection of related data organised in a way that data can be easily accessed, managed and

Database Concept

updated. Any piece of information can be a data, for example name of your school. Database is actualy a place

Overview Overview of DBMS

where related piece of information is stored and various operations can be performed on it.

(overview-of-dbms) (overview-of-dbms) Database Architecture (architecture-of-database)

DBMS

Database Model (database-

 A DBMS is DBMS is a software that allows creation, definition and manipulation of database. Dbms is actualy a tool used

model) model)

to perform any kind of operation on data in database. Dbms also provides protection and security to database. It

Codd's rule (codd-rule) (codd-rule)

maintains data consistency in case of multiple users. Here are some examples of popular dbms, MySql, Oracle,

RDBMS Concept Concept (rdbms-

Sybase, Microsoft Microsoft Access and IBM DB2 etc.

concept) concept) Database Database key (databasekey)

Components of Database System

Normalization Normalization (databasenormalization) normalization)

The database system can be divided into four components.

E-R Diagrams (er-diagram) Generalization and Specialization (generalization-andspecialization) SQL Concept SQL Introduction (introduction-to-sql) DDL Command Create query (create-query)  Alter query (alter-query) Truncate, Drop and Rename query (truncate-droprename-query) DML Command  All DML command (dmlcommand) TCL Command  All TCL Command (tclcommand) DCL Command

Users : Users : Users may be of various type such as DB administrator, System developer and End users. Database application : Database : Database application may be Personal, Departmental, Enterprise and Internal DBMS : Software : Software that allow users to define, create and manages database access, Ex: MySql, Oracle etc.

 All DCL Command (dclcommand)

Database : Collection : Collection of logical data.

WHERE clause (whereclause) SELECT query (selectquery) LIKE clause (like-clause) ORDER BY clause (orderbyclause)

Functions of DBMS Provides data Independence Concurrency Control Provides Recovery services