Database System Concepts detailed syllabus for Cloud Computing & Big Data (CC) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Cloud Computing & Big Data 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 Cloud Computing & Big Data 3rd Sem scheme and its subjects, do visit Cloud Computing & Big Data (CC) 3rd Sem 2021 revision scheme. The detailed syllabus of database system concepts 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:
- Describe Database Management System Concepts and Relational Data Model.
- Demonstrate building and manipulating databases using Structured Query Language.
- Illustrate the Relational Database Design using ER Model and Normalization
- Explore the real time transaction processing and NOSQL database
Module 1:
Introduction to Databases: Definition of Data, Database, and DBMS, Characteristics of Database Approach, Advantages of DBMS, Applications of Database systems, Different types of individuals interacting with DBMS, Data Models, Database Schema – Instance -Database state, Three Schema Architecture and Data Independence, Database Languages, Database Interfaces, DBMS Component Modules, Centralized and Client/Server Architecture, Classification of DBMS. Relational Model Concepts: Domain, Attributes, Tuples and Relations, Characteristics of Relations, Relational Model Constraints and Relational Database Schemas, Update Operations and Dealing with Constraint Violations.
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:
Conceptual Modelling: Phases of Database Design, Definition-Entity Types, Entity Sets, Attributes and Keys, Relationship Types, Relationship sets, Roles, Structural Constraints, Weak Entity Types, ER Diagrams, Naming Conventions, Relationship Types of Degree higher than two. Design ER model for Real applications. Enhanced ER model: Specialization and Generalization Functional Dependency and Normalization: Informal design guidelines for relation schema, Functional Dependencies, Normal Forms – 1NF, 2NF, 3NF, BCNF, 4NF.
Module 4:
Transaction Processing: Introduction to Transaction Processing, Need for Concurrency Control and Recovery, Transaction states, Desirable Properties of Transactions. NOSQL Databases: Introduction to NOSQL, Characteristics of NOSQL systems, Desirable properties of distributed systems with replicated data, CAP Theorem, Categories of NOSQL systems : Document-Based NOSQL Systems – MongoDB, NOSQL Key-Value Stores – DynamoDB*, Column-Based NOSQL Systems – Hbase Data model and versioning*, NOSQL Graph Databases – Neo4j Data Model* *Basic concepts only
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:
- Silberschatz, Korth, and Sudarshan, Database system concepts, McGrawHill, 6th Ed.
- Bayross, Ivan BPB, SQL/ PL/SQL, New Delhi
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 Cloud Computing & Big Data (CC), 2021 revision curriculum do visit Cloud Computing & Big Data 3rd 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 Cloud Computing & Big Data (CC) of diploma 2021 revision curriculum do visit SITTTR diploma Cloud Computing & Big Data (CC) results..
For all Cloud Computing & Big Data academic calendars, visit Cloud Computing & Big Data all semesters academic calendar direct link.