Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an entity-relationship(ER model of the given problem.In this stepto draw thediagram,you need to identify entities, relationships as well asinferring primary keys and foreign keys

Create an entity-relationship(ER model of the given problem.In this stepto draw thediagram,you need to identify entities, relationships as well asinferring primary keys and foreign keys for entities.)

How can I make an ER model of this example: ?

Founder of Meeseeks Interior Design farm (MID in short) Mr. Meeseeks wantsto utilize digital database system to store his companys data instead of files andcabinets based analog database they were maintaining so far. According to Mr.Meeseeks this is how the farm operates:

MID makes money by providing the interior designingservices to its clients, which are mainly homeowners. MID stores name, address, phone number of its clients for future support and so on.

MID has many branches spread around the country. Each branch hasaname, address. Every branch also has an employee who manages the branch. The date when the employee starts managing the branch is kept in record to measure his performance

Not all branches provide service to the clients. Some of them are just there for other managerial tasks. Such as the head branch where Mr. Meeseeks himself go to monitor the operations of his farm.

Every branch has employees. After all employees are the workforce of MID. In other words, there is no branch without employees. Each employees name, salary, age, sex, date of birth is kept in records.Employees also has employee IDs.

Each employee in MID is only associated with one branch. An employee can al so act as a supervisor of multiple other employees. Every employee has to have exactly one supervisor. Employees work with the clients controlled by the branch. Multiple employees can work with the same client. How many hours an employee worked with a client is also kept in record.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Secrets Of Analytical Leaders Insights From Information Insiders

Authors: Wayne Eckerson

1st Edition

1935504347, 9781935504344

More Books

Students also viewed these Databases questions