Question

If a database is not maintained or if incorrect data is entered into the database, serious...

If a database is not maintained or if incorrect data is entered into the database, serious problems can occur. What problems could occur if a student database is not maintained? What problems could occur if a database that maintains medical records data (such as a hospital database) has incorrect data?

Homework Answers

Answer #1

Question 1

If a database is not maintained or not even updated and a student comes and register for a course. There is a possibility that he's requested may be accepted but he will not be visible in the enrollment list or if incorrect data is updated it will create a chaos taking an example if a student entered detail to enroll in physics class but invalid data entry caused the student to enroll in chemistry class.

Question No 2

If a hospital database has incorrect data it will create a mess not only for patients but also for doctors too. Multiple records can be shown on a single patient or a patient which is admitted but database will not have correct information resulting his absence. Incorrect diagnose and operations can be performed all the management of hospital can be affected by database incorrect data.

IF YOU HAVE ANY QUERY PLEASE COMMENT DOWN BELOW
PLEASE GIVE A THUMBS UP

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
q4 The data dictionary usually is maintained automatically by the DBMS. by the database administrator. by...
q4 The data dictionary usually is maintained automatically by the DBMS. by the database administrator. by the database programmers. by top management
How does a database address problems with file systems? How can database systems improve data quality...
How does a database address problems with file systems? How can database systems improve data quality and data integrity?
Question 3 What major advantage does NoSQL database systems have? NoSQL database systems data is highly...
Question 3 What major advantage does NoSQL database systems have? NoSQL database systems data is highly structured NoSQL database systems are good for operational data. NoSQL database systems bundle massive scale well NoSQL database systems can deal with unstructured data
Mary a database administrator frequently writes queries that combines the data in the Students Table with...
Mary a database administrator frequently writes queries that combines the data in the Students Table with that in the CourseRegistration using Cartesian Products then filtering the data to obtain the course Registrations of a student. Mary also frequently queries for students who have registered for no course using the syntax CourseCount<1. Identity any three improvements that can be made to the performance of the student management system database from this description and write the appropriate best performing versions of each...
We are comparing database processing and spreadsheet processing. We have a database table (customers) with 500...
We are comparing database processing and spreadsheet processing. We have a database table (customers) with 500 records. How much of this table has to be processed if we update the entry for customer Smith? (1 mark) What does this tell us about database processing in general? (1 mark)   As a comparison, we have a spreadsheet with data/formulas across 500 cells. How much of this spreadsheet is processed if we update one cell? (1 mark) What does this tell us about...
At University Hospital, the Database Management Systems (DBMS) administrator is responsible for creating and maintaining databases....
At University Hospital, the Database Management Systems (DBMS) administrator is responsible for creating and maintaining databases. Several departments have asked him to develop a process to keep track of all the data they document. In the past, they have had problems creating a system that modeled well and supported end-user access. The database administrator must create a way to track all the data in the organization. What steps should the DBMS administrator take to ensure the information is organized and...
Release of Medical Records Sally, Michael, and Teresa handle requests for the release of patients' medical...
Release of Medical Records Sally, Michael, and Teresa handle requests for the release of patients' medical records for a Midwestern hospital serving a five-state area. They emphasize that they can release records only with signed authorization from the patient or on subpoena, and that they may then release photocopies, but never original medical records. When someone visits the hospital to pick up copies of a patient's records, that person is asked to show identification. Case: Michael lets experience be his...
Read the following description of the MHC-PMA (Mental Health Care-Patient Management Application) then answer the questions...
Read the following description of the MHC-PMA (Mental Health Care-Patient Management Application) then answer the questions that follow. (20 Points) A patient information application to support mental health care is a medical information application that maintains information about patients suffering from mental health problems and the treatments that they have received. Most mental health patients do not require dedicated hospital treatment but need to attend specialist clinics regularly where they can meet a doctor who has detailed knowledge of their...
Q1) Connect to HR database and write the queries to answer the following questions. Provide your...
Q1) Connect to HR database and write the queries to answer the following questions. Provide your queries text and result in a .txt file: a) How many employees you can find in the Employees table b) How many departments are there in this database c) How many employees work for sales department d) What is the average salary of department 50 e) Copy Countries table from HR database into Section 24 using Select Into clause. f) Write a query to...
There is one question listed below. Based on the content you have completed so far in...
There is one question listed below. Based on the content you have completed so far in this course, answer each question. After completing, submit this assignment to the M04 Lab Assignment link on IvyLearn. (40 points) With the information provided below, create a normalized ER diagram (third normal form) in draw.io for the entities in the Academic Database (School Management System). A good starting point for this question is to review your submission for the M03 Assignment, question #4. Add...