15CS33T: Database Management Systems Information Sci 3rd Sem Syllabus for Diploma DTE Karnataka C15 Scheme

Database Management Systems detail DTE Kar Diploma syllabus for Information Science And Engineering (IS), C15 scheme is extracted from DTE Karnataka official website and presented for diploma students. The course code (15CS33T), and for exam duration, Teaching Hr/week, Practical Hr/week, Total Marks, internal marks, theory marks, duration and credits do visit complete sem subjects post given below. The syllabus PDFs can be downloaded from official website.

For all other information sci 3rd sem syllabus for diploma c15 scheme dte karnataka you can visit Information Sci 3rd Sem Syllabus for Diploma C15 Scheme DTE Karnataka Subjects. The detail syllabus for database management systems is as follows.

Pre-requisites:

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 Outcomes:

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

UNIT I: Databases and Data Base Users 08 Hrs

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.

UNIT II: Data Modelling Using the Entity-Relationship(ER) Model 08 Hrs

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.

UNIT III: Relational Data Model and Relational Data Base Constraints 08 Hrs

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

UNIT IV: SQL: Schema Definition, constraints, queries and views 10 Hrs

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

UNIT V: Functional Dependencies and normalization for relational databases 08 Hrs

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.

UNIT VI: Fundamentals of Data Base Transaction Processing 10 Hrs

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

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

Reference Books:

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 coordinator 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.
1. Hospital Management
2. Hotel Management
3. 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

Model Question Paper:

(CIE)

1. Define the following. (5)
1. Data Model
2. Database Schema/Intension
3. Database State/Extension
4. Data Sublanguage
5. DML.
2. Define data independence and explain different types of it. (5)
3. Explain the different cardinality ratios for binary relationship types. (5)
4. Explain with suitable examples 1:1 and M:N relationship types. (5)

OR Develop an E-R diagram for a company database.

Model Question Paper:

PART-A

Answer any SIX questions. Each carries 5 marks. 5X6=30 Marks

1. What is database? List the important characteristics of database approach.
2. Explain with examples Entity Integrity Constraints and referential Integrity Constraint.
3. Explain the characteristics of Relations.
4. With examples write a note on CREATE and DROP command.
5. Differentiate Having and Where clause with example.
6. Explain the Boyce-Codd normal form with example.
7. Explain the generation of spurious tuples and how to overcome the same.
8. Discuss the advantages of NoSql versus RDBMS.
9. What is scaling. Explain the types of scaling.

PART-B

Answer any SEVEN full questions each carries 10 marks. 10X7=70 Marks

1. Discuss the advantages of DBMS Approach.
2. Define the following.
1. Data Model
2. Database Schema/Intension
3. Database State/Extension
4. Data Sublanguage.
5. DML.
3. With a neat diagram explain the different phases of database design.
4. Identify the entities, relationships and develop an E-R diagram for a company database.
5. Explain with example the different Constraints that are violated during UPDATE and DELETE operations
6. Consider the following schema & write the SQL queries.
1. SAILORS (sid, sname, rating, age)
2. BOATS (bid, bname, color)
3. RESERVES (sid, bid, day)
1. Retrieve names of sailors who reserved green boat.
2. Retrieve the colors of boats reserved by ‘ramesh’.
3. Retrieve the names of sailors who have reserved a red or a green boat.
4. Retrieve the sid of sailors with age over 20 who have not reserved a red boat.
5. Retrieve the names of sailors who have reserved all boats called ‘Interlake’.
7. List and explain the different data types used in SQL.
8. Discuss the informal design guidelines for relational schema.
9. Draw a state diagram and discuss the typical states during transaction execution.
10. Explain the need for concurrency control.

For detail syllabus of all other subjects of BE Information Sci, C15 scheme do visit Information Sci 3rd Sem syllabus for C15 scheme.

Dont forget to download iStudy Syllabus App for latest syllabus and results, class timetable and more.