Department Events
DBMS-II LAB
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.
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=
