DQ1 How important are naming conventions in database modeling? What comes first: the need for a report or the data?   DQ2 Recall the Y2K bug or the quote “640K [of memory] ought to be enough for anybody” misattributed to Bill Gates. What lessons can one learn from these examples when it comes to database […]

DQ1 Who would be the ideal candidate(s) to elicit information from during the requirements gathering and analysis phase? Explain why.   DQ2 Compare bottom-up to top-down modeling. What is the best approach to arrive at an effective data model?

DQ1 What are the benefits or disadvantages of ER diagrams? Why bother with logical design and not just create tables and columns (physical design) directly?   DQ2 How does understanding the logic of a database assist clinical resources? How does being involved with workflow development assist IT resources?

DQ1 Consider the following scenario: You are in a hospital setting that uses an enterprise EHR system with multiple interfaces to other health information platforms. What types of data would be kept in each system and what steps would be needed to allow for analytics to be performed across multiple disparate platforms?   DQ2 Compare […]

There are many different message appeals that can be found in advertising including the use of the following (beginning on page 227):   (a) Endorsers   (b) Humor   (c) Appeal to fears and/or guilt of the consumer   (d) Sex or use of subliminal messages   (e) Music   (f) Comparative advertising.   Checklist: […]

The Medication Debate   Over the past 10 years, children being diagnosed with behavioral problems relating to disabilities such as ADHD and bipolar disorder have risen exponentially. Furthermore, the Center for Disease Control (CDC) states that in 2007, 5.4 million children, ages 4 to 17, have been diagnosed with ADHD, and 2.7 million are taking […]

Database Schema-SQL Statements            1) Based on the feedback received on your Topic 2 assignment Database Schema, provide SQL statements to create the (revised) database and populate it with sample data (at least four rows per table).   2) Modify the database by adding an additional column (“Deleted_Date”) to those tables […]

SQL Queries         For this assignment you will create SQL queries use the following database schema:   1.            Patient—PatientID, Name, DOB   2.            Doctor—DoctorID, Name, MedLicenseNumber, Phone   3.            Medication—MedicationID, BrandName, GenericName   4.          […]

Risk Incidence Occurrence Solution            In reference to your Database Design Proposal from topic 1, consider a situation where you want to track, and ultimately identify performance variances (quality measures) or the occurrence of at-risk incidents (pharmaceutical) within the environment you selected.   Write a 500-750 word proposal for an incident solution […]

Database Schema              Design a database schema for the proposed Database Design Proposal in Module 1.   Identify and list all relevant entities and their relationships:   1) Select no less than five entities.   2) Provide a diagram.   3) Map this to a database schema.   4) Provide […]