Database - Data Modelling || Select Correct Answer:
1.1 A supertype is a generic entity type that has __________.
Subtypes
Supertypes
None of the above
no value
1.2 When an entity instance may be a member of multiple subtypes or there are more possible subtypes that have not been included, it is which of the following?
Overlap with partial specialization.
Overlap with total specialization.
Disjoint with total specialization.
Disjoint with partial specialization.
1.3 Which business rule from the following would require the creation of a supertype/subtype relationship in an ERD?
Every Patient must be either a male or a female.
A Nurse must always sign off when their shift ends, either on the hospital computer or on a physical sign-off sheet.
A Patient is considered an outpatient or a resident patient, where "Check-back Date" or "Discharge Date" are stored for each respectively.
A Doctor can have the attribute “Additional Role” (E.g Surgeon, Consultant etc). Doctors are uniquely identified by an ID number.
Dear Student ,
As per the requirement submitted above , kindly find the below solution.
Question 1.1 :
Answer :Subtypes
Explanation :A supertype is a generic entity type that has Subtypes
************************
Question 1.2 :
Answer :Overlap with total specialization.
Explanation :When an entity instance may be a member of multiple subtypes or there are more possible subtypes that have not been included in Overlap with total specialization.
************************
Question 1.3 :
Answer :Every Patient must be either a male or a female.
Explanation :Supertype Patient has either male or female.
************************
NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.
Database - Data Modelling || Select Correct Answer: 1.1 A supertype is a generic entity type that...
Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient’s last name, first name, date of birth, and date of admission are recorded. Also, every patient is seen by a Physician who develops a treatment plan for the patient. Each Physician may see many patients. Some patients are resident patients (they spend at least one night in the hospital) and others are outpatients (they are treated and released)....
The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than one attribute. Select one: True False Question 3 A foreign key allows you to join two tables. Select one: True False Question 4 Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key? Select...