Introduction to Database Management Systems (CS-504)
rgpv bhopal, diploma, rgpv syllabus, rgpv time table, how to get transcript from rgpv, rgpvonline,rgpv question paper, rgpv online question paper, rgpv admit card, rgpv papers, rgpv scheme
B.Tech RGPV notes AICTE flexible curricula Bachelor of technology
Syllabus
UNIT 1:
Database Management System Concepts: Introduction, Significance of Database,
Database System Applications; Data Independence; Data Modeling for a Database; Entities
and their Attributes, Entities, Attributes, Relationships and Relationships Types, Advantages
and Disadvantages of Database Management System, DBMS Vs RDBMS.
UNIT 2:
Database Models and Implementation: Data Model and Types of Data Model,
Relational Data Model, Hierarchical Model, Network Data Model, Object/Relational Model,
Object-Oriented Model; Entity-Relationship Model, Modeling using E-R Diagrams, Notation
used in E-R Model, Relationships and Relationship Types; Associative Database Model
UNIT 3:
SQL : Data Definition Language : Categories of SQL Commands; Data Definition
Language ; Create table , Drop table and Alter Table . Primary Key , Foreign Key, Truncate
Table, Index, Cursor.
UNIT 4:
SQL DML :Data Manipulation Language, Insert Statement, Multiple Inserts,
Delete Statement, Delete with conditions , Update statement, Update with Conditions ,
Merge Statement,
UNIT 5:
SELECT . SQL queries, Data extraction from single, multiple tables equi-join, non
equi-join, self-join, outer join. Usage of like, any, all, exists, in Special operators.
Hierarchical queries, inline queries, flashback queries. Introduction of ANSI SQL,
anonymous block, nested anonymous block, branching and looping constructs in ANSI SQL.
NOTES
- Unit 1
- Unit 2
- Unit 3
- Unit 4
- Unit 5
Books Recommended
1. Date C J, “An Introduction To Database System”, Pearson Educations
2. Korth, Silbertz,Sudarshan, “Fundamental of Database System”, McGraw Hill
3. Rob, “ Data Base System:Design Implementation & Management”, Cengage Learninig
4. Elmasri, Navathe, “Fundamentals Of Database Systems”, Pearson Educations
5 . Atul Kahate , “ Introduction to Database Management System”, Pearson Educations
6. Oracle 9i Database Administration Fundamental-I, Volume I, Oracle Press,TMH.
7. Paneerselvam,”DataBase Management System”, PHI Learning
You May Also Like
- CS-501 - Theory of Computation
- CS-502 - Database Management Systems
- CS-503 - Data Analytics
- CS-503 - Pattern Recognition
- CS-503 - Cyber Security
- CS-504 - Internet and Web Technology
- CS-504 - Object Oriented Programming
- CS-505 - Lab (Linux)
- CS-506 - Lab (Python)
- CS-507 - Evaluation of Internship-II
- CS-508 - Minor Project-I