5-2 Project One Christensen

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

423

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

11

Uploaded by SuperHumanDolphin2076

Report
Jennifer Christensen IT-423 – Computing as a Science 5-2: Project One July 30, 2022 ERD DIAGRAM
YODAE Database Entities The database for YODAE and its clients includes 5 entities – students, teachers, courses, IoT devices, and VPAs. These entities are important so the database collects, records, and stores relevant information. The database will store information about students, teachers, and courses offered. It will also store information about the IoT devices offered by YODAE and the virtual personal assistants used by teachers and staff. YODAE Database Attributes It is important that the database collect and store the correct information for the established attributes. Each entity has an established unique id number that will serve as the primary key for each table, for example student id for students. The student table will include student id, first and last name, date of birth, school entry year, course id, and device id. The teacher table will include teacher id, first and last name, phone number, course id, and VPA id. These attributes are similar since they are about the people within the school. The course table will include course id, course name, year required, classroom number, and course level. These attributes are required to track the correct course information since the same course can be taught by different teachers, in different locations, and at different educational levels. The IoT device table will include device id, device name, device location, device alert, and student id. These attributes will store the correct information for each IoT device as there are many around campus. The VPA table will include VPA id, voice alert, calendar, lesson plan, and teacher id. These attributes will store the correct information about the VPAs and the data generated by teachers utilizing them. YODAE Relationships There exist many relationships between the tables of data stored within the database. There is a one-to-many relationship established between students and courses, and teachers and courses. A student can take many courses and a teacher can teach many courses. There is a one-to-one relationship between students and IoT devices. A student has 1 IoT device assigned to them and only one. This relationship establishes student id as a foreign key in the IoT device table. There is also a one-to-one relationship between teachers and VPAs for the same reason. Teacher id is a foreign key in the VPA table. The last relationship is between IoT devices and VPAs. It is a many-to-many relationship as the VPAs and IoT devices can interact together. For example, the student devices connect to teachers’ VPAs, while the smart smoke alarms connect to the VPAs when there is a smoke alert.
Installed PHP on Instance: Here I have installed the PHP 7 on my instance. It is confirmed by the line “root@ip-172-31-82-200:/home/ubuntu# php -v PHP 7.2.24-0unbunto0.18.84.13. Installed MySQL on Instance: Here I have installed MySQL on my instance. It is confirmed by the command line mysql>
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Installed Wordpress on Instance: Here I have installed Wordpress on my instance. I installed the latest version, created the directory, and configured the database to match the MySQL setup. Deploy a Front-End Component: Public URL: ec2-44-203-146-89.compute-1.amazonaws.com/wordpress
Database Tables: Here I have created 5 tables in the phpMyAdmin plugin. The screenshot also shows the columns, primary key, and foreign key assigned to the table Students. Test Data in Table Courses:
Test Data in Table Students: Test Data in Table IoT_Devices:
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Test Data in Table Teachers: Test Data in Table VPAs:
Do a Select statement that shows only students registered to a specific course: Here it shows that students Luke and Leia are both registered for course MAT-101. Show a Delete statement removing a course from the Courses table: It shows that one row was affected so the Course table now has 4 rows instead of 5.
Show a statement that changes the entry_year for a particular student: Here I updated the entry_year for Han Solo to 2012 from the original input of 2011. Working WordPress admin page and the installed plugin: This is my Admin page for my WordPress site. This shows my active plugins.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Created Pages on Admin page of WordPress dashboard: Front-end view of Add Students page where new students’ information can be submitted.
Front-end view of View Students page where current student’s information can be viewed. Using the Add Students page I added my own information to the form.

Related Documents

Problem-Solving Skills_ Module 1 Writing Assignment.docx
geo3710 attributedata_lab7_pricePro2e-1-1.docx
5-3 quiz.docx
6-0 check your knowledge.docx
Lab 11 Answer Template Ph1.docx
Lab 11 Student and TA Instructions.docx
8-2 Project Two Christensen.docx
5-2 activity revise question.docx
TakeHomeExam-1_CPRE_414.pdf
2-2 Project One Milestone Christensen.docx
homework5.pdf
homework4.pdf
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS