Database Management System in Healthcare detailed Syllabus for Medical Electronics (Med Elec), 2018 scheme has been taken from the VTUs official website and presented for the VTU students. For Course Code, Subject Names, Teaching Department, Paper Setting Board, Theory Lectures, Tutorial, Practical/Drawing, Duration in Hours, CIE Marks, Total Marks, Credits and other information, visit full semester subjects post given below. The Syllabus PDF files can also be downloaded from the official website of the university.
For all the other VTU Med Elec 7th Sem Syllabus for BE 2018 Scheme, visit Medical Electronics 7th Sem 2018 Scheme.
For all the (Professional Elective-2) subjects refer to Professional Elective-2 Scheme. The detail syllabus for database management system in healthcare is as follows.
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 Modeling using the Entity – Relationship (ER) Model: Using High – Level Conceptual Data Models for Database Design, An Example Database Application; Entity Types, Entity Sets, Attributes and Keys, Relationship 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. (Text Book2 : 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7 ) Relational Model: Relational Model Concepts, Relational Model Constraints and Relational Database Schemas, Update Operations, Transactions, and Dealing with Constraint Violations. (Text Book 2 : 5.1, 5.2, 5.3 ) Relational Algebra and Relational Calculus: Unary Relational Operations: SELECT and PROJECT. ( Text Book2 : 6.1 )
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
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
Overview Of Transaction Management: The ACID Properties, Transactions and Schedules, Concurrent Execution of Transactions, Lock-Based Concurrency Control, Performance of Locking, Transaction Support in SQL, Introduction to Crash Recovery. ( Text Book 1 : Chapter 16 ) Concurrency Control : 2PL, Serializability and Recoverability, Introduction to Lock Management, Lock Conversions, Dealing with Deadlocks, Specialized Locking Techniques, Concurrency Control without Locking.( Text Book 1 : Chapter 17 ) Crash Recovery : Introduction to ARIES, The Log, Other Recovery- Related Structures, The Write-Ahead Log Protocol, Check-pointing, Recovering from a System Crash, Media Recovery.( Text Book 1 : 18.1, 18.2, 18.3, 18.4, 18.5, 18.6, 18.7 )
Note: Assignment may be given on the topics on semantic web and natural language processing (NLP) for semantic web, software for the hospital database management.
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:
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..
Text Books:
- Database Management Systems – by Raghu Ramakrishna and Johannes Gehrke, (3rd Edition), McGraw Hill, 2003.
- Fundamentals of Database Systems – by RamezElmasri 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 the detail Syllabus of all other subjects of BE (Med Elec) 7th Sem, visit Medical Electronics 7th Sem Subjects.
For all (CBSE & Non-CBSC) BE/B.Tech results, visit VTU BE/B.Tech all semester results.