Description
IT 423 Module Two Project One Milestone Guidelines and Rubric
Overview
Entity relationship diagrams (ERDs) represent the data portion of a cloud-based database. This is why ERDs are often used as a tool to communicate how information is stored in a database. Being able to describe what goes into a specific database (entities, attributes, and relationships) ensures that you end up creating a cloud database that actually supports organizational operations. You want to avoid creating a database that stores irrelevant data.
For the purposes of this assignment, imagine that you are a solutions architect at a start-up organization, Your Online Database Architecture for Education (YODAE). To provide some context, YODAE is an educational technology company that is quickly growing and scaling its services. Its cloud solutions are used by teachers, educators, and administrators in the K–12 education industry. In order to implement a cloud-based system that meets YODAE’s clients’ needs (in this case, schools), you will design the cloud database.
Prompt
For this activity, you will create an ERD that will represent student-information and teacher-information data. To successfully complete this activity, you will need to:
Review the YODAE Business Case (THE CASE IS ATTACHED BELOW): Review the business case document to gain a better understanding of YODAE, and of how your cloud solution will meet its organizational needs and operations.
Create an Entity Relationship Diagram: As part of the design of the cloud-based database, create an ERD to show the architecture of the cloud database system. To create your ERD, refer to this example (THE EXAMPLE IS ATTACHED BELOW) that already includes some components of your diagram. You must add to this diagram by including the following components:
All of the appropriate entities: What are the entities that need to be included in the ERD that are described in the business scenario?
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?
Explain Your ERD: Write 2 to 5 paragraphs about how your diagram meets the needs of YODAE and its clients. You are required to provide a brief explanation about the entities, attributes, and relationships depicted in your diagram.
What to Submit
Upload a file that contains your ERD. You may use Lucidchart, Visio, or another software application of your choice to create your diagram. The file you upload should either be in a .doc or .pdf format. Do not submit the Lucidchart or Visio file that you created. Select All of the elements of the ERD from within the application you used to create it, and copy and paste into a Word or PDF document prior to submitting it for assessment.
Unformatted Attachment Preview
IT 423 YODAE ERD Example
For the entity relationship diagram (ERD) example, note that each entity (table) can have more
YODAE
ERD
EXAMPLE
attributes added to it, but the ones shown below
must
be included
as they are for use later in this
project. Your diagram should have a one-to-many relationship shown in crow’s foot notation with the
relationship line above. (For more information about this notation, go to Crow’s Foot Notation.)
Students
PK
student_id
first_name
last_name
dob
entry_year
Courses
PK
course_id
name
year_req
IT 423 Project One Business Case
Your Online Database Architecture for Education (YODAE)
Organizational History and Mission
YODAE is a start-up company that has fewer than 40 employees. The organization kicked off in 2017 and
has been growing in size since. The original mission of YODAE was to provide educators and schools with
cloud-based databases and cloud systems to better manage classrooms and to create more engaging
learning experiences for students. As YODAE grew as an organization, the board of directors realized
that they could increase their revenue if they offered more services and products. As the market
demand for the internet of things (IoT) increased, YODAE started to sell IoT devices. These devices easily
connect to the cloud-based systems that are already in use. Now, YODAE’s mission has expanded to IoT
devices.
Client/User Needs
As a start-up, YODAE strives to meet the organizational needs of its clients: K-12 educators, school
administrators, and IT professionals who work in the education sector. These three kinds of
professionals will be using the 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 6 and older. These are needs that YODAE’s clients have expressed:
●
●
●
●
Database to keep track of student to teacher relationships
Database should include details about teachers and students.
IoT devices that allow for students who sit in the back of the classroom to see what’s on the
whiteboard, and allow students to participate in class by raising their hands via a handheld
device
IoT devices should be integrated into school and classroom settings in a way that doesn’t violate
student privacy, but these devices should also improve school security. For example, not all
school staff should have access to IoT data.
Products
The IoT products that YODAE offers to K-12 schools are:
●
●
●
●
●
Voice Activated Virtual Personal Assistants (VPAs) for teachers and all school staff to use. This
IoT has a calendar, voice activation for users to ask questions and connect to the internet for
answers, and a lesson plan creator for users to create lesson plans in a cloud.
Mini Handheld Student Devices that connect to teachers’ VPAs. These devices allow teachers
and students to connect virtually in the classroom, and offer such unique features as a button
where students can raise their hands and the teacher is notified through their VPA.
IoT Smart Fire Alarms to be included in classrooms and hallways. With these alarms, 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 for students to ride during recess or after-school hours. The bicycle keeps
track of the distance a student rides the bike, and includes a location feature in case a student
rides outside of school property.
IoT Whiteboards that serve as electronic whiteboards and include educational games that
students can play for specific lessons
●
●
●
●
●
●
●
●
●
IoT Smart Speakers that make it easier for students who sit in the back of a classroom to hear
what’s displayed on the IoT Whiteboard. They are also in hallways and outdoors, in the event
that the main office has a message.
IoT Smart Cameras with AI face-recognition technology that can be mounted in hallways and
classrooms to monitor behavior
Interactive Control Podium for presentations and interactions with the whiteboard
Smart Projector to show papers and documents on a big screen
Individual Smart Desks that connect to the Interactive Control Podium to encourage students to
engage with software or interactive on-screen activities
In-Demand Collaboration Software for use with student and teacher screens. It can also work
with the VPAs.
Smart Locks using chip cards for entry
Motion Sensors for entrances and outside administration offices
Backup System for power loss and internet loss
Purchase answer to see full
attachment
