Database Management Systems COMPUTER SCIENCE 3RD SEMESTER SYLLABUS

Database Management Systems  COMPUTER SCIENCE 3RD SEMESTER SYLLABUS


Government of Karnataka Department of Technical Education Bengaluru

 


Course Title:     Database Management Systems

Scheme (L:T:P) : 4:0:0

Total Contact Hours: 52

Course Code:

15CS33T

Type of Course: Lectures, Self Study & Student Activity

Credit :04

Core/ Elective:

Core

CIE- 25 Marks                                                                                                       SEE- 100 Marks


 Prerequisites
Knowledge of programming language.

 Course Objectives

1. Understand database concepts, applications, data models, schemas and instances.
2. Implement the relational database design and data modelling using entity-relationship (ER) model.
3. Demonstrate the use of constraints and relational algebra operations.
4. Use of SQL in querying the database
5. Demonstrate Normalization process.
6. Learn the new emerging Technologies and Applications in database.

 Course Outcome

On successful completion of the course, the students will be able to attain below Course Outcome (CO):

Course outcome

CL

Linked PO

Teaching Hours

CO1

Identify the characteristics of database and

describe the architecture and languages of Database system.

R, U

 

1,2,5,6,7,8,9,10

 

08

CO2

Identify the elements used in Entity-

Relationship diagram and sketch a simple diagram.

U, A

 

1,2,3,4,5,6,7,8,9,10

 

08

CO3

Summarize relational model concept and illustrate the relational constraints.

U, A

 

1,2,3,4,5,6,7,8,9,10

 

08

CO4

Describe                  Structured                  Query                  Language (SQL) and apply to query a database.

A

1,2,3,4,5,6,7,8,9,10

10

CO5

Recognize and interpret normalization for relational databases.

U, A

1,2,3,4,5,6,7,8,9,10

08

CO6

Visualize the features of NOSql and identify the database applications.

A

1,2,3,4,5,6,7,8,9,10

10

 

Total sessions

52

Legends: R = Remember U= Understand; A= Apply and above levels (Bloom’s revised taxonomy)
 
 Course-PO Attainment Matrix

Course

Programme Outcomes

1

2

3

4

5

6

7

8

9

10

Computer Organisation

3

3

3

3

3

3

3

3

3

3


Level 3- Highly Addressed, Level 2-Moderately Addressed, Level 1-Low Addressed.
Method is to relate the level of PO with the number of hours devoted to the COs which address the given PO. If >40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 3
If 25 to 40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 2 If 5 to 25% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 1
If < 5% of classroom sessions addressing a particular PO, it is considered that PO is considered not-addressed.


Course Content and Blue Print of Marks for SEE

Unit No

 

Unit Name

Hour

Questions to be set for SEE

Marks Weightage

Marks Weightage (%)

 

R

U

A

A

 

I

Identify the characteristics of database and describe the architecture and languages of

Database system.

 

08

10

12

-

22

15.38

II

Identify the elements used in Entity-Relationship diagram and

sketch a simple diagram.

 

08

6

10

6

22

15.38

III

Summarize      relational                  model concept                  and      illustrate                   the

relational constraints.

 

08

5

10

7

22

15.38

IV

Describe       Structured                     Query

Language (SQL) and apply to query a database.

 

10

-

5

25

30

19.24

V

Recognize         and                                  interpret normalization      for                          relational

databases.

 

08

-

24

-

24

15.38

VI

Visualize the features of NOSql and            identify            the              database

applications.

10

-

15

10

25

19.24

 

Total

52

21

76

48

145

100




Introduction, An Example, Characteristics of the database approach, Actors on the scene, Workers behind the scene, Advantages of using the DBMS Approach, A Brief History of Database Applications, When Not to use a DBMS
Database System Concepts and Architecture - Data Models, Schemas, and Instances, Three-Schema Architecture and Data Independence, Database Languages and Interfaces, The Database System Environment, Centralized and Client /Server Architectures for DBMSs, Classification of database Management System.

 
Using High-Level Conceptual Data Models for Database Design, An example Database Application, Entity Types, Entity Sets, attributes and keys, Relation Types, Relationship  Sets, roles and structural constraints, Weak Entity Types, Refining the ER Design for the Company Database, ER Diagrams, naming, conventions and design issues, Relationship Types of Degree Higher Than Two.

Relational Model concepts, Relational Model Constraints and relational database schemas, Update Operation, Transaction and Dealing with constraints violations.


SQL Data Definition and data types, Specifying constraints in SQL, Schema Change statement in SQL, Basic queries in SQL, More Complex SQL queries, INSERT, DELETE and UPDATE statements in SQL, Specifying constraints and Assertions and Triggers, Views(Virtual Tables) in SQL


Informal Design guidelines for relation schemas, Functional dependencies, Normal forms based on primary keys, General Definition of second and third normal forms, Boyce-codd Normal form.

Introduction to transaction processing, transaction and system concepts, desirable properties of transactions.
NoSQL – Introduction, Distributed Systems, Advantages & Disadvantages of Distributed Computing, Scalability, What is NoSQL? Why NoSQL? RDBMS vs. NoSQL, Brief history of NoSQL, CAP theorem (Brewer’s Theorem), NoSQL pros/cons, NoSQL Categories, Production deployment.
 Text books
1. Fundamentals of Database Systems, Sixth edition, 2014, Ramez Elmasri, Shamkan B. Navathe, Pearson Education, ISBN- 9788131792476
2. http://www.w3resource.com/mongodb/nosql.php --for NoSQL - UNIT VI

 References
1. Fundamentals of Database Management Systems, Mark L. Gillenson, 2009, Wiley India
2. Database Management Systems – Raghu Ramakrishnan and Johannes Gehrke – 3rd Edition, McGraw-Hill, 2003
3. DBMS a practical approach , by E R Rajiv Chopra, S Chand publications.
4. http://elearning.vtu.ac.in/10CS54.html
5. http://www.tutorialspoint.com/dbms/
6. http://www.indiabix.com/technical/dbms-basics/
7. http://beginner-sql-tutorial.com/sql.htm
 Suggested list of student activities

Note: The following activities or similar activities for assessing CIE (IA) for 5 marks (Any one) Student activity like mini-project, surveys, quizzes, etc. should be done in group of 3-5 students.
 
1. Each group should do any one of the following type activity or any other similar activity related to the course and before conduction, get it approved from concerned course co- ordinator and programme co-ordinator
2. Each group should conduct different activity and no repeating should occur.

1

Identify and do a case study on relationship types of degree higher than two in ER

data modelling

2

Design E-R diagrams for the following databases with all constraints specifications.

a) Hospital Management b) Hotel Management c) Student Database

3

Conduct a survey on various applications of database and submit a report of 3 to 4

pages.

4

Conduct a case study on any one Online Transaction Processing System (OLTP) and submit a report of 3 to 4 pages. Ex: Online Banking , Online Reservation (Bus,

Train, Airlines)


 Course Delivery
The course will be delivered through Lectures and Power point presentations/ Video
 Course Assessment and Evaluation Scheme

Method

What

To who

m

When/Where (Frequency in

the course)

Max Marks

Evidence collected

Course outcomes

Direct Assessment

CIE

IA

Students

Three IA tests (Average of three tests will

be computed)

 

20

 

Blue books

1 to 6

Student

activities

05

Report

1 to 6

Total

25

 

 

SEE

End

Exam

End of the

course

100

Answer scripts

at BTE

1 to 6

Indirect Assessment

Student Feedback

Students

Middle of the

 

Feedback forms

1,2,3 Delivery of

on course

course

course

End of Course Survey

End of the course

 

 

Questionnaires

1 to 6 Effectiveness of Delivery of

instructions &

 

 

 

Assessment Methods

Note: I.A. test shall be conducted for 20 marks. Average marks of three tests shall be rounded off

to the next higher digit.

Questions for CIE and SEE will be designed to evaluate the various educational components (Bloom’s taxonomy) such as:

Sl. No

Bloom’s Category

%

1

Remembrance

15

2

Understanding

50

3

Application

35


Popular Posts