· 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.
Note that your deliverables each week include any revisions to the previous task.
Submit your Task 1 deliverable as a zip file including the following.
· Task 0 proposal( with any revisions or updates)
· Your ERD copied to a Word document that fits on a single 8 x 10 page
· Your DD( Excel file) Task 2