Database design proposal, Create a proposal that describes

Database design proposal

Assignment Help Basic Computer Science

Reference no: EM132812077

Jestor's Magic Website : 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

Create a proposal that describes the naming and creation of the tables used in the Jestor's database. The tables should include but not limited to:

One table that contains the product list.

One table for customer feedback. Note: The table contains the following fields: date, time, sender, and message content.

Explain the relationship between the tables.

Define the data types that will be used to create the tables.

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.

Insert at least three records into the table that will contain the product list. Provide screenshots of the completed commands.

Insert at least three records into the table that contains the customer feedback. Provide screenshots of the completed commands.

The specific course learning outcome associated with this assignment is:

Create a database for a website based on design specifications.

Reference no: EM132812077

Questions Cloud

Demographic and psychographic data elements : Give some examples of demographic and psychographic data elements. Why would a marketer put decoy records on a database?

Concepts for object-oriented programming : You will be analyzing the basic concepts for object-oriented programming, how to create classes that contain attributes and different types of methods.

Discuss explanation of blockchain : Discuss your explanation of Blockchain to include why it has been gaining so much popularity.

Design-development and use of information systems : Discuss each of the different roles that people play in the design, development, and use of information systems.

Database design proposal : Create a proposal that describes the naming and creation of the tables used in the Jestor's database.

Key stroke logging : Keystroke logging often referred to as keylogging or keyboard capturing, is the action of recording (logging) the keys struck on a keyboard,

Windows Forensics : Outline the proper steps to be performed in examining a laptop computer for evidence of a crime.

Quest for higher performance accuracy : The quest for higher performance accuracy in the prediction of oil and gas characteristics.

Connecting to the physical network layer : Create a 6- to 8-slide presentation with visuals and speaker notes about how you are connected to the physical-network layer of the cyber domain.

User Account

All Pages