DBMS-II LAB

Paper Code: 
24CBCA406
Credits: 
02
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

The course will enable the students to

  1. Design rich databases through MySQL for various applications.
  2. Database connectivity for interactive database operations.

 

Course Outcomes: 

Course

Learning Outcome

(at course  level)

Learning and teaching strategies

Assessment Strategies

Course

 Code

Course

Title

24CBCA

406

DBMS –II    LAB (Practical)

CO229. Implement  data definition and manipulation statements in MySQL.

CO230. Create         and manipulate database using advanced functions.

CO231. Implement constraints, subqueries and joins in databases

CO232. Demonstrate Database connectivity through MySQL to Java.

CO233. Design        and develop a relational database for various application domains.

CO234.Contribute effectively in course-  specific interaction.

Approach in teaching: 

Interactive Lectures,

Discussion,

Demonstration,

 

Learning activities for the students: 

Self-learning assignments, Practical questions

Class test, Semester end examinations, Quiz, Presentation,

Individual and group

Assignments, viva-voce

 

 

Following exercises should also be given to them:

SQl Queries with concepts of DDl, DML Commands

Development of Data Base Applications (Application Domain):

  • Student database for school.
  • Employee database for a company.
  • Library Database for Library.
  • Railway Reservation System.
  • Hotel Reservation.
  • Inventory Control System.

 

REFERENCES: 

e -RESOURCES:

1.  https://www.w3schools.com/mysql/mysql_sql.asp

2.  https://www.slideshare.net/search/slideshow?searchfrom=header&q=mysql

3.  https://www.slideshare.net/search/slideshow?searchfrom=header&q=transaction+processing&ud=any&ft=all&lang=**&sort=

4.  https://www.slideshare.net/search/slideshow?searchfrom=header&q=database+recovery&ud=any&ft=all&lang=**&sort=

5.  https://www.slideshare.net/search/slideshow?searchfrom=header&q=rdbms&ud=any&ft=all&lang=**&sort=

6.  https://www.slideshare.net/search/slideshow?searchfrom=header&q=relational+database+management+systems&ud=any&ft=all&lang=**&sort=

JOURNALS:

1.      https://www.elsevier.com/books/transaction-processing/gray/978-0-08-051955-5

2.  https://www.elsevier.com/books/principles-of-transaction-processing/bernstein/978-1-55860-623-4

3.  https://www.elsevier.com/books/sql-clearly-explained/harrington/978-1-55860-876-4

4.  https://www.elsevier.com/books/concurrency-control-in-distributed-database-systems/cellary/978-0-444-70409-2

5.  https://www.elsevier.com/books/principles-of-transaction-processing/bernstein/978-1-55860-623-4

6.  https://www.elsevier.com/books/relational-database-design-and-implementation/harrington/978-0-12-804399-8

7.  https://www.elsevier.com/books/database/oneil/978-1-4831-8404-3

         https://www.elsevier.com/books/database-management-systems/gorman/978-             0-7506-0135-  1

Academic Year: 
2024-25
  • Printer-friendly version