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 | 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 |
Following exercises should also be given to them: SQl Queries with concepts of DDl, DML Commands Development of Data Base Applications (Application Domain):
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