As for a local college database, the purpose of the database will be to house the data of enrolled students, the courses offered and times available, and the information of the faculty. The database can provide possible course matches for each student based off of previous courses taken and pre-requisites obtained, as well as keep track of the professors teaching each course. The database will provide the data a student needs to insure they are taking the correct courses and provide the college and the faculty general student information, such as contact information.
Entities are defined as a person, place, thing, or event in which data is collected and stored. Each entity is a unique and distinct object that may be a physical or abstract object within the real world (Coroner, Morris, Rob, pig. 34). Entities of a database for a college that needs to keep track of students and courses would be students, professors, courses, classes, room, and enrollment status. These entities will be used to format the data within the database so that each student and course is accounted for.
Attributes are characteristics of an entity, such as a name, phone number, or address (Coroner, Morris, & Rob, pig. 34). Attributes for the college database would include student first and last name, student phone number, student address, student identification number, student grade point average, student course major, and dent classes to describe the student entity. The professor entity would be described by professor first and last name, professor phone number, professor address, professor identification number, and professor courses and classes being taught.
The course entity would include the courses identification number, the course name, and course credits. The class entity would include class identification number, the course identification number, professor identification number, and the room identification number. The room entity would include the room identification number and the type of room. The enrollment entity would include the class identification number and student identification number.
Each of these entities will help to ensure the security of the database, due to each entity only having a subset of the data, damage to part of the database will not affect all of the data (Coroner, Morris, & Rob, pig. 54). Business rules are brief and precise descriptions of procedures within an organization. These rules help to create and enforce the actions of an organization’s operations (Coroner, Morris, & Rob, pig. 35).
Effective business rules are rules that are easily understood, so as to ensure that every person shares a common interpretation of the rules (Coroner, Morris, & Rob, pig. 36). Possible business rules that would impact the college database would be: A student is able to take up to 20 hours of classes, a room can only be used for one class during a specific time, a class may only be taught by one professor, a student must meet pre-requisites to take classes that require them, and a student must be enrolled to register for classes.
These would impact the college database by providing guidelines to prevent students from taking too many classes at one time, as well as prevent a classroom from hosting two r more classes on the same day at the same time. Other benefits are that professors will know which class they are teaching and they will know that the students in the class have met certain requirements to be in the class. The conceptual model represents a global view of the entire database, integrating entities, relationships, constraints, and processes into a single global view of the data (Coroner, Morris, & Rob, pig. 4). The conceptual model provides an overview of the entities within the college database and how they correspond with each other. In the conceptual model, the student entity would have a one-to-many legislations to the enroll entity, while the enroll entity would correspond to the class entity with a many-to-one relationship. The class entity would have a many-to-one relationship with the professor entity, the room entity, and the course entity.
The student enrolls in classes that are taught by one professor, use a room, and correlate to one course. The physical model is the lowest level of abstraction, which describes the way data are saved on storage media. The physical model requires both a physical storage device and a physical access method to reach the data within the storage devices, making it both software ND hardware dependent. The storage structures that are used depend on the software and on the type of storage devices that the computer can handle.
Cite this Business Rules and Data Models
Business Rules and Data Models. (2018, May 25). Retrieved from https://graduateway.com/business-rules-and-data-models/