DATABASE MANAGEMENT (3341605)  

7
Credit
3 + 0 + 4
Lect + Tuto + Pract
Teaching Scheme
70 + 30 + 0
ESE + PA + ALA
Theory Marks
40 + 0 + 60
ESE + OEP + PA
Practical Marks
ESE - End Semester Examination, PA - Progress Assessment, ALA - Active Learning Assignments, OEP -Open Ended Problem


Rationale
Data management course prepares student to design data base using various models, sql commands, techniques and operation which are introduced in this course. This creates strong foundation for application of data design. Student will be able to learn basic need of database in industry, the various noramalization concepts and queries performance.
Course Outcome
The theory should be taught and practical should be carried out in such a manner that students are able to acquire different learning out comes in cognitive, psychomotor and affective domain to demonstrate following course outcomes.
i. Explain Database concept and its utilities.
ii. Uses of Structure Query Language(SQL) commands.
iii. Perform Query operations.

Active Learning
i. Ms-Access Tutorial : http://www.quackit.com/microsoft_access/tutorial/
ii. SQL Basic Concepts: http://www.w3schools.com/sql/
iii. SQL Tutorial : http://beginner-sql-tutorial.com/sql.htm
iv. DBMS:http://nptel.iitm.ac.in/video.php?subjectId=106106093