Assignment 3: Jestor’s Magic Website (Part 2) – Database Design

Assignment 3: Jestor’s Magic Website (Part 2) – Database Design Subject: Engineering Product: Assignment Writing Education Level: College Citation: APA References: 2 English: US Paper Length: 2 pages\550 words Deadline: November 28, 2014 Details: JUST DO THE PROPOSAL PART !!!!! Assignment 3: Jestors Magic Website (Part 2) Database Design This assignment consists of two (2) 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. Section 1: Database Design Proposal 1. Write a two to three (2-3) page proposal in which you: a. 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: i. One (1) table that contains the product list ii. One (1) table that is for customer feedback. Note: The table contains the following fields: date, time, sender, and message content b. Explain the relationship between the tables. c. Define the data types that will be used to create the tables. JUST DO THE PROPOSAL PART !!!!!