Data Wrangling Test

You are designing a data model for a healthcare system with the following requirements:

A: A separate table for each entity with foreign keys as specified, and a DoctorPatient table linking Doctors to Patients.
B: A separate table for each entity with foreign keys as specified, without additional tables.
C: A combined PatientDoctor table replacing Patient and Doctor, and separate tables for Appointment and Prescription.
D: A separate table for each entity with foreign keys, and a PatientPrescription table to track prescriptions directly linked to patients.
E: A single table combining Patient, Doctor, Appointment, and Prescription into one.
F: A separate table for each entity with foreign keys as specified, and an AppointmentDetails table linking Appointments to Prescriptions.

Look at the given ER diagram. What do you think is the least number of tables we would need to represent M, N, P, R1 and R2?

Consider a healthcare database with a table named PatientRecords that stores patient visit information. The table has the following attributes:

- VisitID
- PatientID
- PatientName
- DoctorID
- DoctorName
- VisitDate
- Diagnosis
- Treatment
- TreatmentCost

In this table:

- Each VisitID uniquely identifies a patient's visit and is associated with one PatientID.
- PatientID is associated with exactly one PatientName.
- Each DoctorID is associated with a unique DoctorName.
- TreatmentCost is a fixed cost based on the Treatment.

Evaluating the PatientRecords table, which of the following statements most accurately describes its normalization state and the required actions for higher normalization?

A: The table is in 1NF. To achieve 2NF, remove partial dependencies by separating Patient information (PatientID, PatientName) and Doctor information (DoctorID, DoctorName) into different tables.
B: The table is in 2NF. To achieve 3NF, remove transitive dependencies by creating separate tables for Patients (PatientID, PatientName), Doctors (DoctorID, DoctorName), and Visits (VisitID, PatientID, DoctorID, VisitDate, Diagnosis, Treatment, TreatmentCost).
C: The table is in 3NF. To achieve BCNF, adjust for functional dependencies such as moving DoctorName to a separate Doctors table.
D: The table is in 1NF. To achieve 3NF, create separate tables for Patients, Doctors, and Visits, and remove TreatmentCost as it is a derived attribute.
E: The table is in 2NF. To achieve 4NF, address any multi-valued dependencies by separating Visit details and Treatment details.
F: The table is in 3NF. To achieve 4NF, remove multi-valued dependencies related to VisitID.

Based on the ER diagram, which of the following statements is accurate and requires specific knowledge of the ER diagram's details?

A: A Student can major in multiple Departments.
B: An Instructor can belong to multiple Departments.
C: A Course can be offered by multiple Departments.
D: Enrollment records can link a Student to multiple Courses in a single semester.
E: Each Course must be associated with an Enrollment record.
F: A Department can offer courses without having any instructors.

Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?

Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?

 Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.

Two companies A and B hired developers from the year 2001 to 2005. The given bar graph shows the hiring details. 

Now select the statements that are true based on the given details.

A: The data given for Company A is skewed to the left.
B: The data given for Company B is skewed to the right.
C: The data given for Company A is skewed to the right.
D: For Company B, mean and mode are equal.
E: For Company B, mean is equal to median but less than mode.
F: For Company A, median is less than mode but greater than mean.

Saffi, one of the popular schools in San Francisco did a school wide study of the students in middle school. The study found that there is a negative correlation between the time spent on Facebook per day by students and their academic achievement. How can we understand the results of this study?

A: An increase in time spent on Facebook per day causes a drop in the academic achievement of students at the middle school level.

B: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at Saffi. 

C: An increase in the time spent on Facebook per day causes a drop in the academic achievement of students at Saffi. 

D: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at the middle school level.