Use database normalization techniques to split the flat file

Assignment Help Database Management System
Reference no: EM131040157

Information Systems Course Project-

You will be provided with simulated data from a hospital. The primary data set will include ER wait times, and supporting tables ranging from ER Staffing schedules to bed turnaround time. You will use this data to conduct an analysis into potential factors impacting ER wait times and recommend possible process improvements based on the dataand any additional research you have conducted. If you use external data resources make sure they are credible and properly cited in your presentation.
Your project must include the following components:

1. Import and Structure Data

a. Use the provided data sets to import tables into a blank access database

b. Use database normalization techniques to split the flat file databases into a relational database.

c. Make sure to utilize primary and foreign keys so the data can be queried effectively.

2. Exploratory Data Analysis & Reporting

a. Review the provided data sets to explore ER wait times, summarize the data and correlate it to the provided data sets. I.e. are wait times lower when more staff is assigned? Hint: do not stop there.

b. Your exploratory analysis must use one query that aggregates and at least one chart.

c. Use the queries from your exploratory analysis to create Access Report objects summarizing what you have discovered.

3. Interactivity

a. Create an Access Form that has an interactive component (drop down box, radio button, etc.)

b. When interacted with your form should requery and display the requested information, taking into account the users direct input?

4. Presentation

a. Create a PowerPoint presentation, it should include data from the reports you created as well as recommendations for how best to address the length of wait times in the ER.

b. Recommendations will be evaluated based on how feasible they are. You must consider patient safety, quality of care, cost of implementation and other limitations. No solution is perfect or free, but your recommendations should reflect consideration of these factors.

c. You should have more than one recommendation, but be sure to support your recommendations with data and detail. A single sentence is not a recommendation.

Data link- https://www.dropbox.com/s/1apq8g2nmlhldba/Project%20Data.xlsx?dl=0

Reference no: EM131040157

Questions Cloud

Statutorily protected employee organizations under the act : What are statutorily protected employee organizations under the Act? What standards does the NLRB apply to determine weather a group is an employee organizations for purposes of the act?
What is the marginal tax rate : What is the marginal tax rate for 2014 for $65,000 of taxable income for a single person?
How should the terminal value or going concern be estimated : What is the total value of AirThread before considering any synergies? What is the value of AirThread, assuming Ms. Zhang's estimates for synergies are accurate?
Cyber warfare gains in sophistication : Stuxnet and more recent types of malicious software, or malware- particularly Duqu, Flame, and Gauss-herald a frightening new era in cyberwarfare. China, Russia, the United States, and other nations have been engaging in cyberw arfare for several ..
Use database normalization techniques to split the flat file : Import and Structure Data - Use the provided data sets to import tables into a blank access database and Use database normalization techniques to split the flat file databases into a relational database
Who is harmed by the library project : Who is harmed by the Library Project? Make a list of harmed groups, and for each group, try to devise a solution that would eliminate or lessen the harm. Why is Google pursuing the Library Project? What is in it for Google? Make a list of benefits to..
Question regarding the marketing operations : How are the four major functions of management (planning,organising, leading and controlling) are related to the marketing operations, finance and human resource management departments?
Cases in collective bargaining and industrial relations : What are statutorily protected employee organizations under the Act? what standards does the NLRB apply to detemine weather a group is an employee organizations for purposes of the act? What are the standards of the NLRB apploes to determine if emplo..
Change without altering that persons values : Are accurate perceptions always necessary to develop sound decisions? Is it appropriate to change the emotions of people in the organization? If so, what situations will be appropriate? And how can a person’s emotions be change without altering that ..

Reviews

Write a Review

 

Database Management System Questions & Answers

  Analyze how the data breach could have been prevented

Analyze how the data breach could have been prevented with better adherence to and compliance with regulatory requirements and guidelines, including management controls; include an explanation of the regulatory requirement (such as from FISMA, HIP..

  What functional dependencies can you identify

Suppose you have a relation schema about teaching classes that has the following attributes: Class, Instructor, Time and Room - based on your understanding of this scenario, what functional dependencies can you identify that hold on this relation?

  Dependencies can you infer does not hold over relation s

From the JD, the set of relation schemes SP, PJ, and JS is a lossless-join decomposition of SPJ. Construct an instance of SPJ to illustrate that no two of these schemes su?ce.

  Given the file structure shown in figure p11 answer

given the file structure shown in figure p1.1 answer problems 1-4.1.how many records does the file contain? how many

  Construct a query that can be used on a report

Construct a query that can be used on a report for determining how many days the customer's invoice will require payment if total amount due is within 45 days. Provide a copy of your working code as part of the paper.

  How database processing differs from file processing

Over time computers have evolved from room-sized machines to hand-held devices. What has been the impact of this evolution?

  Development of the database

As an alternative for development of the database, you are considering outsourcing the functions above. Research the Internet and other media sources for vendors who develop registrar and school management database systems

  Who manages the database and what skills do they need

Storage location - Would this be on site? What about virtual? Explain reasoning. Based on storage location, what would the client have to buy, setup? Who manages the database? What skills do they need

  Find the decryption function and decipher

Find '(2007), '(2008), and '(b), where b is the integer obtained from the last four digits of your student number.

  What is referential integrity

Pathivadr's (2009) article addresses a fundamentally critical function in the relational model DB-referential integrity. What is referential integrity

  Which logical operator has the lowest precedence

What decision structure is logically equivalent to the following? What logic operator could be used to replace the nested selection structure in....? Which logical operator has the lowest precedence

  What is cold backup and hot backup in case of oracle

What is cold backup and hot backup (in case of Oracle)? What are Armstrong rules? How do we say that they are complete and/or sound?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd