CIS 111
Week 2 Assignment 1
Jerrell L. Jackson
January 14, 2018
Strayer University
Professor Otto
Purpose of database
The purpose of the database is to track students, the courses they take and the instructors teaching each of the classes. The database will help manage students and instructor’s data including assignments, grades, and historical data. Existing literature shows higher levels of student engagement and learning when faculty uses active and collaborative learning techniques (Umbach and Wawrzynski, n.d). The database will capture information relevant for faculty to monitor student grades and to track instructors teaching courses. The database will help ensure it monitors the grades of students and instructors.
Business Rules and Data Models
Educational institutions generate and consume a lot of operational information. These institutions must track information about people including students, instructors and other faculty members who play key functions in supporting their services and programs. Databases allow institutions to use and manage incredible a wide variety of information. This is an important aspect of information management, the exploitation of data, information and knowledge
…show more content…
Generally, data modeling entails three levels: conceptual, logical and physical data models. Conceptual data model is the initial step in data modeling and entails all major entities and relationships but does not have detailed level of information related to attributes. Therefore, the conceptual model for the course database would feature entity names and entity relationships. The physical data model describes the way data is stored or saved in a given media. It stipulates the storage devices and the methods of accessing stored data. Therefore, physical data model depends on both the hardware and the