DBMS-II LAB

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

Course Objectives:

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

25CBCA406

 

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

 

Unit I: 

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+processin g&ud=any&ft=all&lang=**&sort=

4. https://www.slideshare.net/search/slideshow?                                                               searchfrom=header&q=database+recovery&u d=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/slidesho                                                  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: