Question: 2. Build a Logical ERD using the below business description (Note: please write down any assumptions you make). Calls-R-Us is a call center company that

2. Build a Logical ERD using the below business description (Note: please write down any assumptions you make).

Calls-R-Us is a call center company that provides phone call services for businesses that dont have a call center of their own, or periodically need to expand beyond their capacity. The businesses they facilitate calls for provide scripts for their generic call center agents to use to interface with each customer.

Calls-R-Us employees who take calls are called, agents. An agent can take call from at least one or many customers, and each customer may or may not place calls to many agents. For each phone call that occurs, Calls-R-Us also needs to know which business the call is for. Therefore, the phone call can be considered the intersection of the agent, the customer, and the company that Calls-R-Us is taking the call for. For example, a customer named Margaret may call and speak with an agent named Phil to inquire about at least one or many businesses, such as her Comcast invoice, AT&T phone bill, etc.

For each agent, Calls-R-Us wants to track the AgentID, FirstName, LastName, Title, and HireDate. For each customer, Calls-R-Us wants to track the CustomerID, FirstName, LastName, and PhoneNumber. For each business, Calls-R-Us wants to track the BusinessID, BusinessName, ContactName (ContactFirstName, ContactLastName), and PhoneNumber.

For each call, Calls-R-Us wants to track the CallDate, BeginTime, and EndTime of the call. Of course, Calls-R-Us wants to know which agent, customer, and business the call was related to as well. Note that it is impossible for the same agent to retake a call from the same customer who are calling about the same business at the same date.

[Replace this line with a screenshot of your ERD]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!