Question

Create a conceptual model using either an entity-relationship diagram or a crow’s

foot notation to keep track of potential customers for new products.

You need to design the database so that the features of the new product are captured. You also

want to know what employee contacted the potential customer, the details that are known about

the customers, and which of the new products, specifically, a customer might be interested in.

For the new products themselves, you need to keep track of which employees are responsible for

promoting them.

State any assumptions of business rule

Answer 1

The ER diagram to keep track of potential customers for new products is: In this diagram, we have three entities: Employee, Potential Customer and New Product. Each entity is having its own attributes as provided in oval shapes connected to them. The relationship between entities is described by using diamond shapes between two entities. This is a database used to capture the new products features and other information. The assumptions for this business rule are:

1. The business is based on the instant price collection for the new products when serviced or delievered to the customer.

2. The customers can return the new products within 24 hours of purchase.