DBMS INDEX
DOWNLOAD NOTES FROM BOTTOM OF THE POST
1.
OVERVIEW OF DBMS
a.
Define
b.
Advantages of DBMS
c.
Database Languages
d.
Applications of DBMS
e.
Users of DBMS
f.
DBMS Architecture (3-level)
·
Levels of abstraction
g.
Database Schema
h.
Database Instance
i.
Keys in DBMS
j.
Hierarchical Database Model
k.
Network Database Model
l.
Relational Model
m.
ER Model (entity – relationship )
·
Concept
·
Mapping – constraints
·
Attributes
2.
PROPERTIES OF DBMS
a.
Diffn. betwn. DBMS & RDBMS
b.
Integrity Constraints
c.
EF Cord Rules of DBMS
3.
NORMALIZATION
a.
Concept
b.
Insertion, Deletion and Updation Anomaly
c.
Advantages of normalization
d.
Functional Dependencies
e.
Properties of Fundamental Dependencies
f.
Types of Normalization
4.
FUNCTIONS
a.
Features
b.
Rules
c.
Components
d.
Filtering the table
e.
Operators
·
Create
·
Insert
·
Delete
·
Update
f.
Eliminating duplicate rows (distinct)
g.
Modify alter
h.
Mathematical and String Operators
·
Arithmetic
·
Relational
·
Logical
·
Range Search
·
Set Searching
·
Char / Pattern
i.
Renaming
j.
DUAL Table
k.
SQL Functions
·
Aggregate
·
Numeric
·
String or Char
·
Date
l.
Group By & Having Clause
·
Primary
·
Foreign
·
Not NULL
·
Check
·
Unique
n.
Group By Using
·
Roll Up
·
Cube
o.
JOINS
·
Inner
·
Left
·
Right
·
Full
p.
Granting & Revoking
q.
Views
r.
Data Dictionary
s.
Index
·
Clustered
·
Non – Clustered
