The business is taking the opportunity to specify more requirements that you can use to expand on your AS-IS conceptual data model. This expanded model is your TO-BE conceptual data model.

 

Here are the new requirements.

 

1. marketing department renegotiates company price with employee

data: marketing department, product, employee, offered price, company price, approval date

1. marketing department monitors customer satisfaction for each product

data:  customer, product, customer satisfaction score, score date

 

These two requirement statements suggests two business activities that need to be done. RENEGOTIATION and CUSTOMER_SATISFACTION. Each of these activities can be modeled as an entity. To better see theses entities (in blue) with their relationships (not in blue) you reword the requirements to be...

 

1. marketing department specifies price for renegotiation price accepted by employee representing product

data: marketing department, product, employee, offered price, company price, approval date

1. marketing department monitors customer satisfaction tracks priority of product

data:  customer, product, customer satisfaction score, score date

 

RENEGOTIATION and CUSTOMER_SATISFACTION are know as association tables. An association tableis used to track the relationship between two entities. RENEGOTATION tracks the price offered, the agreed upon company price, and which employee approved the price on which date for which product. CUSTOMER_SATISFACTION tracks the satisfaction score for each product for which date.

 

Add the RENEGOTIATION and CUSTOMER_SATISFACTION entities with their relationships and attributes to your TO-BE Conceptual Data Model. Make sure to specify the identifying attributes. The identifying attributes for an entity uniquely identify one and only one instance of that entity.

EMPLOYEE FirstName LastName Address Manager Salary Type Department SALARY Amount Type Allison Shannon 41077262 RENEGOTIATION Department Product Employee OfferedPrice CompanyPrice ApprovalDate PURCHASE Purchase Date CompanyPrice SalePrice PricePerUnit TotalPrice SalesPerson Product H Name Vendor Company VendorPrice Product Quantity CUSTOMER FirstName LastName CUSTOMER SATISFACTION Customer Product SatisfactionScore ScoreDate PAYMENT PaymentDate Type Amount Comments