Consider a fictitious online grocery store called Wow Munchies. This is a national franchise, complete with marketing, accounting, shipping, and customer service departments. The CIO has decided to update the database corresponding to the Web store so that it collects pertinent transaction and shopping information for the different departments. She is undecided what software or hardware will support this database.

Step l. How will you determine what data is important to collect and maintain in the new database? Be specific.

Step 2. Create surveys, questionnaires, and the like, and administer them to appropriate personnel in the affected departments.

Review the forms that each department uses.

Step 3. What kind of responses did you get? Go to an online grocery store, and see what data is being collected by “rival” companies.

Did you miss anything? Did any of the responses you get require a secondary meeting with department personnel? If so, revise your surveys and questions and reinterview.

Step 4. Utilize the methods you outlined in the above question, and ascertain the entities and attributes you will need to include in your data.

Step 5. Draft the relationships and cardinality between the entities. What kind of data model are you using? Implementation specific or nonspecific? Why?

Step 6. Revise your data model so that there are no many-to-many relationships, and the model is normalized to third normal form.

Step 7. Submit all questionnaires, surveys, forms, and responses to your professor, along with your final data model draft. Include a short explanation as to how you derived your entities and attributes and the relationships and any assumptions or limitations your data model may have.