Answer Happy

Draw an ER diagram for the following use cases, capture each and every requirement in the usecases. Create the PK, UK, C(Composite)K, FK wherever it is needed. Each table should have at least 5 attributes with data types. a) The customer details information needs to be staged which also includes that one customer can be parent of another customer. Customer can do business with multiple warehouses b) Multiple contacts can be associated with customers and one contact is associated with the deal c) One customer can have multiple deals for multiple warehouses and a deal can also have multiple warehouses d) Deals include several products and some products are not transacted for certain warehouses e) Every product has a price in different currencies