Fields of sports and entertainment

Assignment Help Business Management

Reference no: EM132592856

Mid-term project:

Adams, Ives, and Scott Incorporated is an agency that specializes in representing clients in the fields of sports and entertainment. Given the nature of the business, some employees are given a company car to drive, and each company car must be assigned to an employee. Each employee has a unique employee number, plus an address and set of certifications. Not all employees have earned one or more certifications. Company cars are identified by their vehicle id, and also contain a license plate number, make, model, and year. Employees represent clients. Not all employees represent clients, while some employees represent many clients. Each client is represented by one and only one employee. Sometimes clients refer one another to use Adams, Ives, and Scott to represent them. A given client can refer one or more other clients. A client may or may not have been referred to Adams, Ives, and Scott by another client, but a client may be referred by only one other client. Each client is assigned a unique client number. Additional attributes recorded for each client are name, address, and date of birth.

Create an ERD by first identifying the entities, then their relationships, and finally add the attributes to each entity.

Document everything including ERD diagram using Open ModelSphere or Dia.

Reference no: EM132592856

Questions Cloud

Federal personal income tax : When we think of taxes, we often focus on the largest one, the federal personal income tax. But we also pay other taxes.

What setting will be your career choice and why : After reviewing the different setting in which Family Nurse Practitioners work. What setting will be your career choice and why? The response must be typed.

Identify at least one metric to measure process : Identify at least one metric to measure the process. Describe which forecasting methods would be applicable.

Which dissemination strategy you use to communicate ebp : Review the Resources and reflect on the various strategies presented throughout the course that may be helpful in disseminating effective and widely cited EBP.

Fields of sports and entertainment : Adams, Ives, and Scott Incorporated is an agency that specializes in representing clients in the fields of sports and entertainment.

What were the barriers to entry for amazon : What were the barriers to entry for Amazon when venturing into the global business setting.

Marginal revenue product curve : 1. The increase in total revenue due to increasing the amount of labor employed by one unit is called the

Explain the planning and requirements definition : Review the steps of the Systems Development Life Cycle (SDLC) and reflect on the scenario presented. Consider the benefits and challenges associated.

Describe steps for implementing improved practice : Post a description of some of the proposed action steps for implementing improved practice, and explain where potential challenges might compromise.

User Account

All Pages