· 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
First , make sure to make any necessary revisions to your logical model based on Task 1 feedback . Using MySQL , write the statements to develop a physical model of your database by creating the tables and