assignment

by

 

  1. Jestors Magic Website (Part 2): Database Design
    Overview
    This assignment consists of two sections: a proposal, and MySQL database. You must submit both sections as separate files for the completion of this assignment. You are only to demonstrate the specific requirements requested.
    Imagine that your proposal of creating the e-Commerce website for Jestors Inc. has been approved, and you are hired to complete the website and database design and development. The Jestors Inc. management team has decided to use MySQL. They have asked that you name the Database “Jestors” and they want it to contain multiple tables that will be used to keep track of customers. They are confident that you will be able to create all of the needed tables but ask that you include a table for the products and one that will be used for customer feedback. The table for customer feedback should include the following fields: date, time, sender, and message content.
    Instructions
    Section 1: Database Design Proposal
    Write a 23 page proposal in which you:
    1. Create a proposal that describes the naming and creation of the tables used in the Jestors database. The tables should include but not limited to:
      1. One table that contains the product list.
      2. One table for customer feedback. Note: The table contains the following fields: date, time, sender, and message content.
    2. Explain the relationship between the tables.
    3. Define the data types that will be used to create the tables.
    4. This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.
      Section 2: MySQL Database
      Create the database and tables that you proposed in the first section of the assignment using MySQL. Note: Screenshots are required for the completion of this section of the assignment. If you use Window 7, use the built-in SnipIt tool or capture a screenshot using the print screen button on the keyboard.
    5. Insert at least three records into the table that will contain the product list. Provide screenshots of the completed commands.
    6. Insert at least three records into the table that contains the customer feedback. Provide screenshots of the completed commands.
    7. The specific course learning outcome associated with this assignment is:
    • Create a database for a website based on design specifications.