3139: Database Management System Lab KL Diploma Syllabus for Computer Engg 3rd Sem 2015 Revision SITTTR

Database Management System Lab detailed syllabus for Computer Engineering (Computer Engg) for 2015 revision curriculum has been taken from the SITTTRs official website and presented for the Computer Engg 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 Engineering 3rd Sem scheme and its subjects, do visit Computer Engg 3rd Sem 2015 revision scheme. The detailed syllabus of database management system lab is as follows.

Course General Outcomes:

1. Practice different DDL,DML and DCL commands
2. Practice queries
3. Define views
4. Create cursors and triggers
5. Apply connections from programming languages like JAVA and PHP
6. Implement various embedded languages
7. To Understand Normalisation and Transactions

Specific Outcomes:

1. Create one or two tables. Bring in all possible constraints like NOT NULL, DEFAULT, CHECK, PRIMARY KEY, UNIQUE etc.
2. Enter considerable number of tuples of all sorts to the tables.
3. Write various SELECT clauses to generate different types of listing of data.(Use WHERE, HAVING, DISTINCT, GROUP BY and ORDER BY clauses and subqueries)
4. Core Problem (Phase 1):
   1. Analyse a real problem situation/application and represent it using an ER-Diagram. Create tables as per ER Diagram and insert relevant data.
5. Create various views of the table.
6. Delete unwanted tuples from tables.
7. Modify the schema of one or more tables to incorporate a change.
8. Develop queries for inner and outer joins.
9. Create cursors and triggers for manipulating tables.
10. Write functions and/or procedure for various simple tasks.
11. Develop a simple application in Java/PHP to make a connection to the database and access the data.
12. Core Problem (Phase 2):
    1. Check whether the tables created are normalized.
    2. Develop functions/stored procedure for identified tasks.
    3. Develop the miniature form of application that connects to the database using JDBC/ODBC.
13. Design and develop a form to enter data into tables using JAVA/PHP.
14. Develop a Java/PHP program to access the table and generate a report.
15. Core Problem (Phase 3):
    1. Design and develop table data entry forms.
    2. Develop the final application from the miniature form.

Sample Core Problem: The diagram shown below represents the academic functioning of a college. There are five entities viz. Department, Faculty, Student, Course, and Hostel. All the five entities have their own attributes.DNumber, FacultyID, StudentID, CourseID, and HostelID are the key attributes of Department, Faculty, Student, Course and Hostel respectively. The entities are related to each other and the respective relationships are explained below: A college has many departments. A department would have students as well as faculty. The one to many relationship between department and students, and, department and faculty states that a department belongs to many students and it employs many faculty members. Looking at these relationships in a reverse direction conveys that a student as well as a faculty belongs to a single department and thus establishes one to one relationship. A student can register himself into various courses; similarly a course can be studied by many students. A student lives in a single hostel but a hostel accommodates many students. A department offers many courses but a particular course belongs to a particular department. A faculty teaches many courses but a particular course is taught by a single faculty only. Phase 1: Create five tables:

1. Department,
2. Faculty,
3. Student,
4. Course and
5. Hostel.

Include the necessary constraints. Insert at least 10 tuples to each table. Generate the following results:

1. List out the ID, Name and Date of Birth of students in the ascending order of Date of Birth
2. List out the ID, Name and Date of Birth of students registered for a specific course.
3. List out the ID, Name and Date of Birth of students registered for a specific course, staying in a specific Hostel.
4. Prepare department wise student list with ID, Name and Date of Birth of students and also find number of students in each department.

Phase 2: Modify the ‘Student’ table to add a new field ‘Grade’. List the names of faculties who teach for a specific course using sub-query. Phase 3: Create a cursor to modify the salary of ‘Professors’ belonging to all departments by 150%. Phase 4: Develop a JAVA/PHP application that allows addition, deletion and modification of all table data and generate reports.

For detailed syllabus of all other subjects of Computer Engineering, 2015 revision curriculum do visit Computer Engg 3rd 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.