Data Model

Data Model Our thought process for the data model is as follows. First, we set up a team list which contains all of the teams offered at Chatham, along with a code to ID each team. We also linked each team to the semester that they are in season for. This connects to the Course Catalog based upon the semester in which the class and sport interfere. Thus, this connects the teams to the player’s courses. Also, each team roster lists the player along with an ID, and a list of each course they are in. This allows for a connection to the course with the title of the course (or course code) highlighting in both categories. To get into the master schedule of the sporting teams, this allows you to take the code of each team which then highlights every player along with schedules. This allows the observation of the times of games/travel along with the course times and how they overlap/when they overlap. This type of system makes it easier for students and teachers to be knowledgeable of when sports events will impact a student's attendance in class. In order to elaborate on the explanation of our model, it is important to recognize some key words that relate to the model that we created. In simple terms, our book recognizes the importance of rows, columns and characters within a table. Rows refer to records, columns refer to fields, and characters within the table refer to bytes. The book continues its explanation of a database by stating, "...values in one table relate rows of that table to rows in the second table" (Kroenke, 115). An example of a row in our data would be the course ID found within our course catalog. These rows are then linked to the student number that is signed up for that particular class. Then, that student ID is linked to the sports team table and we are able to recognize when the students sporting events will overlap that particular course time and so on. This makes it a very cohesive system in order to keep track of students sporting events and the class times that will be effected by the schedule. Overall, databases are important for various reasons when gathering and sorting large amounts of information. According to the Database PowerPoint presented by Doctor Chung, it stated that data models are useful when "organizing and keeping track of things and keeping track of multiple themes" (Chung, 4). When many tables are created, we are able to define relationships among these tables which is why this model is so efficient. We are able to link student's sporting events to their schedules, without the hassle of getting signatures and keeping track of dates. References Chung, Rachel (2018). Database PowerPoint Presentation [1-42]. Retrieved from https://moodle.chatham.edu/course/view.php?id=14384 Kroenke, D. M. (2014). MIS essentials. Boston: Pearson.