DBMS Lab PCCSL408 2024 Scheme and Syllabus

 

DBMSLAB

(CommontoCS/CD/CR/CA/AD/AI/CB/CN/CC/CU/CI/CG)

 

CourseCode

PCCSL408

CIEMarks

50

Teaching Hours/Week (L: T:P: R)

0:0:3:0

ESEMarks

50

Credits

2

ExamHours

2Hrs.30Min.

Prerequisites(ifany)

None

Course Type

Lab

Course Objectives:

1.       To equip students with comprehensive skills in SQL,PL/SQL, and NoSQL databases.

 

2.       To enable the learner to proficiently design,implement,and manage relational and non- relational databases to meet diverse data management needs

 

Expt. No.

Experiments

1

Design a database schema for an application with ERdiagram from ap roblem description.

 

2

Creation of database schema-DDL(createtables,set constraints, enforce relationships,

create indices,delete and modify tables).Export ERdiagram from the database and verify relationships (with the ER diagram designed in step 1).

3

Database initialization-Data insert,Data import to a database(bulk import using UI and

SQLCommands).

4

Practice SQLcommands for DML(insertion,updating,altering,deletion of data,and

viewing/querying records based on condition in databases).

5

Implementation of various aggregate functions,OrderBy,GroupBy&Having clause in

SQL.

6

Implementation of set operators nested queries,and join queries.

7

Practice of SQL TCL DCLcommands like Rollback,Commit,Save point,Practice of SQL

DCL commands for granting and revoking user privileges.

8

Practice of SQLcommands for creation of views and assertions.

9

Creation of Procedures,Triggers and Functions.

10

Creation of Packages and cursors.

11

Design a database application using any front-end tool for any problem selected in

experiment number1.The application constructed should have five or more tables**.

12

Perform basicCRUD(Create,Read,Update,Delete)operations on a Cassandra table.

13

Write and execute CQLqueries to retrieve specific data from Cassandra tables

14

Create a simple application using Mongodb with python

**The problem must be designed to convey the difference of NoSQL from SQL databases.

Course Assessment Method(CIE: 50 marks, ESE: 50 marks)

 

Continuous Internal Evaluation Marks(CIE):

 

 

Attendance

Preparation/Pre-Lab Work experiments,

Viva and Timely completionofLabReports/Record

(ContinuousAssessment)

 

Internal Examination

 

Total

5

25

20

50

 

End Semester Examination Marks(ESE):

 

Procedure/ Preparatory work/Design/

Algorithm

Conduct of experiment/ Execution of work/ troubleshooting/

Programming

Result with valid inference/ Quality of

Output

 

Viva voce

 

Record

 

Total

10

15

10

10

5

50

 

● Submission of Record:Students shall be allowed for the end semester examination only upon submitting the duly certified record.

● Endorsement by External Examiner:The external examiner shall endorse the record

Course Outcomes(COs)

At the end of the course students should be able to:

 

Course Outcome

Bloom’s Knowledge Level (KL)

CO1

Develop database  schema for a given real world problem-domain using

standard design and modeling approaches

K3

CO2

Construct queries using SQL for database creation,interaction,modification,

and updation.

K3

CO3

Plan and implement triggers and cursors,procedures,functions,and control

structures using PL/SQL

K3

CO4

Perform CRUD operationsin NoSQL Databases

K3

CO5

Design data base pplications using front-end tools and back-end DBMS

K5

Note:K1-Remember,K2-Understand,K3-Apply,K4-Analyse,K5-Evaluate,K6-Create

CO-PO Mapping(Mapping of Course Outcomes with Program Outcomes)

 

 

PO1

PO2

PO3

PO4

PO5

PO6

PO7

PO8

PO9

PO10

PO11

PO12

CO1

3

3

3

1

 

 

 

 

 

3

 

3

CO2

3

3

3

1

 

 

 

 

 

3

 

3

CO3

3

3

3

1

 

 

 

 

 

3

 

3

CO4

3

3

3

2

3

 

 

 

 

3

 

3

CO5

3

3

3

2

3

 

 

 

 

3

3

3

1:Slight(Low),2:Moderate(Medium),3:Substantial(High),-:NoCorrelation

 

Text Books

Sl. No

TitleoftheBook

Name of the Author/s

Name of the Publisher

Edition and Year

1

Fundamentals of DatabaseSystems

Elmasri,Navathe

Pearson

7/e,2017

2

Professional NoSQL

ShashankTiwari

Wiley

1/e,2011

 

 

ReferenceBooks

Sl.

No

Title of the Book

Name of the Author/s

Nameofthe

Publisher

Edition

andYear

1

Database System Concepts,

SliberschatzKorthandS.

Sudarshan

McGrawHill,

7/e,2017

2

NoSQL for Dummies

AdamFowler

JohnWiley&

Sons

1/e,2015

 

3

NoSQL DataModels:Trends and Challenges(ComputerEngineering:

Databases and BigData),

 

OlivierPivert

 

Wiley

 

1/e,2018

 

4

Making the Sense of NoSQL : A guide for Managers and Restof us.

DanMcCrearyandAnn Kelly

Manning

1/e,2014

 

 

VideoLinks(NPTEL,SWAYAM…)

Module No.

LinkID

1

https://onlinecourses.nptel.ac.in/noc21_cs04/preview

2

https://onlinecourses.nptel.ac.in/noc21_cs04/preview

3

https://onlinecourses.nptel.ac.in/noc21_cs04/preview

4

https://archive.nptel.ac.in/courses/106/104/106104135/


Continuous Assessment (25 Marks)

1. Preparation and Pre-Lab Work (7 Marks)

  • Pre-Lab Assignments: Assessment of pre-lab assignments or quizzes that test understanding of the upcoming experiment.

  • Understanding of Theory: Evaluation based on students’ preparation and understanding of the theoretical background related to the experiments.

2. Conduct of Experiments (7 Marks)

  • Procedure and Execution: Adherence to correct procedures, accurate execution of experiments, and following safety protocols.

  • Skill Proficiency: Proficiency in handling equipment, accuracy in observations, and troubleshooting skills during the experiments.

  • Teamwork: Collaboration and participation in group experiments.

3. Lab Reports and Record Keeping (6 Marks)

  • Quality of Reports: Clarity, completeness, and accuracy of lab reports. Proper documentation of experiments, data analysis, and conclusions.

  • Timely Submission: Adhering to deadlines for submitting lab reports or rough records and maintaining a well-organized fair record.

4. Viva Voce (5 Marks)

  • Oral Examination: Ability to explain the experiment, results, and underlying principles during a viva voce session.

Final Marks Averaging

The final marks for preparation, conduct of experiments, viva, and record are the average of all the specified experiments in the syllabus.

Evaluation Pattern for End Semester Examination (50 Marks)

1. Procedure / Preliminary Work / Design / Algorithm (10 Marks)

  • Procedure Understanding and Description: Clarity in explaining the procedure and understanding each step involved.

  • Preliminary Work and Planning: Thoroughness in planning and organizing materials/equipment.

  • Algorithm Development: Correctness and efficiency of the algorithm related to the experiment.

  • Creativity and Logic: Creativity and logical flow in algorithm or experimental design.

2. Conduct of Experiment / Execution of Work / Programming (15 Marks)

  • Setup and Execution: Proper setup and accurate execution of the experiment or programming task.

3. Result with Valid Inference / Quality of Output (10 Marks)

  • Accuracy of Results: Precision and correctness of the obtained results.

  • Analysis and Interpretation: Validity of inferences drawn from the experiment or quality of program output.

4. Viva Voce (10 Marks)

  • Explanation Skills: Ability to explain the experiment, procedure, and results, and to answer related questions.

  • Conceptual Understanding: Proficiency in answering questions related to theoretical and practical aspects of the subject.

5. Record (5 Marks)

  • Completeness and Clarity: Completeness, clarity, and accuracy of the lab record submitted.

Comments

Post a Comment

Popular posts from this blog

Database Management Systems DBMS Lab PCCSL408 Semester 4 KTU CS 2024 Scheme

 About Me Scheme and Syllabus Experiments Introduction to RDBMS Working with MySQL Design a Database schema for an application ER Diagrams - MySQL Workbench Introduction to SQL Data Types in MySQL Built-in Functions-MySQL Aggregate Functions Enforcing Rules using Constraints MySQL Lab Exercise Importing Data from a csv file into MySQL Order by, group by and having clause MySQL Lab Exercise Set Operations Nested Queries Subqueries in FROM and SELECT clause Join Queries Example Join Queries Temporary and Intermediate Tables in SQL MySQL Lab Exercise - Handling Multiple Tables SQL TCL commands - COMMIT, ROLLBACK , SAVEPOINT SQL DCL Commands - GRANT, REVOKE Views Assertions Stored Procedures in MySQL Triggers in MySQL Functions in MySQL Cursors in MySQL Build a web application based on sample database - use Php-MySQL SQL Vs NoSQL Cassandra official site Apache Cassandra- Introduction and Basic CQL commands Cassandra- advanced CURD operations Work with MongoDB atlas for free MongoDB and...
Read more

Design a Database Schema for an Application Using ER Diagram from Problem Description

  Design a Database Schema for an Application Using ER Diagram from Problem Description 1. Aim To analyze a problem description, identify entities and relationships, draw the Entity–Relationship (ER) diagram, and convert it into a relational database schema with appropriate constraints. 2. Theory 2.1 ER Model The Entity–Relationship (ER) model is a conceptual data modeling technique used to represent real-world objects (entities) and the relationships among them. It provides a high-level view of a system and is typically the first step in database design. 2.2 Key Components Entity: A real-world object that is distinguishable from other objects. Examples: Student, Course, Employee. Attributes: Properties that describe an entity. Examples: StudentID, Name, DOB. Relationship: Describes how two or more entities interact. Examples: A Student enrolls in a Course. Cardinality Constraints: Define the number of instances participating in a relationship. One...
Read more