313302-Database Management System 030724
313302-Database Management System 030724
313302-Database Management System 030724
I. RATIONALE
This course focuses on fundamentals of relational database management system and enables students to design and
manage database for various software applications. It also provides students with theoretical knowledge and
practical skills in the use of databases and database management systems in Information Technology applications.
1. FA-TH represents average of two class tests of 30 marks each conducted during the semester.
2. If candidate is not securing minimum passing marks in FA-PR of any course then the candidate shall be
declared as "Detained" in that semester.
3. If candidate is not securing minimum passing marks in SLA of any course then the candidate shall be
declared as fail and will have to repeat and resubmit SLA work.
4. Notional Learning hours for the semester are (CL+LL+TL+SL)hrs.* 15 Weeks
5. 1 credit is equivalent to 30 Notional hrs.
6. * Self learning hours shall not be reflected in the Time Table.
7. * Self learning includes micro project / assignment / other activities.
LLO 3.1 Execute DDL Commands to 1 )Create, alter, truncate, drop ,rename
3 2 CO3
manage database using SQL table
Self Learning
Assignment
Micro project
Develop a database for restaurant management system. The restaurant maintain catalogue for the list of food items
and generate bill for the ordered food.
Prepare Invoice management system for electricity bill generation. Accept meter reading as inputs and generate
respective bill amount for the same.
Design a database for registration and admission of patient for Hospital management system, draw ER diagram
and normalize the database up to 3NF.
Any topic suggested by teacher.
Note :
Above is just a suggestive list of microprojects and assignments; faculty must prepare their own bank of
microprojects, assignments, and activities in a similar way.
The faculty must allocate judicial mix of tasks, considering the weaknesses and / strengths of the student in
acquiring the desired skills.
If a microproject is assigned, it is expected to be completed as a group activity.
SLA marks shall be awarded as per the continuous assessment record.
If the course does not have associated SLA component, above suggestive listings is applicable to Tutorials
and maybe considered for FA-PR evaluations.
X. ASSESSMENT METHODOLOGIES/TOOLS
Teachers are requested to check the creative common license status/financial implications of the suggested
online educational resources before use by the students
https://services.msbte.ac.in/scheme_digi/pdfdownload/download/ 8/8