2-2 Project One Milestone 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

3

Uploaded by SuperHumanDolphin2076

Report
Jennifer Christensen IT-423 – Computing as a Science 2-2 Project One Milestone July 10, 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 5 determined 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, and device id. The teacher table will include teacher id, first and last name, phone number, 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.
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

Related Documents

Lab 11 Answer Template Ph1.docx
Lab 11 Student and TA Instructions.docx
5-2 Project One Christensen.docx
8-2 Project Two Christensen.docx
5-2 activity revise question.docx
TakeHomeExam-1_CPRE_414.pdf
homework5.pdf
homework4.pdf
3-1 Activity Christensen.docx
Homework1.pdf
Assignment 3_Fall_2023.pdf
Assignment_4_DataAnalytics_Fall2023.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
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
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
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
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
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
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