Task 0
The first task is to create your business narrative . Some of the questions that you should address include ( but are not limited to ) the following .
· What is the name of your business ?
· Who will be the users of the system ( managers , employees , customers )?
· What product ( s ) and or service ( s ) does it sell ? Be specific .
· Who are the customers ? What is the customer base ?
· What sales and distribution channels are used ?
· How are payments made ?
· Are products delivered or shipped to customers in some way ?
· Are sales reps involved ? Are they paid on commission ?
· What type of reports are needed by the business ?
Please include as much detail as possible in order to provide a foundation for Task 1 . Submit your proposal as a Word document . Note that this proposal may be revised in the coming weeks as your understanding of the database modeling process grows .
Task 1
Develop a detailed logical model of your database based on your business scenario submitted for Task 0 . Your data model will include an entity-relationship diagram ( ERD ) developed with Microsoft Visio or MySQL and a data dictionary ( DD ) developed with Microsoft Excel .