Database Management System Lab detailed syllabus scheme for Instrumentation Engineering (IS), 2018 regulation has been taken from the MU official website and presented for the Bachelor of Engineering students. For Course Code, Course Title, Test 1, Test 2, Avg, End Sem Exam, Team Work, Practical, Oral, Total, and other information, do visit full semester subjects post given below.
For 5th Sem Scheme of Instrumentation Engineering (IS), 2018 Pattern, do visit IS 5th Sem Scheme, 2018 Pattern. For the Department Level Optional Course Lab-1 scheme of 5th Sem 2018 regulation, refer to IS 5th Sem Department Level Optional Course Lab-1 Scheme 2018 Pattern. The detail syllabus for database management system lab is as follows.
Database Management System Lab Syllabus for Instrumentation Engineering TE 5th Sem 2018 Pattern Mumbai University
Course Objectives:
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Course Outcomes:
The student will be able to:
- To model or design ER diagram based on the given schema or case study.
- Use SQL- the standard language of relational databases.
- Use a desktop database package to create, populate, maintain, and query a database.
- Apply the concept of integrity and Security in Database:
- Apply the concepts of Transaction Management and Concurrency.
Suggested List of Programming Assignments/Laboratory Work:
- Experiment to study different phases of database design. Design ER and EER diagram for company database and convert it into relational model (Schema). CO1
- Experiment to study DDL statements and Integrity constraint CO2
- Experiment to study DML commands. CO2
- Experiment to study Simple queries and Nested Queries. CO2,CO3
- Experiment to study complex and Co-related queries CO2,CO3
- Experiment to study different types of Joins. CO2,CO3
- Experiment to study View. CO2,CO3
- Execution of procedure and functions by using SQL Server CO3
- Execution of different types of triggers. CO4
- Experiment to study TCL and DCL commands. CO5
- Designing a database application using the overall database design process and implement queries, views, triggers, procedures and functions for the same. CO1,CO2, CO3
Any other additional experiments/assignments based on syllabus which will help students to understand topic/concept. Oral Examination: Oral examination will be based on entire syllabus. Term Work Term work shall consist of minimum 10 experiments. The distribution of marks for term work shall be as follows: Laboratory work (Experiments. : 10 Marks Laboratory work (programs / journal. : 10 Marks Attendance : 5 Marks The final certification and acceptance of term work ensures the satisfactory performance of laboratory work and minimum passing in the term work.
For detail Syllabus of all subjects of Instrumentation Engineering (IS) 5th Sem 2018 regulation, visit IS 5th Sem Subjects of 2018 Pattern.