IT 423 Project 1
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
423
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
5
Uploaded by PrivateBraveryEmu1997
IT 423 Project 1
David Wells
2/7/2024
Here is my ERD (Entity Relationship Diagram) that I came up with based on the case study. You can see that there are various entities in these tables. These entities include students, instructors, courses, departments, IoT Devices, and VPA.
The purpose of this diagram is to show the layout of the database and the relationship between the different entity attributes. Each entity has a set of attributes that allow them to relate
to other entities. The students attributes include student id, which is unique to each student, first name, last name, their date of birth, the year they enrolled in school or what year they are (k-12), and any important information about that student in their student detail section. Instructors have similar attributes specific to them. The main unique attribute being instructor id. Instructors also
have course id, dept id, and vpa id. These show what classes and departments that the instructor belong to and which VPA they have access to
The unique attributes are utilized as Primary Keys (PK) in the database. This is so multiple tables can relate to one another forming the database. That way when you perform a query on a PK like student id, not only will you get the student information, but also the related information in other tables to are related to that student.
Here you can see I have the running EC2 Instance
I have connected Wordpress to EC2 Instance
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
Here is Wordpress running on EC2 Instance
Here are screenshots of the tables