When developing and implementing a relational database, defining the information and users of the system enable definition of the business rules defining the components of the database management system. An example can be evaluated through the use of a CRUD – create, retrieve, update and delete – matrix as it relates to student information and the individuals or departments related to the school that may require access. The resulting model will be used to interpret business rules and explain how they relate to the components of a relationship database model.
CRUD – Create, Retrieve, Update and Delete
Purdue (2014) suggests the use of the CRUD two-dimensional table to visually summarize data usages by function. In the student/school relationship model, one possible interpretation of this diagram has been modeled in Table 1. For each unique role within the school environment, access rights to student information may be defined based on whether the individual performing in a given role has a need to know as set forth by the Sarbanes-Oxley Act (Lunsford & Collins, 2008). Access within an online-transaction processing (OLTP) environment may be defined based on the concepts of create, retrieve, update and delete. …show more content…
These business rules support the definition of the primary components of the relational database storing this student and school information: a data dictionary, primary keys, foreign keys and integrity constraints. From a high-level, the model suggests Finance, Faculty and Student Advising have retrieve visibility to necessary aspects of the student information while Enrollment controls creation of the student record and student Records controls update and delete