Competency In this project, you will demonstrate your mastery of the following c

Competency
In this project, you will demonstrate your mastery of the following competencies:
Implement a cloud-based system that meets organizational needs
Interface with cloud-based databases to support organizational operations
Image of YODAE logo
Scenario
Imagine that you are a solutions architect at an educational technology start-up organization called Your Online Database Architecture for Education (YODAE). YODAE hired you to design its cloud database for teachers in the K–12 education system. The cloud-based IT system and database that you design will help teachers manage their classrooms and create online learning experiences for their students. The database should store information about teachers, students, and classrooms. For this project, you will design the architecture of the database system by creating an entity relationship diagram (ERD). Then you will implement your design by creating a cloud database system. The cloud database system’s architecture consists of a database, web server, webpage, and client- or server-side scripting.
Review the YODAE Business Case in the Supporting Materials section to learn about YODAE and how your cloud solution will meet the organization’s needs and operations. The Module Five Resources section includes links to technical support resources you may need to complete the assignment.
Directions
To complete this project, address the following rubric criteria:
1.Create an entity relationship diagram (ERD) that shows your cloud database system’s architecture. To create your ERD, refer to the YODAE ERD Example in the Supporting Materials section. This example already includes some components of your diagram. Add to this diagram by including the following components:
a. All of the appropriate entities: What entities described in the business scenario does the ERD need to include?
b. All of the appropriate attributes: What are five attributes for each entity?
c. Necessary relationships: How will the relationships between the entities be accurately presented in the diagram?
2.Entity Relationship Diagram Explanation: Write 2–5 paragraphs about how your diagram meets the needs of YODAE and its clients. Briefly explain the entities, attributes, and relationships depicted in your diagram.
You will create the architecture of the cloud-based application you designed in the AWS console through your AWS Educate account. To implement this, you are required to complete the following tasks:
3.Set Up Virtual Server: Create an EC2 instance by following these steps. Then be sure to properly install an Apache web server, PHP, and MySQL on the instance. Take screenshots to confirm that you have successfully created your EC2 instance and installed the appropriate language and database system.
4.Deploy a Front-End Component: Install WordPress on the instance that connects to your MySQL database. Be certain that you are using the AWS console through AWS Educate. Copy and paste the public URL to the instance to ensure that your instructor can assess your work.
5.Implement Database Tables: Install DataGrip and create the database tables that you designed in your ERD, which include all columns and keys. Take a screenshot to confirm that you have created the appropriate databases depicted in your ERD.
6.Data Manipulation: After you have installed the database plug-in and created your new database tables, manipulate the data by completing and taking screenshots of the following actions:
a. Insert some test data into each table.
b. Do a Select statement that shows only students registered to a specific course.
c. Show a Delete statement removing a course from the Courses table.
d. Show a statement that changes the entry_year for a particular student.
7. Interface with Database: Create a new page within the WordPress admin panel. To complete this successfully, you must follow the steps in the Database Interface Instructions in the Supporting Materials section. Be sure to include screenshots of the following items:
Your working WordPress admin page and the installed plug-in
The front-end form and view pages
Make sure to use your own name when adding a student.
What to Submit
To complete this project, you must submit the following items:
1.Entity Relationship Diagram: Use Lucidchart or a similar software application to create your diagram. The file you upload should either be a PDF, JPEG, or DOCX format.
2.Screenshots and Descriptions: Submit a Microsoft Word document containing 4–7 screenshots to show that you have successfully completed each step in the directions. For each screenshot, write a 1- to 3-sentence description that explains what the screenshot shows.
3.Public URL for the EC2 Instance: Include your public URL link in the document you submit.

Last Completed Projects