Part-I1/ 2nd 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
- Oracle DBA by Mohammad Khalid.
- Modern Data base System by Thomas Carolli.
- Data Base System By Raymond.
- Introduction to Data Base By Imran Syed
sana ullah this notes published for me please things
ReplyDelete