Assignment 3 JestorsMagic Website (Part 2) – Database

Assignment 3: Jestor’sMagic Website (Part 2) – Database Design Thisassignment consists of two (2) sections: a proposal, and MySQLdatabase. You must submit both sections as separate files for thecompletion of this assignment. You are only to demonstrate the specificrequirements requested. Imagine that your proposal of creatingthe e-Commerce Website for Jestors Inc. has been approved, and you arehired to complete the Website and database design and development. TheJestors Inc. management team has decided to use MySQL. They have askedthat you name the Database “Jestors” and they want it to containmultiple tables that will be used to keep track of customers. They areconfident that you will be able to create all of the needed tables butask that you include a table for the products and one that will be usedfor customer feedback. The table for customer feedback should includethe 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 tablesused in the Jestor’s database. The tables should include but not limitedto: i. One (1) table that contains the product list ii.One (1) table that is for customer feedback. Note: The table containsthe 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. Your assignment must follow these formatting requirements: Betyped, double spaced, using Times New Roman font (size 12), withone-inch margins on all sides; references must follow APA orschool-specific format. Check with your professor for any additionalinstructions.Include a cover page containing the title of theassignment, the student’s name, the professor’s name, the course title,and the date. The cover page and the reference page are not included inthe required page length.  Section 2: MySQL Database 2.Create the database and tables that you proposed in the first sectionof the assignment using MySQL. Note: Screen shots are required for thecompletion of this section of the assignment. If you use Window 7, usethe built in SnipIt tool or capture a screen shot using the print screenbutton on the keyboard. a. Insert atleast three (3) records into the table that will contain the productlist. Provide screen shots of the completed commands. b.Insert at least three (3) records into the table that contains thecustomer feedback. Provide screen shots of the completed commands. The specific course learning outcomes associated with this assignment are: Develop dynamic database driven Websites with PHP that include reading and writing data to databases.Describe and create processes that manipulate database records using PHP.Use technology and information resources to research issues in PHP.Writeclearly and concisely about advanced Web development topics usingproper writing mechanics and technical style conventions.

Posted in Uncategorized