ZuoTi.Pro
Question

ABC is a company that specializes in IT training. The Company has 100 employees and can...

ABC is a company that specializes in IT training. The Company has 100 employees and can handle up to 15 teams per project. The company can operate a project that work more than one team on it and at least one team works for a running project. Each team cannot work in more than one project at the same time. Each employee can be a member in more than one team and each team must have at least one member. Also, each team must have a leader. Each leader can be a leader for one team only per project.

  • Draw the ER Diagram
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Solution:

In the below given ERD (entity relationship diagram):

  • The company can work on more than one project at a time.
  • An employee can be a part of more than one team.
  • Each team can work on one project only at a time.
  • Each team must have a team leader.
  • Each leader can be a leader for one project only.

ER diagram for ABC company:

company have employee have works for works for team project have have leader

0 0
Add a comment
Know the answer?
Add Answer to:
ABC is a company that specializes in IT training. The Company has 100 employees and can...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • ABC Company, Inc., has been in existence for 10 years. It has 50 employees and currently...

    ABC Company, Inc., has been in existence for 10 years. It has 50 employees and currently only one location. ABC Company manufactures one product: widgets. It has managed to stay in business by holding onto a small portion of the widget market, but it is far from the market leader. Over the last five years, ABC Company’s market share has stayed more or less stagnant. The president of the company is an older gentleman who mostly works from home. He...

  • Company: XYZ Consulting Is a 100-person consulting company that specializes in data management, data governance, and...

    Company: XYZ Consulting Is a 100-person consulting company that specializes in data management, data governance, and BI. They are a 10 year old company having difficulties understanding how to estimate future revenue and costs. You are assigned as the PM, you have a business analyst and technical resource assigned to your team. The BA is brand new to the company and the technical resource is currently part of 4 project teams. The project has high visibility and importance to the...

  • The department in which you work in your company has 24 employees: 10 women and 14...

    The department in which you work in your company has 24 employees: 10 women and 14 men. A team of anywhere from one employee up to 9 employees must be chosen to attend a meeting at the company’s headquarters. How many different teams can be selected?

  • A relational database is to be designed for a medium sized Company named Global Support Solutions (GSS) dealing with ind...

    A relational database is to be designed for a medium sized Company named Global Support Solutions (GSS) dealing with industrial applications of computers. The Company delivers various products to its customers ranging from a single application program through to complete installation of hardware with customized software. The Company employs various experts, consultants and supporting staff. All personnel are employed on long-term basis, i.e. there are no short-term or temporary staff. Although the Company is somehow structured for administrative purposes (that...

  • Case (ABC Company): ABC is an IT company specialized in developing web-based and mobile applications. Each...

    Case (ABC Company): ABC is an IT company specialized in developing web-based and mobile applications. Each application is custom designed according to customer requirements. Project managers are assigned to each project only after the sales department has a signed contract. The project managers can come from anywhere within the company. The assigned project managers can be responsible for as many as seven projects at one time. In the past, there has not been enough emphasis on project management. At one...

  • Design a class named Employee. The class should keep the following information in

    WRITE IN C++ ONLY PLEASE. IM USING VISUAL STUDIO CODE.1. Employee and ProductionWorker ClassesDesign a class named Employee. The class should keep the following information in• Employee name• Employee number• Hire dateWrite one or more constructors and the appropriate accessor and mutator functions for the class.Next, write a class named ProductionWorker that is derived from the Employee class. The ProductionWorker class should have member variables to hold the following information:• Shift (an integer)• Hourly pay rate (a double )The workday...

  • Managing from distance to work for a startup company. The company had employees who were teleworking...

    Managing from distance to work for a startup company. The company had employees who were teleworking for them from outside of the U.S. Some of those employees left the company during the first or second phases of the new company’s projects after relevant training was provided for them. They left for better job opportunities by leveraging this startup company to find new employer. This harmed the company significantly. The project managers had to put their teams together based their own...

  • Computer Labs Incorporated is a company that specializes in setting up computer labs for clients in...

    Computer Labs Incorporated is a company that specializes in setting up computer labs for clients in large and small businesses as well as schools. Under the leadership of Liza Rachels and Georgio Rozalini, the company is thriving. You are continuing as VP of Project Development, and now lead a team of 6 project directors who help coordinate projects for the company. Each project director has a team of employees to work on the various projects. One goal that is directly...

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

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