Assignment 1: Business rules and Data Models
CIS 111: Introduction to Relational Database Management Systems 01/20/2015
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 teach would be an impact. The amount of students allowed in each course would be an impact. If there are too many students for one class but not enough students for two classes that would create a problem. The students would have to either prolong their time for the course or the institution would have to find more students to fill the second class. There will be many different constraints in the database. An example of a constraint is one if the students' GPA will have to be between 0.00 and 4.00. Another example would be that each class can only have one instructor. There would be a constraint on the social security number ensuring that there are only nine numbers and in the format is xxx-xx-xxxx, and each individual number would be between 0 and 9. There would be a constraint for the telephone numbers as well. Each individual number would be between 0 and 9 in the format of (xxx)-xxx-xxxx. Conceptual vs. Physical Model
The conceptual model will have all of the attributes from the students as well as the instructors. It will also have the all of the constraints. This model will have software and hardware independency. At this level any changes to the database management system will not affect this model. The physical model will take all the information that comes from the conceptual model and describe it so that it can be saved and stored. This model will need to know the physical storage device and access method so that it can reach the information stored in the devices. The physical model, not like the conceptual, will be both software and hardware dependency.
There are many different components that would go into making this database for this college. There are attributes, constraints, business rules that have to be written, the type of relationship and the different models. Each level help put the stepping stones to move to the next. It would be very detailed and not until I get the exact information on what the school is requesting would I be able to finalize on the system.
Cited: Coronel, Carlos; Morris, Steven; Rob, Peter. Database Systems; Design, Implementation, and
Management, 10th edition. 2013 Course Technology, Cengage Learning. Pgs. 5-56.
Please join StudyMode to read the full document