CIS 317-DL Database Systems Design & Implementation
Course Description
|
This course covers the fundamentals of database design and management. Topics include the principles and methodologies of database design, database application development, normalization, referential integrity, security, relational database models, and database languages. Principles are applied by performing written assignments and a project using an SQL database system.
|
Instructor: Faisal Akkawi, Ph.d
|
![]()
|
Course Artifact
![]()
|
Learning Goals:
|
• Understand the fundamentals of database management and data organization
• Design and implement database application • Managing the large bodies of data • Understand how the data are actually organized in the abstract data structures • Understand relational languages and how they are used to provide the interface for DBMS |
Text
|
Database Systems: A Practical Approach to Design, Implementation and Management (5th Edition) 5th (fifth) Edition by Connolly, Thomas M., Begg, Carolyn E. published by Addison-Wesley (2009)
|
This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases—conceptual, logical, and physical database design.
|
My take away from this course:
A database is a collection of related data, which are organized so that useful information may be extracted. The effectiveness of databases derives from the fact that from one single, comprehensive database much of the information relevant to a variety of organizational purposes may be obtained. In health care the same database may be used by medical personnel for patient care recording, for surveillance of patient status, and for treatment advice; it may be used by researchers in assessing the effectiveness of drugs and clinical procedures; and it can be used by administrative personnel in cost accounting and by management for the planning of service facilities.
The fact that data are shared promotes consistency of information for decision-making and reduces duplicate data collection. A major benefit of databases in health care is due to the application of the information to the management of services and the allocation of resources needed for those services, but communication through the shared information among health care providers, and the validation of medical care hypotheses from observations on patients are also significant.
A database system facilitates the collection, organization, storage, and processing of data. The processing of data from many sources can provide information that would not have been available before the data were combined into a database. Hence, a collection of data is not by itself a database; a system that supports data storage is not necessarily a database system, and not all the information provided by computer systems is produced from databases.
Nearly every industry today is grappling with the IT issues surrounding the ever expanding volume of data, the numerous applications and databases that use data, as well as the regulations governing how that data is shared. But the healthcare industry faces a unique set of challenges in modernizing its infrastructure. Healthcare IT executives are being tasked with developing and operating solutions that integrate data from a range of patient, clinical, and back office systems to healthcare providers, patients, payers, technology and pharmaceutical companies. Federal regulations mandate that data and systems are interoperable and can be used for electronic health records (EHR) and health information exchanges (HIE) while meeting the requirements of ICD-10 and HIPAA 5010
A database is a collection of related data, which are organized so that useful information may be extracted. The effectiveness of databases derives from the fact that from one single, comprehensive database much of the information relevant to a variety of organizational purposes may be obtained. In health care the same database may be used by medical personnel for patient care recording, for surveillance of patient status, and for treatment advice; it may be used by researchers in assessing the effectiveness of drugs and clinical procedures; and it can be used by administrative personnel in cost accounting and by management for the planning of service facilities.
The fact that data are shared promotes consistency of information for decision-making and reduces duplicate data collection. A major benefit of databases in health care is due to the application of the information to the management of services and the allocation of resources needed for those services, but communication through the shared information among health care providers, and the validation of medical care hypotheses from observations on patients are also significant.
A database system facilitates the collection, organization, storage, and processing of data. The processing of data from many sources can provide information that would not have been available before the data were combined into a database. Hence, a collection of data is not by itself a database; a system that supports data storage is not necessarily a database system, and not all the information provided by computer systems is produced from databases.
Nearly every industry today is grappling with the IT issues surrounding the ever expanding volume of data, the numerous applications and databases that use data, as well as the regulations governing how that data is shared. But the healthcare industry faces a unique set of challenges in modernizing its infrastructure. Healthcare IT executives are being tasked with developing and operating solutions that integrate data from a range of patient, clinical, and back office systems to healthcare providers, patients, payers, technology and pharmaceutical companies. Federal regulations mandate that data and systems are interoperable and can be used for electronic health records (EHR) and health information exchanges (HIE) while meeting the requirements of ICD-10 and HIPAA 5010