Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started