Assignment 1: Business rules and Data Models
CIS 111: Introduction to Relational Database Management Systems

Purpose of Database
Spellman University had requested that I develop a database for their college. The purpose of the database will be to track the students and the courses. There also will be a place in the system to track the instructors teaching each course. There are many things to be considered in composing this database. This paper will outline the entities, attributes for each entity, the type of relationship, constraints, some business rules, and the conceptual and physical models.
Entities and Attributes of Database There will be three main entities in the system; the students, the instructors and the courses. The students’ attributes would be last name, first name, social security number, and phone number, date of birth, address, student ID, level of education, enrollment date, GPA, any standardized test scored, all accepted credits, and their class schedule. The attributes for the instructors would be last name, first name, teacher ID, salary, address, telephone numbers (and or extensions), certifications, degrees, and the course code that they will be teaching. The courses attributes would be a specific course code. Along with the course code each individual class would have to have a code as well. This would make the system easier to keep track of instead of having it spelled out next to either the instructors' or the student's name. The relationship of this database would be a many-to-many relationship. This would be because each class can be taken by many different students as well as a student can take many different classes making it M: N. (Coronel pg. 35)
Business Rules There are several business rules that would impact the database. It would be up to the college but the minimum and maximum amount of courses that each teacher can