Database Lab 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 lab is as follows.
Course Objectives:
- Practice different DDL,DML and DCL commands
- Apply Database connectivity via programming languages like JAVA and PHP
- To Understand Database Design
Course Outcomes:
On completion of the course, the student will be able to:
- Prepare a database schema for a real world problem using standard approaches
- Construct queries using SQL for database creation, interaction, modification, and updation.
- Write procedures, functions, and control structures using PL/SQL
- Demonstrate database applications using front-end tools and back-end DBMS
Module 1:
- Analyse a real problem situation/application and represent it using an ER Diagram. Create tables as per ER Diagram and insert relevant data.
- Create various views of the table
- Delete unwanted tuples from tables. Modify the schema of one or more tables to incorporate a change
Module 2:
- Create one or two tables. Bring in all possible constraints like NOT NULL, DEFAULT, CHECK, PRIMARY KEY, UNIQUE etc.
- Write various SELECT clauses to generate different types of listing of data. (Use WHERE, HAVING, DISTINCT, GROUP BY and ORDER BY clauses and subqueries)
Module 3:
- Creation of Procedures, Triggers and Functions
- Implementation of various aggregate functions in SQL
- Implementation of various control structures like IF-THEN, IF-THEN-ELSE, IF-THEN-ELSIF, CASE, WHILE using PL/SQL
Module 4:
- Develop the miniature form of application that connects to the database using JDBC/ODBC
- Design and develop a form to enter data into tables using JAVA/PHP
- Develop a Java/PHP program to access the table and generate a report.
Note:
Experiments shall be conducted such that all COs are attained.
Minimum of 6 experiments (excluding open ended experiments/microprojects) shall be performed.
Compulsory for CIA
The CIA shall be arranged in third semester by the faculty in charge. The ESE need to be conducted at the end of the third semester.
Text Books:
- Elmasri R. and S. Navathe, Database Systems: Models, Languages, Design and Application Programming, Pearson Education, 2013
- Sliberschatz A., H. F. Korth and S. Sudarshan, Database System Concepts, 6/e, McGraw Hill, 2011.
Reference Books:
- Adam Fowler, NoSQL for Dummies, John Wiley & Sons, 2015
- NoSQL Data Models: Trends and Challenges (Computer Engineering: Databases and Big Data), Wiley, 2018
- Database Management System Oracle SQl and PL/SQL, Pranab Kumar das Gupta, PHI, 2009 Print
Online Resources
- http://www.sql-tutorial.net/
- https://www.w3schools.com/sql/
- https://sqlbolt.com/
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.