(http://www.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/)
Share
Share
Share
(http://www.addthis.com/bookmark.php?v=
US&s=linkedin&url=http%3A%2F%2Fwww.st
STUDYROOM (http://studytonight.com/studyroom/)
dbms.php&title=Overview%20of%20Database
12/54467d48bf9e2aa9/2&frommenu=1&uid=5
Share
FLASHCARDS NEW (http://studytonight.com/flashcards/)
Home (http://www.studytonight.com/)
Like
7.5k
Core Java (http://www.studytonight.com/java)
C++ (http://www.studytonight.com/cpp)
DBMS (http://www.studytonight.com/dbms)
C Language (http://www.studytonight.com/c)
Search
LogIn (http://www.studytonight.com/login)
More... (http://www.studytonight.com/library)
SignUp (http://www.studytonight.com/register)
Like
58
Suggest (http://www.studytonight.com/suggest)
344
Overview of Database
A 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 of DBMS
where related piece of information is stored and various operations can be performed on it.
(overview-of-dbms)
Database Architecture
(architecture-of-database)
DBMS
Database Model (database-
A DBMS is a software that allows creation, definition and manipulation of database. Dbms is actualy a tool used
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)
maintains data consistency in case of multiple users. Here are some examples of popular dbms, MySql, Oracle,
RDBMS Concept (rdbms-
Sybase, Microsoft Access and IBM DB2 etc.
concept)
Database key (databasekey)
Normalization (databasenormalization)
Components of Database System
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 (tcl-
Users : Users may be of various type such as DB administrator, System developer and End users.
command)
Database application : Database application may be Personal, Departmental, Enterprise and Internal
DCL Command
All DCL Command (dclcommand)
DBMS : Software that allow users to define, create and manages database access, Ex: MySql, Oracle etc.
Database : 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
Group BY clause (groupby-
Provides Utility services
clause)
Provides a clear and logical view of the process that manipulates data.
Having clause (havingclause)
DISTINCT keyword (distinctkeyword)
Advantages of DBMS
AND & OR operator (sql-
Segregation of applicaion program.
and-or-operator)
Minimal data duplicacy.
Advance SQL
Easy retrieval of data.
SQL Constraints (sql-
Reduced development time and maintainance need.
constraints)
SQL function (sql-function)
SQL Join (joining-in-sql)
SQL Alias (sql-alias)
Disadvantages of DBMS
SQL SET operation (set-
Complexity
operation-in-sql)
Costly
SQL Sequences (sql-
Large in size
sequences)
SQL Views (sql-views)
Next (architecture-of-database.php)
Test Yourself !
If you have studied all the lessons
of DBMS, then evaluate yourself by
taking these tests.
DBMS Topical Test (http://www.studytonight.com/dbms/tests/)
Subjects : Core Java (http://www.studytonight.com/java)
(http://www.studytonight.com/dbms)
C++ (http://www.studytonight.com/cpp)
C Language (http://www.studytonight.com/c)
DBMS
Servlet (http://www.studytonight.com/servlet)
Studytonight 2013 Handcrafted with Love
About Us (http://www.studytonight.com/about) Suggest (http://www.studytonight.com/suggest) Terms (http://www.studytonight.com/terms) Contact Us
(http://www.studytonight.com/contact) Collaborate (http://www.studytonight.com/collaborate/) Blog (http://studytonight.tumblr.com/)
