Question

Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate

2. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient’s name and date of birth are recorded. Some patients are resident patients who spend at least one night in the hospital, and others are outpatients who are treated and released. Resident patients are assigned a room. Each room is identified by a room number. The system also stores the room type (private or semiprivate) and room fee. Over time, each room will have many patients. Each resident patient will stay in only one room. Every room must have had a patient, and every resident patient must have a room.
0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

ER Diagram:

1. ER diagram is a logical representation of database.

2. It represents the relation among all the entities of the database.

ER diagram according the provided conditions:

Picture 1

Explanation:

• Table Patient used to hold the data about the each patient with all basic details.

• P_Id works as a primary key for the table Patient and Room_No work as a primary key for fetvhing the detail about room.

• Relationship used to categorized the patient type according their conditions.

• Entity Resident having one-to-one relationship with the table room.

• Table Room used to hold the data about the each room with all basic details.

• Room_No work as aprimary key for the table Room.

Add a comment
Know the answer?
Add Answer to:
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient...

    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)....

  • Given the following business scenarios, create Crow’s Foot ERDs using a specialization hierarchy if appropriate. (Make...

    Given the following business scenarios, create Crow’s Foot ERDs using a specialization hierarchy if appropriate. (Make sure that you diagram parent-child relationships.) Two-Bit Drilling Company keeps information on employees and their dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the SSN and department names should be kept....

  • Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information...

    Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information on its employees and the departments in which they work. For each department, the department name,internal mailbox server, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name...

  • Given the following business scenario, create a Crow’s Foot ERD The local city youth league needs...

    Given the following business scenario, create a Crow’s Foot ERD The local city youth league needs a database system to help track children that sign up to play soccer. Data needs to be kept on each team and the children that will be playing on each team and their parents. The team has an ID, name, and colors. Data stored for each player consists of the id, first name, last name, and age. Also, data needs to be kept on...

  • create a Crows Foot ERD using specilization ERD

    Problem 3. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employees and the departments that they work in.  For each department, the department name, internal mail box number, and office phone extension are kept.  A department can have many assigned employees, and each employee is assigned to only one department.  Employees can be salaried employees, hourly employees, or contract employees.  All employees are assigned an employee number.  This...

  • Crow's Foot ERD 1

    Given the following business scenarios, create Crow’s Foot ERDs using a specialization hierarchy if appropriate. (Make sure that you diagram parent-childrelationships.)Two-Bit Drilling Company keeps information on employees and their dependents. Each employee has an employee number, name, date of hire, and title. If an employee is aninspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the SSN and departmentnames should be kept. All dependents must be...

  • Make an ERD using the following description

    WardsThe Hope Hospital has 17 wards with a total of 240 beds available for short- and long-term patients, and an outpatient clinic. Each ward is uniquely identified by a number (for example, ward 11) and also a ward name (for example, Orthopedic), location (for example, E Block), total number of beds, and telephone extension number (for example, Extn. 7711).Staff The Hospital has a Medical Director, who has overall responsibility for the management of the hospital. The Medical Director maintains control...

  • Crows Foot ERD for Granite Sales

    Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employeesand the department that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can havemany assigned employees, and each employee is assigned to only one department. Employees can salaried employees, hourly employees, or contract employees. All employeesare assigned an employee number. This is kept along with...

  • Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.

    Exercise 1: ERD Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. A department employs many employees, but each employee is employed by only one department. Some employees, known as "rovers," are not assigned to any department. A division operates many departments, but each department is operated by only one division. An employee may be assigned many projects, and a project-may have many employees assigned to it. A project must have at least one employee...

  • Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and...

    Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and participations. The administrators of Tiny College are so pleased with your design and implemen- tation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: • Faculty members may use the vehicles owned by Tiny College for officially sanc- tioned travel. For example, the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT