Database Management System detailed syllabus scheme for Electronics & Telecommunication Engineering (EC), 2018 regulation has been taken from the MU official website and presented for the Bachelor of Engineering students. For Course Code, Course Title, Test 1, Test 2, Avg, End Sem Exam, Team Work, Practical, Oral, Total, and other information, do visit full semester subjects post given below.
For 6th Sem Scheme of Electronics & Telecommunication Engineering (EC), 2018 Pattern, do visit EC 6th Sem Scheme, 2018 Pattern. For the Department Level Optional Course-2 scheme of 6th Sem 2018 regulation, refer to EC 6th Sem Department Level Optional Course-2 Scheme 2018 Pattern. The detail syllabus for database management system is as follows.
Database Management System Syllabus for Electronics & Telecommunication Engineering TE 6th Sem 2018 Pattern Mumbai University
Prerequisites:
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Course Objectives:
- Learn and practice data modeling using the entity-relationship and developing database designs.
- Understand the use of Structured Query Language (SQL) and learn SQL syntax.
- Understand the needs of database processing and learn techniques for controlling the consequences of concurrent data access
Course Outcomes:
After successful completion of the course student will be able to
- Understand the different issues involved in the design and implementation of a database system.
- Transform an information model into a relational database schema and to use a data definition language and/or utility to implement the schema using a DBMS.
- Demonstrate an understanding of normalization theory and apply such knowledge to the normalization of a database.
- Understand the concepts of constraints, views, concurrency control, deadlock
Module 1
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Module 2
Data Models 06
- The importance of data models, Basic building blocks, Business rules, Evolution of data models (hierarchical, Network, Relational, Entity relationship and object model), Degrees of data abstraction.
Module 3
Database Design, ER-Diagram and Unified Modeling Language 10
- Database design and ER Model: overview, ER-Model, Constraints, ER-Diagrams, ERD Issues, weak entity sets, Codds rules, Relational Schemas, Introduction to UML Relational database model: Logical view of data, keys, integrity rules. Relational Database design: features of good relational database design, atomic domain and Normalization (1NF, 2NF, 3NF, BCNF).
Module 4
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Module 5
Constraints, Views and SQL 10
- What is constraints, types of constrains, Integrity constraints, Views: Introduction to views, data independence, security, updates on views, comparison between tables and views SQL: data definition, aggregate function, Null Values, nested sub queries, Joined relations. Triggers.
Module 6
Transaction management and Concurrency control 10
- Transaction management: ACID properties, serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks), Time stamping methods, optimistic methods, database recovery management.
Text Books:
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Reference Books:
- Peter Rob and Carlos Coronel, Database Systems Design, Implementation and Management, Thomson Learning, 5th Edition.
- P.S. Deshpande, SQL and PL/SQL for Oracle 11g, Black Book, Dreamtech Press
- Mark L. Gillenson, Paulraj Ponniah, Introduction to Database Management, Wiley
- Raghu Ramkrishnan and Johannes Gehrke, Database Management Systems, TMH
- Debabrata Sahoo Database Management Systems Tata McGraw Hill, Schaums Outline
E-Resources:
- https://www.tutorialspoint.com/dbms/index.htm
- https://www.studytonight.com/dbms/
- https://beginnersbook.com/2015/04/dbms-tutorial/
- https://www.w3schools.in/dbms/
- https://www.tutorialcup.com/dbms
Internal Assessment:
Assessment consists of two class tests of 20 marks each. The first class test is to be conducted when approximately 40% syllabus is completed and second class test when additional 40% syllabus is completed. The average marks of both the test will be considered for final Internal Assessment. Duration of each test shall be of one hour.
End Semester Examination:
- Question paper will comprise of 6 questions, each carrying 20 marks.
- The students need to solve total 4 questions.
- Question No.1 will be compulsory and based on entire syllabus.
- Remaining question (Q.2 to Q.6) will be selected from all the modules.
For detail Syllabus of all subjects of Electronics & Telecommunication Engineering (EC) 6th Sem 2018 regulation, visit EC 6th Sem Subjects of 2018 Pattern.