Ask a Question

DBM 381 ENTIRE COURSE

Sale price $40.00 Regular price $80.00

DBM 381 ENTIRE COURSE
 
 
WEEK  1
 
DBM 381 Week 1 Individual Assignment Database Paper
 
Write a 700- to 1,050-word paper in which you do the following:
Define health care database systems. Describe how databases are used across the health care industry.
Explain the different database architectures including the relational architecture.
Describe the needs of database users across the health care continuum.
Format your paper consistent with APA guidelines
 
WEEK 2
DBM 381 Week 2 Individual Assignment ERD and Database File
 
Complete Service Request SR-ta-001: Scheduling System Database.


Note. This course utilizes the Virtual Organizations, an Apollo Group, Inc. learning tool. The Virtual Organizations portal is accessed from the link on your course materials page.
Write a 300- to 350-word memo to the Technical Services/Logistics Manager at Taylor Ambulance explaining the following:
The design you will use
How your electronic solution will cover their needs from a management perspective
Create a detailed ERD using the Entities and Attributesdocument provided with the Service Request.


Create a Microsoft® Access® database using the ERD created above. You do not need to include keys and relationships at this point. Include the following:
Tables with appropriate data types
Descriptions
Format
Masking
Submit the ERD, memo, and Microsoft® Access® database file to your facilitator.
 
 
DBM 381 Week 2  Learning Team Assignment Patient Record System
 
 
Begin creating the 8- to 10-slide presentation. Add slides where you explain database design and the usage of the ERD from a management point of view.


Submit your presentation draft for facilitator review.
 
 
WEEK 3
 
DBM 381 Week 3 Individual Assignment Normalized ERD, Memo, and Database File
 
Update the detailed ERD created during Week Two to normalize it to the third normal form.


Write a 300- to 350-word memo to your client that explains the level of normalization and explain why that level is sufficient for this system.


Update the Microsoft® Access® database created during Week Two. Assign appropriate keys and relationships among tables established using the Relationships Tool. Once the database has been created, add relevant data to each table, at least 10 records for each.


Submit the ERD, memo, and Microsoft® Access® database file to your facilitator.
 
 
 
DBM 381 Week 3  Learning Team Patient Record System
 
Continue working on the Database Project by creating the detailed ERD and normalizing your design to the third normal form.


Create a Microsoft® Access® database using the ERD created for the Patient Record System from Week Two.


Select and establish keys and relationships.


Submit your ERD to your facilitator for feedback
 
 
WEEK 4
 
 
DBM 381 Week 4 Individual Assignment Data Collection Standards Memo
 
Write a 700- to 1,050-word memo to Taylor Ambulance explaining data collection standards used in the health care industry.


Create at least five forms within the Microsoft® Access® database used in Week Three to capture data. Include at least one form with an incorporated sub form.


Create at least five reports within the Microsoft® Access® database used in Week Three that shows information that management at Taylor Ambulance might want to see as they manage their business. Include at least one report with an incorporated sub report.


Submit your memo and Microsoft® Access® database file to your facilitator
 
 
DBM 381 Week 4 Learning Team Patient Record System
 
Use the Microsoft® Access® database from Week Three.


Create at least five forms within the Microsoft® Access® database to capture data. Include at least one form with an incorporated sub form.


Create at least five queries within the Microsoft® Access® database that shows data that Patton-Fuller Community Hospital might want to incorporate on reports used to manage their business. Include at least two queries that join data from multiple tables.


Create at least five reports within the Microsoft® Access® database created using the queries created above. Include at least one report with an incorporated sub report.


Submit the Microsoft® Access® database file to your facilitator for review
 
 
 
WEEK 5
 
 
DBM 381 Week 5  Learning Team Assignment Patient Record System Final Presentation
 
Incorporate any feedback on the ERD and Microsoft® Access® database from your facilitator.


Consolidate all team members’ work into a single database.


Complete the 8- to 10-slide Microsoft® PowerPoint® presentation in which you explain the principles of database design and management. Include the following:
A discussion of health care data collection standards
Privacy and security risks
Other management considerations
Data management controls
Data ownership
Protection controls
Retention and destruction requirements
Disaster recovery and business continuity plans
Speaker notes
References
A cover page
A rationale for the forms, queries, and reports created
Submit your ERD, Microsoft® Access® database file, and Microsoft® PowerPoint® presentation to your facilitator.
 

Questions & Answers

Have a Question?

Be the first to ask a question about this.

Ask a Question