BusinessRules and Data Models
BusinessRules and Data Models
Colleges,similar to other institutions, have a large amount of data that theymay want to collect and manage. Creating a database can help collegesachieve this goal, thereby collecting large amounts of datapertaining to students, departments, instructors, and courses. Someof the business rules that might affect the overall structure of thedatabase include the application-oriented and database-oriented rules(Hernandez, 2013). The information included in the database will beinfluenced by the type of model adopted, which may include thephysical or conceptual data model.
Purposeof the database
Themain purpose of the college database is to help the school managementin collecting data about different courses offered by the college, astudent’s performance, and instructor’s progress in deliveringthe course content. The database will also help the management bycollecting any other data on courses, students, and instructors. Inaddition, the database will help the management in organizing thedata, increases the accessibility, management, and facilitate theprocess of updating the data.
Thecollege database will compose of four major entities, which includedepartment, course, instructor, and student. These entities havedifferent types of relationships. For example, a single departmentcan offer many courses, but a given course can only be offered by asingle department. Each department has many instructors, but eachinstructor belongs to a single department. A single course isenrolled by many students, and a single student can enroll for manycourses. Each course is taught by a single instructor, but eachinstructor can teach more than one course.
Departmentname is the attribute for the entity, department since it can be usedto identify the department uniquely. Course ID is the mostappropriate attribute for the entity named course. Student_ID is theattribute for the entity named student. Instructor_ID is theattribute for the entity named instructor. There are other relevantattributes that may be included. Location can be used an additionalattribute for the entity named department. The course_name andduration are additional attributes for the entity named course.First_name, last_name, and phone_number are additional attributes forthe entity named instructor. Phone, last_name, and first_name areadditional attributes for the entity named student.
Businessrules that could impact the structure of the database
Businessrules impact the structure of the database by imposing constraints onsome features of the database, including the elements in a givenfield of specification or characteristics of a certain relationship(Benjamin, 2014). There are two types of business rules that canaffect the structure of the college database. First,database-oriented rules will impose some constraints that the collegecan in the logical design of the college database. This will requirethe college to implement the constraints by modifying different fieldspecification relationships characteristics, elements, or both, whichwill in turn affect the structure of the database (Hernandez, 2013).The application-oriented rules impose constraints that the collegecannot be determined within a logical design. This implies that theconstraints should be established in the physical design of thecollege database.
Conceptualand physical database models
Theconceptual database model is applied in strategic project, whichrepresents information in an abstract form. This type of modelincludes information that gives a description of the entireorganization or the enterprise (Karen, 2014). This model may alsocontain relationship that exists between the entities. The physicaldatabase model, on the other hand, includes information that gives adescription of the data requirements of a single application orproject, or even a section of the application (Karen, 2014).
Inconclusion, developing a database is one of the strategies that canhelp the college collect and manage information more effectively. Afunctional college database should contain data pertaining tocourses, students, departments, and instructors. The college shouldtake account of the application-oriented and database-orientedbusiness rules.
Benjamin,I. (2014). What are business rules? E-Tutorials.Retrieved January 14, 2015, fromhttp://etutorials.org/SQL/Database+design+for+mere+mortals/Part+II+The+Design+Process/Chapter+11.+Business+Rules/What+Are+Business+Rules/
Hernandez,J. (2013). Databasedesign for mere mortals: A hands-on guide to relational databasedesign.Boston: Addison-Wesley.
Karen,L. (2014). What are conceptual, logical, and physical data models?InfoAdvisor.Retrieved January 14, 2015, fromhttp://blog.infoadvisors.com/index.php/articles/what-are-conceptual-logical-and-physical-data-models/