Database Management System detailed syllabus for Communication & Computer Network (CN) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Communication & Computer Network students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Communication & Computer Network 4th Sem scheme and its subjects, do visit Communication & Computer Network (CN) 4th Sem 2021 revision scheme. The detailed syllabus of database management system is as follows.
Course Objectives:
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Course Outcomes:
On completion of the course, the student will be able to:
- To describe about Database systems
- To illustrate Database Design.
- To write queries in SQL
- To relate Emerging Technologies
Module 1:
Database Systems Database Systems – Data – Information – Record – Field – Need of database system -Advantages and Disadvantages – application areas – people who interact with database -Three schema Architecture – Data independence – Data models – Database Schema versus database instance – Component modules of DBMS- Classification of DBMS.
Module 2:
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Module 3:
Structured Query Language SQL – Features of SQL – Data types in SQL – CREATE TABLE command, Constraints – NULL, DEFAULT,CHECK, PRIMARY KEY, UNIQUE, referential Integrity – INSERT, UPDATE and DELETE command – SELECT statements with WHERE, ORDER BY clause – Aggregate and scalar functions in SELECT statements. Database connectivity using JDBC/ ODBC
Module 4:
Database Design and Emerging Technologies Normalisation -Functional Dependency – Decomposition –.Introduction to Data Mining and Data warehousing (Only theoretical concepts).
Text Books:
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Reference Books:
- Introduction to Database Systems – ITL Education Solutions Ltd – PEARSON-2010
- Database system concepts – Silberschatz, Korth, and Sudarshan (TMH)-Sixth Edition
- SQL for professional – Swapne & Rajesh Naik
- Adam Fowler, NoSQL for Dummies, John Wiley & Sons, 2015
- NoSQL Data Models: Trends and Challenges (Computer Engineering: Databases and Big Data), Wiley, 2018
Online Resources
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
For detailed syllabus of all other subjects of Communication & Computer Network (CN), 2021 revision curriculum do visit Communication & Computer Network 4th Sem subject syllabuses for 2021 revision.
To see the syllabus of all other branches of diploma 2021 revision curriculum do visit SITTTR diploma all branches syllabus..
To see the results of Communication & Computer Network (CN) of diploma 2021 revision curriculum do visit SITTTR diploma Communication & Computer Network (CN) results..
For all Communication & Computer Network academic calendars, visit Communication & Computer Network all semesters academic calendar direct link.