Design a relational database and create the database onto a cloud-based server using PHPMyAdmin.

Competency

Compare the development and architecture processes.

NOTE - This course requires the creations of a single Bitnami server for several deliverables. If this has not been completed, please refer to the "Prerequisite for Deliverables 3-7" page earlier in the Course Project Section.

Scenario

You work as a developer for Solutions Inc. Your client, Universal Widgets, is planning to implement a cloud-based solution for their IoT (Internet of Things) connected devices. These devices are designed to monitor air quality in a home for the homeowner's heating and air system. These devices also are able to detect the carbon dioxide levels, presence of smoke, and notify homeowner's when to change the air filters.

Along with other information, the development company has also supplied you with a Sample Database Data spreadsheet.

Instructions

Develop a proof worksheet in Microsoft Word that details the following elements:

• Relational Database Design
  • Include the relational database design based on the information found in the sample database. The relational database design should include all tables, relationships, primary and foreign keys.

The following sections are to be completed using the PHPMyAdmin tool and your cloud-based server. Proof of this work will be pasted as code and screenshots in a Word document as directed below.

In a Microsoft Word document, address the following using clear headings to explain what each item represents:

• Write the code in the PHPMyAdmin tool that will create the database using your first and last name as the title with no spaces.
  • Paste a copy of the code in your Word document

Complete the following section for each table in the relational database design

• Write the code in the PHPMyAdmin tool that will create the table in your relational database design.
  • Paste a copy of the code in your Word document
• Write the code in the PHPMyAdmin tool that will add at least three records to this table.
  • Paste a copy of the code in your Word document
• Write the code in the PHPMyAdmin tool that will display all the records within this table.
  • Paste a copy of the code in your Word document
  • Paste a screenshot of the result in your Word document