Database Design and Management in Healthcare

At the end of the course, students should be able to: 1. decribe key concepts of relational database management systems; 2. explain key management issues surrounding database technology and emerging business applications enabled by database technology; 3. interprete the importance of database design through Entity Relationship Diagrams and models (ERD); 4. design and understand queries using Structured Query Language (SQL); and 5. perform a real-world database design and implementation in Microsoft Access and MySQL.

The theory, design, development, and management of modern relational databases. Basic technical skills for the class covers database design and implementation: entity-relationship modeling, normalisation, structured query language, and database management. Rational Databases: Mapping conceptual schema to relational Schema; Database Query Languages (SQL) Concept of Functional dependencies & Multi-valued dependencies. Transaction processing; Distributed databases.