Answered You can hire a professional tutor to get the answer.
A local accounting firm that is growing rapidly has asked for you help. The firm has four partners who are primarily responsible for developing new
A local accounting firm that is growing rapidly has asked for you help. The firm has four partners who are primarily responsible for developing new business, the partners are very busy with their management tasks, so the partners need an easy way to record their new business development activities that does not take too much time of effort. The managing partner of the firm has asked you to develop a database that will help the four partners track their new business development efforts. After talking with the managing partner, you decide that the following information needs to be included in the database;
- Identity of the partner who is developing the new business lead, including the partner's first name, middle initial, last name and four-digit employee ID number.
- Identity of the client or potential client for which the work would be done, including the company name, the key contact persons at the company, and the company address (street address, city, state and ZIP code).
- Information about each new business lead, including the type of new business (the firm classifies its work into the following categories; audit, accounting, tax compliance, tax research, litigation support and other consulting) and an estimate of the revenue the firm could derive from the new business.
- Information about each contact made to develop each new business lead, including the date of the contact, how much time the partner spent on the contact (in hours), and a brief summary of important points discussed.
Using the bottom-up approach, design a set of relational database tables that will include all needed information. Be sure that the tables are in 3NF.