CB3412 Database Management Systems and Security Laboratory Syllabus:

CB3412 Database Management Systems and Security Laboratory Syllabus – Anna University Regulation 2021

COURSE OBJECTIVES:

 To learn and implement important commands in SQL.
 To learn the usage of nested and joint queries.
 To understand functions, procedures and procedural extensions of databases.
 To understand attacks on databases and to learn to defend against the attacks on databases.
 To learn to store and retrieve encrypted data in databases

PRACTICAL EXERCISES:

1. Create a database table, add constraints (primary key, unique, check, Not null), insert rows, update and delete rows using SQL DDL and DML commands.
2. Create set of tables, add foreign key constraints and incorporate referential integrity.
3. Query the database tables using different ‘where’ clause conditions and also implement aggregate functions.
4. Query the database tables and explore sub queries and simple join operations.
5. Query the database tables and explore natural, equi and outer joins.
6. Write user defined functions and stored procedures in SQL.
7. Execute complex transactions and realize DCL and TCL commands.
8. Write SQL Triggers for insert, delete, and update operations in database table.
9. Use SQLi to authenticate as administrator, to get unauthorized access over sensitive data, to inject malicious statements into form field.
10. Write programs that will defend against the SQLi attacks given in the previous exercise.
11. Write queries to insert encrypted data into the database and to retrieve the data using decryption.

TOTAL: 60 PERIODS

COURSE OUTCOMES:

On completion of the course, the student will be able to:
CO1: Create databases with different types of key constraints.
CO2: Write simple and complex SQL queries using DML and DCL commands.
CO3: Realize database design using 3NF and BCNF.
CO4: Use advanced features such as stored procedures and triggers.
CO5: Secure databases and mitigate attacks on databases.