Question

(Please do not copy and paste from another question. I am new to this and need it to be simple)

Draw an ERD for a “Hospital” with many departments and employees in each department. show things like (one to one, one to many, many to many).

What attributes would you store regarding each objects/class/data entities?

Thank you!

(Example)

FIGURE 4-10 An ERD for a bank with many branches Customer cust number-PK name bill address home phone office phone = Account

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Hospital Department PK PK Hospitali name phone DepartmentID Address Phone Hospital D Location FK Employee PK Employeeld Emplo

As you said you're new to this.Let me explain from the scratch
The above notation used to draw ER diagram is called Crow's foot notation and the tool used is Lucidchart
Entity Key Field Key Field Key Field This represents an entity(table) key is PK(Primary Key) and FK(Foreign Key)

this represents a many-to-one relationship

###########
Let's get into Entities:

The entities are:

  • Hospital
  • Department
  • Employee

The attributes of th entities are:

  • Hospital(HospitalID,Name,Phone,location)
  • Department(DepartmentID,address,phone,HospitalID)
  • Employee(EmployeeID,Name,Phone,Address,DepartmentID)

The underlined are the primary keys
#####

Let's get into relationships between the entities:

  1. A hospital can have many departments but a department belongs to only hospital(makes sense right?)
    so relationship between hospital and department is Many-to-One.
    Since a hospital can have many departments so we need to refer to our hospitalID in Department so that we can say which department belongs to which hospital.So HospitalID referred from Hospital is the foreign key for Department.
  2. A Department can have many employees whereas an employee can work for only department(makes sense right?) so the relationship between employee and department is many-to-one. We need to include a foregin key departmentID in employee table so that we can know which employee belongs to which department.

########################################################

Give a ThumbsUp if you found this answer Helpful :)
#######################################################


################################################################
............ Still having trouble understanding the answer ? Feel free to ask in the comment section.......

Add a comment
Know the answer?
Add Answer to:
(Please do not copy and paste from another question. I am new to this and need...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Make an ERD including all entities, attributes, relations, and constraints. Please upload as a doc based...

    Make an ERD including all entities, attributes, relations, and constraints. Please upload as a doc based on everything listed below University Bookstore •University Bookstore has several branches throughout Bloomington, and employees may be assigned to work at any of the branches. •Employees are identified by an ID and have a full name, date of birth, SSN, address, multiple phone numbers, a gender, and a hire date. •A Manager runs a branch and is responsible for all operations at that branch....

  • Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...

    Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The ER diagram should include entities, attributes (if there are less than three specified in the business statements, please add some extra attributes), identifiers and corresponding data types, the relationships among entities with cardinality and associative entities. .b) Extend Q1.a) to apply generalization/specialization technique to construct an Enhanced-ER (EER) diagram. The EER diagram should specify the complete (total) and disjoint (mutuallyexclusive) constraints on the generalization/specialization....

  • c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I att...

    c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...

  • TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please...

    TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please mark the Primary and Foreign Key ..... Deliverable: Word document with grade sheet followed by Part 1 ERD and the Part 2 relational schema. Part 1: Draw the ERD for the following situation. 8 pts Be sure to: Convert all many-to-many relationships to associative entities. Make sure each regular entity has an appropriate identifier. Make sure attribute names are unique within the ERD Wally...

  • PLEASE DO NOT COPY AND PASTE FROM A PREVIOUS QUESTION , THIS IS DIFFERENT. PLEASE READ...

    PLEASE DO NOT COPY AND PASTE FROM A PREVIOUS QUESTION , THIS IS DIFFERENT. PLEASE READ STEP 5 CAREFULLY. MUST BE WRITTEN IN C++ You are to implement a program for creating a daily transaction ledger for a shop. For this project, you will need to utilize the concepts ofarrays and object creation that have been discussed in class The list of requirements and constraints for the system are as follows 1. The system must be able to maintain records...

  • write in java and please code the four classes with the requirements instructed You will be...

    write in java and please code the four classes with the requirements instructed You will be writing a multiclass user management system using the java. Create a program that implements a minimum of four classes. The classes must include: 1. Employee Class with the attributes of Employee ID, First Name, Middle Initial, Last Name, Date of Employment. 2. Employee Type Class that has two instances of EmployeeType objects: salaried and hourly. Each object will have methods that calculates employees payrol...

  • Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and...

    Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their security needs. You have been hired by Wally and Henry to design a database management system to help them manage their business. Due to a recent increase in business, Fin and Finicky has decided to automate their client tracking system. You and your team have done a preliminary analysis and come up...

  • 1,List the first and last name of the donators that donated in December 2009. 2. List...

    1,List the first and last name of the donators that donated in December 2009. 2. List the ID's of the volunteers that have not worked. 3. List the ID, first name, and last name of any employees who works in the Finance department. 4. List all the different prices suppliers have for 'Tasty Meat' product. 5. Select the store ID and store phone number for all stores in 'St.Paul'. 6. List the member first and last name, address, city, zip...

  • Please help me with this question. I would really appreciate it. Please explain briefly I am...

    Please help me with this question. I would really appreciate it. Please explain briefly I am trying to prepare for a test. Consider the following relational database to manage concert and ticket sales. The relations are artist, concert, venue, seat, ticket, and fan. The schemas for these relations (with primary key attributes underlined) are: Artist-schema = (artistname, type, salary) Concert-schema = (artistname, date, venuename, artistfees) Venue-schema = (venuename, address, seating_capacity) Seat-schema=(venuename, row, seatnumber) Ticket-schema = (fanID, date, venuename, row, seatnumber)...

  • this is database course please draw the ER by this way We have been asked to...

    this is database course please draw the ER by this way We have been asked to analyze the data requirements and develop a database system to keep information for equipment hiring companies in the country The aim of this system is to monitor the hiring of equipment to dients. There are many companies in the country, and each company has at least three branches across the country. Where each branch has staff including the branch manager who is responsible for...

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