Database Management System [DBMS] Tutorial

Database Management System [DBMS] Tutorial

DATABASE MANAGEMENT SYSTEM [DBMS] TUTORIAL

Simply Easy Learning by



i

ABOUT THE TUTORIAL

Database Management System [DBMS] Tutorial

Database Management System or DBMS in short, refers to the technology of storing and retriving users data with utmost efficiency along with safety and security features. DBMS allows its users to create their own databases which are relevant with the nature of work they want. These databases are highly configurable and offers bunch of options.

This tutorial will teach you basics of Database Management Systems (DBMS) and will also take you through various advance concepts related to Database Management Systems.

Audience

This tutorial has been prepared for the computer science graduates to help them understand the basic to advanced concepts related to Database Management systems . After completing this tutorial you will find yourself at a moderate level of expertise in DBMS from where you can take yourself to next levels.

Prerequisites

Before you start proceeding with this tutorial, I'm making an assumption that you are already aware about basic computer concepts like what is keyboard, mouse, monitor, input, putput, primary memory and secondary memory etc. If you are not well aware of these concepts then I will suggest to go through our short tutorial on Computer Fundamentals.

TUTORIALS POINT Simply Easy Learning

Page 1

Table of Content

Database Management System [DBMS] Tutorial ..................... 1 Audience.................................................................................. 1 Prerequisites ............................................................................ 1 DBMS Overview....................................................................... 7 Characteristics ......................................................................... 7 Users ....................................................................................... 8 DBMS Architecture .................................................................. 9 3-tier architecture ..................................................................... 9 DBMS Data Models ............................................................... 11 Entity-Relationship Model ...................................................... 11 Relational Model .................................................................... 12 DBMS Data Schemas ............................................................ 13 Database schema .................................................................. 13 Database Instance ................................................................. 14 DBMS Data Independence .................................................... 15 Data Independence:............................................................... 15 Logical Data Independence ................................................... 15 Physical Data Independence ................................................. 16 ER Model : Basic Concepts ................................................... 17 Entity...................................................................................... 17 Attributes................................................................................ 17 Types of attributes: ................................................................ 17 Entity-set and Keys ................................................................ 18 Relationship ........................................................................... 18 Relationship Set: .................................................................... 18 Degree of relationship ............................................................ 18

TUTORIALS POINT Simply Easy Learning

Page 2

Mapping Cardinalities:............................................................ 18 ER Diagram Representation .................................................. 21 Entity...................................................................................... 21 Attributes................................................................................ 21 Relationship ........................................................................... 23 Binary relationship and cardinality.......................................... 23 Participation Constraints ........................................................ 24 Generalization Aggregation.................................................... 26 Generalization........................................................................ 26 Specialization......................................................................... 26 Inheritance ............................................................................. 27 Codd's 12 Rules..................................................................... 28 Rule 1: Information rule.......................................................... 28 Rule 2: Guaranteed Access rule ............................................ 28 Rule 3: Systematic Treatment of NULL values ....................... 28 Rule 4: Active online catalog .................................................. 28 Rule 5: Comprehensive data sub-language rule .................... 28 Rule 6: View updating rule ..................................................... 28 Rule 7: High-level insert, update and delete rule .................... 29 Rule 8: Physical data independence ...................................... 29 Rule 9: Logical data independence ........................................ 29 Rule 10: Integrity independence............................................. 29 Rule 11: Distribution independence ....................................... 29 Rule 12: Non-subversion rule................................................. 29 Relation Data Model .............................................................. 30 Concepts................................................................................ 30 Constraints............................................................................. 30 Key Constraints:..................................................................... 30 Domain constraints ................................................................ 31 Referential integrity constraints .............................................. 31 Relational Algebra.................................................................. 32 Relational algebra .................................................................. 32 Select Operation ()............................................................... 32 Project Operation ()............................................................. 33 Union Operation () ............................................................... 33 Set Difference ( - )................................................................. 34 Cartesian Product ()............................................................. 34 Rename operation ( ) .......................................................... 34 Relational Calculus ................................................................ 35

TUTORIALS POINT Simply Easy Learning

Page 3

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download