Syllabus B Tech Computer Science Fifth Semester Introduction to Database Management Systems CS504

The concepts developed in this course will aid in quantification of several concepts in Computer Science Engineering that have been introduced at the Engineering courses. Technology is being increasingly based on the latest Syllabus B Tech Computer Science Fifth Semester Introduction to Database Management Systems CS504 is given here.

The objective of this course “Syllabus B Tech Computer Science Fifth Semester Introduction to Database Management Systems CS504“ is to develop ability and gain insight into the process of problem-solving, with emphasis on thermodynamics. Specially in following manner: Apply conservation principles (mass and energy) to evaluate the performance of simple engineering systems and cycles. Evaluate thermodynamic properties of simple homogeneous substances. Analyze processes and cycles using the second law of thermodynamics to determine maximum efficiency and performance. Discuss the physical relevance of the numerical values for the solutions to specific engineering problems and the physical relevance of the problems in general and Critically evaluate the validity of the numerical solutions for specific engineering problems. More precisely, the objectives are:

To enable young technocrats to acquire mathematical knowledge to understand Laplace transformation, Inverse Laplace transformation and Fourier Transform which are used in various branches of engineering.
To introduce effective mathematical tools for the Numerical Solutions algebraic and transcendental equations.
To acquaint the student with mathematical tools available in Statistics needed in various field of science and engineering.

CS 504 – Introduction to Database Management Systems

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..

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.

Syllabus B Tech Computer Science Fifth Semester Introduction to Database Management Systems CS504

CS 504 – Introduction to Database Management Systems

Books Recommended

Related Posts

Syllabus B Tech Computer Science Eighth Semester Cyber Law And Ethics CS8004

Syllabus B Tech Computer Science Eighth Semester Computer Peripherals And Interfaces CS8003

Syllabus B Tech Computer Science Eighth Semester Augmented And Virtual Reality CS8004