How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Steve Herrod Your Own Question
Steve Herrod
Steve Herrod, Master's Degree
Category: Writing Homework
Satisfied Customers: 1219
Experience:  Masters in Literature and a Bachelors Degree in French with Management
65126503
Type Your Writing Homework Question Here...
Steve Herrod is online now
A new question is answered every 9 seconds

Its a DBMS. Part 1: Database Concepts Imagine that a small,

Customer Question

Its a DBMS. Part 1: Database Concepts Imagine that a small, countryside hospital maintains its data in flat files on a file system. To assist in tracking patients and medical supplies, the hospital staff uses a custom application that accesses these flat
files. The staff sometimes accesses the files directly. With this scenario in mind, address each of the topics below. Topic 1: The Advantages of Database Management Systems Identify and describe several advantages that a database system would offer the hospital
over their current data management solution. Topic 2: Structural Independence Database systems exhibit structural independence, which occurs when the way that applications and users operate with the database is independent of how the data is actually stored
in the file system or other storage device. Explain why structural independence is important to the hospital staff. Topic 3: Problems with Data Redundancy Data redundancy occurs when the same data is duplicated in different parts of a data management system
in such a way that the duplicates are unnecessary and the duplicates can become inconsistent. Identify and explain how the hospital’s current data management solution could exhibit the three kinds of data anomalies described in the textbook. Topic 4: Five
Major Components of a DBMS Our Coronel, Morris and Rob text describes database systems as having five major components: hardware, software, people, procedures, and data. If the hospital were to adopt a database management system, describe ways in which people
would interact with and be responsible for the hardware, software, procedures, and data. You don’t need to try to provide an exhaustive list, because that would be voluminous, but only an indication that you have thought about how people would be responsible
for and interact with each of the other four components. Part 2: Converting a Spreadsheet to a Database The table below represents a table such as you might encounter in a spreadsheet or file-based application. First Name Last Name ID Code Fee Discount Amount
VisitDate Roger McHaney 1 99204 $361.56 $98.31 $263.25 6/23/2012 Roger McHaney 1 99214 $126.52 $32.35 $94.17 8/17/2012 Telly O'Grady 2 99203 $311.56 $98.31 $213.25 6/25/2012 Telly O'Grady 2 99213 $106.52 $32.35 $74.17 7/06/2012 Telly O'Grady 2 99213 $106.52
$32.35 $74.17 7/13/2012 Telly O'Grady 2 99213 $106.52 $32.35 $74.17 7/20/2012 Telly O'Grady 2 99212 $86.25 $32.35 $53.90 7/27/2012 Telly O'Grady 2 99212 $86.25 $32.35 $53.90 8/04/2012 Telly O'Grady 2 99212 $86.25 $32.35 $53.90 8/11/2012 Grant Brikestein 3
99202 $261.56 $98.31 $163.25 7/06/2012 Grant Brikestein 3 99212 $86.25 $32.35 $53.90 8/04/2012 Grant Brikestein 3 99212 $99.37 $53.23 $46.14 8/10/2012 Alarry Abu 4 99205 $411.56 $128.31 $283.25 7/13/2012 Betty Marygrade 5 99203 $311.56 $98.31 $213.25 7/17/2012
Samuel Timod 6 99202 $261.56 $98.31 $163.25 7/18/2012 Samuel Timod 6 99202 $261.56 $98.31 $163.25 7/24/2012 Imagine that you want to convert this to a relational database. Answer the following questions, which are progressively more difficult: 1. How many
records does this file contain? 2. How many fields are there per record? 3. What are the field names? 4. What do the records in this table probably represent? 5. Is there data redundancy in the table? If so, describe it. 6. Does this table contain data that
is part of different entities? If you think so, list the entities that are confounded in this file-like table. 7. Are there any fields you would add when converting this spreadsheet to a database? If your answer is “yes”, identify each field then briefly describe
the reason why you would choose to add it. 8. Are there other problems you would you need to address in converting this data to a relational database? If your answer is “yes”, identify and briefly describe each problem.
Submitted: 2 years ago.
Category: Writing Homework
Expert:  SusanAthena replied 2 years ago.
Thanks for your question. Do you still require an answer?
Kind regards,
Susan

Related Writing Homework Questions