Advanced DBMS LAB

Paper Code: 
MCA 328
Credits: 
02
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

 The course will enable the students to

1            Observe that how the real world data is stored, retrieved, and communicate under the DBMS environment

2            Design a logical model which having the unique relation between the Data.

3            Apply the query for the modification of the system.

4            Develop a conceptual design which allows as to avoid anomalies in superior’s data.

5            Discuss a system which allows to restrict the uncontrolled exaction and provide rigorous variation of the task.

Course Learning Outcomes (CLOs):

            

Learning Outcome (at course level)

Students will be able to:

Learning and teaching strategies

Assessment Strategies

  1. Describe various data models and schemas used in database management systems.
  2. Explain the fundamental concepts, data definitions and query processing tasks in relational query languages.
  3. Recognize database design theory, and evaluate functional dependencies and normal forms in databases.
  4. Design and develop the programs in PL/SQL using Cursors, Triggers, Functions and Procedures.
  5. Develop realistic solutions for complex business problems.

 

Interactive Lectures,

Modeling, Discussions, Using research papers, student centered approach, Through Video Tutorials

 

Learning activities for the students:

Experiential Learning, Presentations, case based learning, Discussions, Quizzes and Assignments

  • Assignments
  • Assignments
  • Written test in classroom
  • Continues Assessment
  • Semester End Examination

 

 

 

 

 

CONTENTS

  1. SQL data types, Operators, Literals, Constraints
  2. DDL, DML, TCL, DCL Commands
  3. Queries: Select / From / Where/ Group By/Having Clause/ Order By Clause/ SQL Operators
  4. Functions: Aggregate / Numeric / String / Date & Time / Logical
  5. Joins: Equi-Join / Natural Join / Self Join / Inner Join / Outer Join
  6. Unions / Intersection / Minus
  7. Subqueries or Nested Queries
  8. PL/SQL Block Structure
  9. Conditional Statements
  10. Iterations
  11. Database Programming with record variables
  12. Cursors
  13. Procedures & Functions
  14. Triggers
  15. Packages

 

Academic Year: 
2019-20
  • Printer-friendly version