In: Computer Science
You are required to create a sales and marketing management system with a small number of common sense attributes. The system should contain the following information Sales details Marketing details Customer details Production details Delivery details Management details So consider what sales and marketing system is required to deliver a consistent and customer oriented service to all customers over the world. You need to identify the tables you require and the information that they are to contain. This is only a small system, do not over-complicate it. 1. Design– Create an entity-relationship (ER) model drawn with MS WORD or POWER POINT if you prefer. You are required to submit a print out of your database schema: Set of normalised tables – with your sample data. Indicate the table relationships using multiple keys; PK, FK, and SK using UML notation.