DBMS-II LAB

Paper Code: 
CBCA 502
Credits: 
3
Periods/week: 
6
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 (COs):

Course Outcome (at course level)

Learning and teaching strategies

Assessment Strategies

The students will:

Interactive Lectures,   Discussion,

Tutorials,   Reading   assignments,

Demonstrations, G-suite.

Class test, Semester

end examinations,

Quiz, Solving problems in tutorials,

Assignments,

Presentation,

Individual and group

projects and peer

review.

CO203. Implement    data   definition and manipulation statements in MySQL.

CO204. Create      and      manipulate database     using     advanced functions.

CO205. Implement           constraints, subqueries    and    joins     in databases

CO206. Demonstrate            database connectivity through MySQL to Java

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

 

Following exercises should also be given to them:

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=
Academic Year: 
2023-24
  • Printer-friendly version