Implementing A Relational Database : Defining The Components Of The Database Management System
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.
The resulting data model supports the interpretation of the maturation of the student within the school environment, and therefore structure business rules used to define the relational database supporting those interactions.…