For this assignment, you will be diagramming a simple relational database, sometimes called a database schema. This assignment will be the first step in understanding how data is organized in a relational database.
Background
We have learned that the most common type of database is the relational database. No matter what area of Information Technology or Cybersecurity you work in, you will encounter a relational database at some point. This assignment is not intended to make you professional database designers. Rather, it will help you to recognize a relational database so that later in the course, you understand how a relational database can be protected.
Instructions
NOTE: The schema you complete in this assignment will be used in Lab 1.
Use the following Set of Requirements to create your schema. After each field name, enter the data type you think would be correct for the data that will be entered (e.g., for the field ‘HireDate’ show it in your diagram as HireDate (Date):
Two tables: Person and CourseInstructor
Person will have the following fields:
ID (primary key) (Note: Lab 1 uses this fieldname, however PersonID might be better for understanding.)
FirstName
LastName
HireDate
EnrolmentDate
PersonType (Note: values would be Student, Instructor, or Staff)
CourseInstructor will have the following fields:
CourseID (primary key)
InstructorID (Note: Lab 1 uses this fieldname, however PersonID might be better for understanding.)
Be sure to identify the primary key and the relationship line in your diagram!
Using the given set of requirements, create your relational database schema using any application you are familiar with (Access, Word, PowerPoint, Visio, Draw, etc.) [Note: Consider creating a free account at drawSQL (https://drawsql.app). It is easy to create tables and it allows students to show data types/attributes, primary keys, and relationship lines, etc.]
Convert your final one-page schema into PDF format.