Healthcare Database Design/Development

College of Health Sciences

Healthcare Database

Design/Development

32.633-041

UNIVERSITY OF MASSACHUSETTS LOWELL

College of Health Sciences

Syllabus

Healthcare Database Design

32.633-041

Spring 2014

Instructor: Rose Candelieri, MS, RD

E-mail:

[email protected]

Class Meetings (6): Wednesday 5:30 pm-8:30 pm (see attached schedule)

Online Classes (8): Wednesday 7:30 – 9:00 pm (see attached schedule)

Class Meeting Location: Yankee Alliance Offices

138 River Road, Andover, MA

Pre-requisites: None - Open to all students who have a minimum of a

bachelor’s degree

Class Hours: 3 Semester Hours

Course Description

This course is a practical approach to the design, and development of a relational database with an emphasis on healthcare. Analyzing the requirements of the database will proceed to the design of the structure of the relational database, which will then be developed in a Relational Database Management System (RDBMS). Microsoft Access will be used as the RDBMS platform.

Course Objectives

At the completion of the course, the student should be able to:

1. Understand the major DBMS models and systems. 2. Analyze and design a database system

4. Develop a relational database system

5. Understand the concepts of database administration.

Course Format

This course is taught in a blended format. This means that there will be a combination of face-to-face classroom meetings and on-line/audio chat classes.

On-Line Portion of the Blended Class Format

Course materials will be made available each week on Friday morning. You are

required to read the assigned text book chapters, view the videos, and perform activities and assignments.

How to Communicate in a Blended Format

Face to Face Meetings: There will be 6 traditional face-to-face classroom meetings. It

is expected that you attend all meetings. If, due to extenuating circumstances, you are unable to make a face-to-face meeting, contact me prior to class to discuss an alternative assignment. Failure to contact me will result in a 5 point deduction from your average grade.

Discussion Board: This is an online location where students and instructors interact

with comments and questions. Each week one or more discussion boards will be started. The discussion boards are open to all students for comments and questions. I will review the discussion board(s) on a daily basis and respond to questions/comments when

appropriate. A discussion board format has the benefit of allowing everyone in the class to benefit from the exchange. If one student has a question or concern, chances are, others do as well. In addition, discussion threads remain available throughout the entire course.

E-Mail: On occasion, when you feel the discussion should be more private in nature,

please feel free to email me using the online course email system. I will check my email daily and respond to you within 24 hours.

Audio-Chat: In weeks where there is no face to face class, there will be a scheduled

audio chat. These chats are scheduled on Wednesday’s from 7:30 pm to 9:00 pm. This time will be used to review weekly material and to clarify any issues or problems that students may be having. This allows the opportunity for everyone in the class to interact at the same time and have live discussion. Although, it is not required you participate in the weekly audio chat during the scheduled time-frame, it is encouraged as it is a way to interact with others in the class. Should you not participate it is expected that you will listen to the recorded session.

Evaluation Method

1. Weekly Assignments: 30% 2. Mid-Semester Project: 30% 3. Final Project: 40%

COURSE REQUIREMENTS

The student is responsible for completing all course assignments on dates specified by the instructor. No credit will be given for late assignments.

REQUIRED TEXT/MATERIALS

Hernandez, M. J.. (2003). Database Design for Mere Mortals. Boston, MA:

Addison-Wesley 2nd Ed.. ISBN 0-201-75284-0 Note: this can be purchased from Amazon.com

price comparison Web Site:

http://www.CampusBooks4Less.com/prices/0470407352

If you need to purchase Microsoft Access

MS Office 2010 Professional (contains Access) is available at: http://www.journeyed.com/ -- Please note MS Access is Not available for the MAC.

Other Requirements:

To participate in the Audio Chat you will need headphones with a microphone. A USB headset is recommended, but the two jack audio headsets will also work. Two versions (available at Amazon.com, Target and Wal-Mart)

Logitech Premium Stereo Headset with Noise-Canceling Microphone Logitech Premium USB Headset 350/250

Academic Integrity

There is a University policy regarding academic integrity. For details, see the Academic Integrity Policy at

http://www.uml.edu/Catalog/Graduate/Policies/Academic-Integrity.aspx. It is your responsibility to review and understand this policy.

GRADING SCALE A+ = 97-100 A = 93-96 A- = 90-92 B+ = 87-89 B = 83-87 B- = 80-82 C+ = 77-79 C = 73-76 C- = 70-72 F = 69 and below

SNOW POLICY

In the event that classes are cancelled due to bad weather and it is on a Face-to-Face meeting date we will have an Audio chat and will push the Face-to-Face meeting to the next week, if the room is available. If the University has not closed, but I deem it to be hazardous for students to travel, I will post both an announcement and email on the course website and email everyone at their student email address.

Course Schedule

Post personal introductions on

discussion board 1/28/2014 1

Chapter 2 – Design Objectives

Log into WebCT, run Audio Chat

Setup 1/28/2014 0 Chapter 3 – Terminology 2 1/24/2014 1/29/2014 O Chapter 4 – Conceptual Overview

Mock DB: Post a minimum of 2

unique questions on discussion board to determine mission statement and objectives

Prior to

2/4/2014 1 Chapter 5 – Starting

the Process

Mock DB: Submit mission

statement and objectives 2/4/2014 2 Student DB: Be prepared to

discuss your design topic. 2/5/2014 0

3 1/31/2014 2/5/2014 O Chapter 6 – Analyzing the Current Database

Student DB: Post your design topic

(after discussed in class) 2/11/2014 1

Student DB: Submit mission

Mock DB: Post a minimum of 2

unique questions on discussion board to analyze requirements of database Prior to 2/18/2014 1 4 2/7/2014 2/12/2014 O Chapter 7 – Establishing Table Structure

Mock DB: Submit tables and fields 2/18/2014 10

5 2/14/2014 2/19/2014 O

Chapter 8 – Keys Mock DB: Submit Keys 2/25/2014 2 Chapter 9 – Field

Specifications

6 2/21/2014 2/26/2014 O Chapter 10 – Table Relationships

Mock DB: Submit relationship

matrix 3/4/2014 2

7 2/28/2014 3/5/2014 O

Chapter 11 – Business

Rules Mock DB: Submit Views 3/11/2014 2

Chapter 12 – Views 8 3/7/2014 3/12/2014 O Chapter 13 – Reviewing Data Integrity

Mid-Semester Project

fields

3/14/2014 30

Semester Break

9 3/14/2014 3/26/2014 O

Chapter 14 – Bad Design – What Not to Do.

Student DB: Submit Keys 4/1/2014 2 Student DB: Submit relationship 4/1/2014 2

matrix

Student DB: Submit Views 4/1/2014 2

10 3/28/2014 4/2/2014 F

Developing Tables in Access

Student DB: Develop tables in

Access 5/7/2014 Developing Forms in Access 11 4/4/2014 4/9/2014 F Developing Forms in Access (continued)

Student DB: Develop queries in

Access

5/7/2014 Developing Views in

Access

Student DB: Enter some "dummy

data" to test your database

Student DB: Develop Views in

Access

12 4/11/2014 4/16/2014 F Developing Views in Access (continued)

Student DB: Develop reports in

Access 5/7/2014 Developing Reports in Access 13 4/18/2014 4/23/2014 F Developing Reports in Access (continued)

Student DB: Develop Macros,

Buttons, Menus in Access 5/7/2014

Developing Macros, Buttons & Menus in Access

Final Project

Student DB: Complete database design developed in Microsoft Access.