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