Database Management System in Healthcare detail syllabus for Medical Electronics (Med Elec), 2017 scheme is taken from VTU official website and presented for VTU students. The course code (17ML741), 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.
For all other med elec 7th sem syllabus for be 2017 scheme vtu you can visit Med Elec 7th Sem syllabus for BE 2017 Scheme VTU Subjects. For all other Professional Elective-III subjects do refer to Professional Elective-III. The detail syllabus for database management system in healthcare is as follows.
Module 1
Database and Database Users: Introduction, Characteristics of the Database Approach, Advantages of Using the DBMS Approach. ( Text Book 2 : 1.1, 1.3, 1.6 ) Database System Concepts and Architecture: Data models, Schemas, and Instances, Three -Schema Architecture and Data Independence, Database Languages and Interfaces, Classification of Database Management Systems. ( Text Book 2 : 2.1, 2.2, 2.3, 2.6 ) Patient Database: Patient Database strategies for HIS, data acquisition, patient admission, transfer, discharge, evaluation & management. Computer based patient record, clinical decision support systems. ( Text Book 3 ) Overview of Database Systems: A Historical Perspective, File Systems versus a DBMS, Describing and Storing Data in a DBMS, Queries in a DBMS, Transaction Management, Structure of a DBMS.( Text Book 1 : 1.2, 1.3, 1.5, 1.6, 1.7, 1.8 .
Module 2
For complete syllabus and results, class timetable and more pls download iStudy. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.
Module 3
Relational Algebra and Relational Calculus: Relational Algebra Operations from Set Theory, Binary Relational Operations: JOIN and DIVISION, Additional Relational Operations. (Text Book2 : 6.2, 6.3, 6.4 ) SQL – 99: SQL Data Definition and Data Types, Specifying Constraints in SQL, Schema Change Statements in SQL, Basic Queries in SQL, More Complex SQL Queries, INSERT, DELETE and UPDATE Statements in SQL, Specifying Constraints as Assertions and Triggers, Views (Virtual Tables ) in SQL , Additional Features of SQL. (Text Book2 : 8.1, 8.2, 8.3, 8.4, 8.5, 8.6, 8.7, 8.8, 8.9 .
Module 4
Database Design Theory and Methodology: Informal Design Guidelines for Relation Schemas, Functional Dependencies, Normal Forms Based on Primary Keys, General Definitions of Second and Third Normal Forms, Boyce-Codd Normal Form. (Text Book2 : 10.1, 10.2, 10.3, 10.4, 10.5 ) Relational Database Design Algorithms and Further Dependencies: Properties of Relational Decompositions, Algorithms for Relational Database Schema Design, Multivalued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form, Inclusion Dependencies, Other Dependencies and Normal Forms. (Text Book2 : 11.1, 11.2, 11.3, 11.4, 11.5, 11.6 .
Module 5
For complete syllabus and results, class timetable and more pls download iStudy. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.
Course Outcomes:
After studying this course, students will be able to:
- Describe the basic concepts of DBMS, languages, and DBMS architecture.
- Describe the concept of ER model and Relational Model.
- Apply the Relational operations and Structured Query Languages for RDBMS.
- Analyze the data model based on normalization theory.
- Discuss database transactions management and data recovery from system crash.
Question paper pattern:
- The question paper will have TEN questions.
- Each full question consists of 16 marks.
- There will be 2 full questions (with maximum of THREE sub questions) from each module.
- Each full question will have sub questions covering all the topics under a module.
- The students will have to answer 5 full questions, selecting one full question from each module.
Text Books:
- Database Management Systems – by Raghu Ramakrishna and Johannes Gehrke, (3rd Edition), McGraw Hill, 2003.
- Fundamentals of Database Systems – by Ramez Elmasri and Shamkant B.Navathe (5thEdition), Pearson Education, 2007.
- The Biomedical Engineering Handbook-Volume II (2nd Edition) – by Joseph D. Bronzino, CRC/IEEE Press, 2000.
Reference Books:
- Data base System Concepts – by Silberschatz, Korth and Sudharshan. (4th Edition), McGraw Hill, 2002.
For detail syllabus of all other subjects of BE Med Elec, 2017 regulation do visit Med Elec 7th Sem syllabus for 2017 Regulation.
Dont forget to download iStudy for latest syllabus and results, class timetable and more.