DBMS
DBMS
DBMS
Learning Outcome Build Data Base and Tables with the help of DDL.
9 10
1
Introduction to my SQL language, Structure of my SQL statements & my SQL
writing guidelines, Data Definition commands: Creating a Database, Show,
Contents Creating a Table ,Use, Altering the Database, Altering the Table, RENAME,
DESCRIBE, Dropping the Database, Dropping the Table, TRUNCATE.
SCHEME OF ASSESSMENT
S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal
CO Description Understand the Basic concepts and need of Database Management systems including Query Language and Data Model.
LO Description Classify Data Model and give Example of Entity Relation Data Model.
SCHEME OF STUDY
Teaching -Learning Description of T-L Teach Pract. /Tut
S. No. Learning Content LRs Required Remarks
Method Process Hrs. Hrs.
Introduction and Classification of Traditional Lecture Teacher will explain 08 00 Handouts /Videos + NIL
Data Model, Comparison between method + Handout + the contents and ppt / Books / E-
the three types of models, ER data Videos provide handout to Contents
model: Entitles and attributes, students.
Entity types, Relationship among Teacher will conduct
1 quiz to make students
entities, representation of
association & relationship, Defining practice their
the E-R diagram, Concept of knowledge.
Generalization, Aggregation and
Specialization, keys.
SCHEME OF ASSESSMENT
SCHEME OF ASSESSMENT
SCHEME OF ASSESSMENT
S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal
S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal
SCHEME OF ASSESSMENT
S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal
SCHEME OF ASSESSMENT
S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal
SCHEME OF ASSESSMENT
S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal
SCHEME OF ASSESSMENT
SCHEME OF ASSESSMENT
S. No. Method of Assessment Description of Assessment Maximum Marks Resources Required External /
Internal
CO-2 Design Data Base with the help of various Relational algebra
Operations and Normal Forms
LO-1 Build Data Base and Tables with the help of DDL.
LO-2 Modify Data Base and Tables with the help of DML.
End Sem
Term Work Lab Practical
Progressive exam Total
(Internal) work(Internal) (External)
(External)
CO1 10 30 40
CO2 10 30 40
CO3 10 30 40
CO4 10 10 10 30
Total 20 10 20 30 70 150