Adaface Sample Data Modeling Questions

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.