Relational Database Management System Lab detailed syllabus for Computer Application & Business Management (CA&BM) for 2015 revision curriculum has been taken from the SITTTRs official website and presented for the CA&BM 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 Computer Application & Business Management 4th Sem scheme and its subjects, do visit CA&BM 4th Sem 2015 revision scheme. The detailed syllabus of relational database management system lab is as follows.
Course General Outcomes:
- To understand creating and altering tables
- To know about retrieval of information
- To understand queries
- To understand creating users and setting privileges
SPECIFIC OUTCOMES
LIST OF EXERCISES
- Exercises for Creating and Altering Tables
- Familiarise various data types and usages
- Exercises for creating tables with constraints NULL, DEFAULT, CHECK, PRIMARY KEY, UNIQUE, referential Integrity, creating indexes
- Exercises for retrieval of information using SELECT statements with WHERE, ORDER BY clause and deleting records
- Exercises for Inserting, Updating and Deleting Data.
- Exercises for retrieval of information with aggregate functions and group by, having clauses
- Exercises for nested queries, correlated sub queries
- Exercises for exists, unique, distinct, union functions
- Exercises for joining table with different joins
- Exercises for creating views
- Experiment using triggers
- Experiment using cursors
- Experiment using stored procedures and functions
- Familiarise Creating Users and Setting up Privileges
For detailed syllabus of all other subjects of Computer Application & Business Management, 2015 revision curriculum do visit CA&BM 4th Sem subject syllabuses for 2015 revision.
To see the syllabus of all other branches of diploma 2015 revision curriculum do visit all branches of SITTTR diploma 2015 revision.