Introduction to Data base

Part-I1/ 2^nd Term Semester                                            Diploma in information Technology

Introduction to Data base    

(PAPER-I1)

Total Th Hrs   80                                                                           Total Pr Hrs       40

Total Th Mks 100                                                                         Total Pr. Mks      50

Objective

1.                  Introduction to Data base

(a)                           Introduction

(i)                 Data

(ii)               Information

(iii)             Meta Data

(iv)             Definition of Data Base

(v)               Advantages of Data Base

(b)                           Data base Model

(i)                 Hierarchal Model

(ii)               Network Model

(iii)             Relation Model

(C )                  Introduction to DBMS

  Function of DBMS

2.                  Entity Relationship Model

(a)                           ERD

(i)                 Elements of ERD Model

(ii)               E-R Diagram

(b)                           Relationships

   Degree of Relationship

(c )       Attributes

(i)                       Introduction to Attributes

(ii)                     Types of Attributes

(c)                            Association

(i)                 1:1

(ii)               1:M

(iii)             M:M

3.                  Normalization

(a)                           Anomalies

(b)                           Function Dependency

(c)                            First Normal Form

(d)                           Second Normal Form

(e)                            Third Normal Form

4.                  SQL ( Using MS SQL Server / Oracle/ My SQL)

(a)                           DDL (Data Definition Language)

(i)                 CREATE Statement

(ii)               ALTER  Statement

(iii)             DROP Statement

(iv)             RENAME Statement

(v)               TRUNCATE Statement

(b)                           DML ( Data Manipulation Language)

(i)                 INSERT Statement

(ii)               UPDATE Statement

(iii)             DELETE Statement

                 ( c)              DCL ( Data Control Language)

(i)                       COMMIT Statement

(ii)                     ROLLBACK Statement

(d)                      Data retrieval

(iv)             SELECT Statement

(v)               WHERE Clause

(vi)             GROUP BY

(vii)           ORDER BY

(viii)         HAVIING Clause

(e)              Function Constraint

 

(ix)             Concept of Key

(x)               Primary Key, Secondary Key, Candidate Key, Alternate Key, Composite Key,

(xi)             NOT NULL Constraint

(xii)           UNIQUE Constraint

(xiii)         Primary Key Constraint

(xiv)         Foreign Key Constraint

(xv)           Check Constraint

(f)              Function

                  (a)        Character Function

(i)                 UPPER

(ii)               LOWER

(iii)             INITCAP

(iv)             CONCAT

(v)               SUBSTR

(vi)             INSTR

(vii)           LENGTH

(viii)         LPAID

(ix)             RPAID

(x)               LTRIM

(xi)             RTRIM

                   (a)           Numeric Function

(xvi)         ROUND

(xvii)       TRUNC

(xviii)     MOD

(xix)         COALESCE

        (b)          Group Function

(xx)           Min

(xxi)         Max

(xxii)       AVG

(xxiii)     SUM

(xxiv)     COUNT

    (c )          Conversion Function

(xxv)       TO-CHAR

(xxvi)     TO-NUMBER

(xxvii)   TO-DATE

    (d)          Introduction Views and data dictionary

(xxviii) Cerate simple / complex view

(xxix)     Importance of view in multi user environment.

      (e)     UNDERSTANDING/ Managing User Privileges and Roles

(i)         Introduction to Multi user environment

                  (ii)        Definition of Role and privileges

(xii)           CREATE USER

(xiii)         CREATE ROLE

(xiv)         DROP USER

(xv)           CRANT PRIVILEGE (DBA,ALL,SELECT, UPDATE, DELETE, INSERT)

(xvi)         Revoking User Privileges and Roles.

Reference Books / Helping Material

1. Oracle DBA by Mohammad Khalid.
2. Modern Data base System by Thomas Carolli.
3. Data Base System By Raymond.
4. Introduction to Data Base By Imran Syed