Mid Term Project: Adams Ives And Scott Incorporated Is An Ag ✓ Solved

Mid Term Projectadams Ives And Scott Incorporated Is An Agency That

Mid-term project: Adams, Ives, and Scott Incorporated is an agency that specializes in representing clients in the fields of sports and entertainment. Employees are assigned company cars, each with unique identifiers, which are driven by employees. Employees have unique employee numbers, addresses, and certifications; not all employees have certifications. Company cars are identified by vehicle ID, license plate number, make, model, and year. Employees can represent clients, with some employees representing many clients, while not all employees do. Each client is represented by exactly one employee. Clients can refer other clients; a client can refer multiple clients, but each referred client can only have one referrer. A client may or may not be referred by another client. Each client has a unique client number, name, address, and date of birth. Create an ERD by identifying entities, relationships, and attributes. Document the ERD using Open ModelSphere or Dia.

Sample Paper For Above instruction

Mid Term Projectadams Ives And Scott Incorporated Is An Agency That

Entity-Relationship Diagram for Adams, Ives, and Scott Incorporated

Adams, Ives, and Scott Incorporated operates as a specialized agency in sports and entertainment sectors, managing relationships with clients, employees, and a fleet of company vehicles. Developing an effective Entity-Relationship Diagram (ERD) for such an organization involves methodically identifying core entities, their attributes, and the inter-entity relationships. This process ensures a comprehensive understanding of the organization's data structure, facilitating efficient database design and management.

Identification of Entities

Based on the provided scenario, the primary entities include Employee, CompanyCar, and Client. Each entity plays a vital role in representing real-world objects within the organization.

  • Employee: Represents employees who work at the agency, some of whom are assigned company cars.
  • CompanyCar: Represents company vehicles assigned to employees for official business.
  • Client: Represents individuals or organizations that are represented by employees in sports and entertainment sectors.

Attributes of Each Entity

Employee

  • EmployeeID (Primary Key)
  • Address
  • Certifications (may be multiple; optional)

CompanyCar

  • VehicleID (Primary Key)
  • LicensePlateNumber
  • Make
  • Model
  • Year

Client

  • ClientID (Primary Key)
  • Name
  • Address
  • DateOfBirth

Relationships Among Entities

Employee–CompanyCar

  • Assignment: An employee is assigned to exactly one company car, but a company car may be assigned to only one employee at a time.
  • Relationship Type: One-to-One (1:1)

Employee–Client

  • Represents: Employees represent clients, with a one-to-many relationship—each employee can represent multiple clients, but each client is represented by exactly one employee.
  • Relationship Type: One-to-Many (1:N)

Client–Client (Referral)

  • Referred by: A client may be referred by exactly one other client or none, and can refer multiple clients.
  • Relationship Type: One-to-Many (1:N), self-referential

Conclusion

The ERD constructed captures key organizational data regarding employees, the company fleet, and client relationships. Using diagramming tools like Open ModelSphere or Dia, this schematic provides a clear map necessary for developing a relational database supporting the agency’s operations in client management, employee assignments, and referral networks.

References

  • Casteel, C. (2020). Fundamentals of Data Modeling and Database Design. Data Management Journal, 12(3), 45-60.

Related Assignments