35252: Relational Database and Management Systems Computers 5th Sem Syllabus for Diploma TNDTE M Scheme

Relational Database and Management Systems detail TNDTE Diploma syllabus for Computer Engineering (CS), M scheme is extracted from TNDTE official website and presented for diploma students. The course code (35252), and for exam duration, Teaching Hr/week, Practical Hr/week, Total Marks, internal marks, theory marks, duration and credits do visit complete sem subjects post given below. The syllabus PDFs can be downloaded from official website.

For all other computers 5th sem syllabus for diploma m scheme tndte you can visit Computers 5th Sem Syllabus for Diploma M Scheme TNDTE Subjects. The detail syllabus for relational database and management systems is as follows.

Rationale:

The Database Management system is a collection of programs that enables to store, modify and extract information from a database. The primary resource that fuels knowledge power is the database. Organizations are employing mechanisms to effectively manage and utilize the data stored in the database. Relational Database management System has been developed to harness the information stored in the database.

The major objectives of this subject is to provide a strong formal foundation in Database Concepts, technology and practice to the students to enhance them into well informed application developers. After learning this subject, the students will be able to understand the designing of RDBMS and can use any RDBMS package as a backend for developing database applications.

Objectives:

On completion subject, the students must be able to

• Define data, database, database Management systems and data base models.
• Compare file processing and database system.
• Study about architecture of DBMS.
• Understand the concept of Data warehousing , Big Data and client/Server Technology
• State CODD’s Rules.
• Explain normalization and explain different types of Normal Forms.
• Create Normalized Database structure files .
• Perform all database DDL, DML, DCL, and all related commands.
• Write Logical and Conditional statement for Database Query.
• Write procedures and functions .
• Create and use Triggers.
• Understanding Data warehousing, Big data and NoSQL

Unit 1

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.

Unit 2

MySQL Administration & Database Design

1. Installation of MySQL:

Features of MySQL- Download, Installing, Starting & Stopping connections to the MySQL server – Accessing MySQL – Command Line, Web Interface (PHP Myadmin) and Desktop Tools (MySQL workbench).

2. Working with MySQL Databases :

Creating (CREATE cmd), selecting (USE cmd) And describing database (DESC cmd)- SHOW cmd – backing up databases.

3. Introduction to MySQL :

MySQL data types -Data Definition Commands: creating, altering, renaming, copying and deleting tables – temporary tables – Data manipulation commands : Insert, update & deleting rows. Data retrieval commands. MySQL Operators and Expressions : Types of operators -Arithmetic, comparison & logical operators – Pattern matching – Import and Export of data

4. Built-in Functions:

Single row functions – Aggregate functions – Conversion functions .

5. Querying the table:

Selecting rows using Where , Order by , group by & Having clauses. Sub-queries – operators used in sub-queries – correlated sub-queries.

6. Flow control :

IF(), IF NULL(),CASE,LOOP,LEAVE,ITERATE,REPEAT,WHILE 1 Hr

Unit 3

MySQL Performance Tuning

1. Indexes and sequences:

Creating index- primary key (single & multiple field) & foreign key, unique key, composite keys, full text indexing, leftmost indexing -dropping index.-Sequences: creating, altering and deleting sequences.

2. Performing multiple table retrieval using Joins & Unions:

Joins – definition -aliasing – Types of Joins: natural join, inner join, self-join, left join, right join. Unions: Definition – Types – Union, Union ALL, Union Distinct – order by and LIMIT handling.

3. Views:

Introduction – Advantages of Views- creating Views, Updating the Views, Deleting the Views.

4. User & Transaction management:

creating users, deleting users, renaming users, grant & revoke commands – Transactions – committing & rollback transactions – save points.

Unit 4

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.

Unit 5

Data warehousing & Introduction to Big data

1. Data warehousing :

Functions of Warehouse – Architecture – Applications -Data mining concepts.- Advantages.

2. Big Data :

Definition – Characteristics – Various Technologies used -Applications – Overview of NoSQL : Difference between RDBMS and NoSQL -Tools used in Big Data, Scalability, Understanding storage architecture .

3. Types of Data stores in NoSQL:

Column oriented data store, Document Store, Key value Store & Graph store – create, access, update and delete data – Querying NoSQL Stores. Using NoSQL in the cloud – Amazon Simple DB

Text Books:

1. MySQL Paul DuBios Addison Wesley (Fourth Edition)
2. Database System Concepts Silber Schatz A. and Korth H McGraw Hill Education (India) Pvt Limited, Sixth Edition
3. Murach’s MySQL Joel Murach Shroff / Murach(2012)
4. NO SQL Distilled PRAMOD J. SADALAGE MARTIN FOWLER Addison Wesley (First Edition)

For detail syllabus of all other subjects of BE Computers, M scheme do visit Computers 5th Sem syllabus for M scheme.

Dont forget to download iStudy Syllabus App for latest syllabus and results, class timetable and more.