CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 39
·
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.
Note that your deliverables each week include any revisions to the
previous task.