{{{credits}}}
| L | T | P | C |
| 0 | 0 | 3 | 1.5 |
- To understand data definitions and data manipulation commands(K3)
- To learn about the use of nested and join queries(K3)
- To understand procedural extensions of databases(K3)
- To design a database schema for an application using Normalization(K3)
- To implement typical database applications using Front-end tools(K3)
- Data Definition Commands
- Creating tables with constraints, constraint voilations
- schema modifications
- Data Manipulation Commands
- Update operations
- Simple SQL queries
- Transaction Control statements - Savepoint and Rollback
- Complex SQL Queries
- Nested Queries
- Correlated Subqueries
- Joins and Outer Joins
- Aggregate functions
- Grouping and Ordering commands
- Views
- Database Programming: PL/SQL - Cursors
- Procedures and Functions
- Triggers
- Exception Handling
- Database design
- ER Model, ER-to-relational mapping
- Normalization
- Implement the database application using any Front-end
\hfill Total Periods: 45
After the completion of this course, students will be able to:
- Use data definitions and manipulation commands(K3)
- Write complex SQL Queries(K3)
- Implement Database programming using PL/SQL(K3)
- Design a database for real-time applications(K3)
- Implement and analyze the use of Tables, PL/SQL for a realistic database applications using a Front-end tool(K3)
Hardware:
- Server - 1 Nos
- Standalone Desktops - 38 Nos
Software:
- Database: Oracle 10g - 38 Clients with 1 Server Node
- Frontend - Netbeans / Java / JDBC
** CO PO MAPPING :noexport:
| PO1 | PO2 | PO3 | PO4 | PO5 | PO6 | PO7 | PO8 | PO9 | PO10 | PO11 | PO12 | PSO1 | PSO2 | PSO3 | ||
| K3 | K6 | K6 | K6 | K6 | - | - | - | - | - | - | - | K6 | K5 | K6 | ||
| CO1 | K3 | 3 | 2 | 2 | ||||||||||||
| CO2 | K3 | 3 | 2 | 2 | ||||||||||||
| CO3 | K3 | 3 | 2 | 2 | ||||||||||||
| CO4 | K3 | 3 | 2 | 2 | 2 | |||||||||||
| CO5 | K3 | 3 | 2 | 2 | 2 | |||||||||||
| Score | 15 | 10 | 2 | 2 | 10 | |||||||||||
| Course Mapping | 3 | 2 | 2 | 2 | 2 |