Overview

Your Online Database Architecture for Education $($YODAE$)$ is a start$-$up company with fewer than $40$

employees. The company has been growing since its founding five years ago. YODAE$$s original mission

was to provide educators and schools with cloud$-$based databases and systems that improve classroom

management and create more engaging student learning experiences. YODAE$$s board of directors

realized that the company could increase its revenue if it offered more services and products. YODAE

started selling internet of things $($IoT$)$ devices as the market demand for the IoT increased. These devices

easily connect to the cloud$-$based systems already in use. Now, YODAE$$s mission has expanded to IoT

devices.

Client and User Needs

YODAE aims to meet the organizational needs of its clients, which include K$12$ educators, school

administrators, and IT professionals who work in the education sector. These three kinds of

professionals will use cloud$-$based systems, databases, and IoT devices to better manage classrooms and

school environments. Some of these technologies can also improve the learning experience for children

ages six and older.

YODAE$$s clients have expressed that they want databases and IoT devices that address the following

needs:

$$ Databases

$$ Keep track of student$-$to$-$teacher relationships.

$$ Include details about teachers and students.

$$ IoT devices

$$ Help students sitting in the back of the classroom see and hear what$$s on the

whiteboard.

$$ Allow students to participate in class by raising their hands via a handheld device.

$$ Integrate into school and classroom settings in a way that doesn$$t violate student

privacy.

$$ Improve school security by restricting IoT data access to certain school staff.

Products

YODAE offers the following IoT products to K$12$ schools:

$$ Voice$-$activated virtual personal assistants $($VPAs$)$: Teachers and all school staff use these IoT

devices. They have a calendar, voice activation for users to ask questions and connect to the

internet for answers, and a lesson plan creator that connects to the cloud.

$$ Mini handheld student devices: These devices allow teachers and students to connect virtually

in the classroom. They offer unique features like a button students can use to raise their hands

and notify teachers through their VPAs.

$$ IoT smart fire alarms: These devices can be mounted in classrooms and hallways. Users can

determine which fire alarm sound is set. Alarms connect to administrators$$ VPAs, so they know

where the alarm went off.

$$ IoT smart bicycles: Students can ride these bikes during recess or after school. The bicycles keep

track of the distance a student rides and include a location feature that notifies administrators if

a student rides outside of school property.

$$ IoT whiteboards: These electronic whiteboards include educational games that students can

play for specific lessons.

$$ IoT smart speakers: These devices help students sitting in the back of the classroom hear what$$s

displayed on the IoT whiteboard. These speakers are also mounted in hallways and outdoors so

people can hear messages from the main office.

$$ IoT smart cameras: These devices have artificial intelligence $($AI$)$ face$-$recognition technology.

They can be mounted in hallways and classrooms to monitor behavior.

$$ Interactive control lecterns: These devices allow presenters to interact with the whiteboard.

$$ Smart projectors: These devices allow presenters to show papers and documents on a big

screen.

$$ Individual smart desks: These desks connect to the interactive control lectern. They encourage

students to engage with software or interactive on$-$screen activities.

$$ In$-$demand collaboration software: This software is used with screens on devices with screens.

$$ Smart locks: These locks use chip cards for entry.

$$ Motion sensors: These sensors are mounted at entrances and outside administration offices.

$$ Backup system: The backup system enables continued use through power or internet loss.

Create an ERD that represents student$-$ and teacher$-$information data. The ERD must show the cloud database system architecture as part of the cloud$-$based database design. 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:

All of the appropriate entities: What entities described in the business scenario does the ERD need to include?

All of the appropriate attributes: What are at least five attributes for each entity?

Necessary relationships: How will the relationships between the entities be accurately presented in the diagram?

Explanation of Entity Relationship Diagram: Write $25$ paragraphs about how your diagram meets the needs of YODAE and its clients. Briefly explain the entities, attributes, and relationships depicted in your diagram.