BUSINESS RULES AND DATA MODELS 4
BusinessRules and Data Models
BusinessRules and Data Models
Collegesmay decide to implement database because of the large amount of datathey have. The organization of work isin a database withthe help ofsoftwarecalled “Database Management System”. Datain college involves unprocessed facts regarding students names. Theyear they were born. Gender, admission number, parents or guardiansnames. County they come from, nationality, the language they speak athome, for instance, English or Irish. Contact address telephone orphone number, the address for their parents, their averageperformance of every exam and the year of admission to college(Zandbergen,2016).
Theprimarypurpose of the database system through the help of Data ManagementSystem is to function as a warehouse of data and transform the realinformation into facts inform of information which helps in makingthe decisionfor the college management. As a result, Data Management Systempossessesthe following three elements: physical database, database engine andlastly is the data scheme (Zandbergen,2016).
Theabove data is turned into information through a process torealizeparticular outcome. The process to achieve this needs knowledge asfar as the guidelines, rules, procedures ability to manipulate andorganize is concerned. Hence becoming suitable for a given task needsto be performed. All theserules,data collection, relationships long with procedures get their home inthe application of knowledge.
Concerningthe above, informationin the databasemust have the following characteristics: the data must be accurateinformation that is correctis always error free. Forinstance,the spelling of names is correct. Second, the data must be completeinformation that is full is the one that bears all the relevant factsregarding a particulartopic about students. Third, economical, before the college comes upwith the idea of collecting data it should ensure that the wholeprocess is inexpensiveand not very expensive for them to afford. Fourth,information must be flexible, data characterized by flexibility canserve all round. Not just serve one purpose. Also,the information should be reliable hence being dependable and notlies. Furthermore, when collecting the information,then the college must ensure that the information is relevant and canbe helpful during decision making. Similarly, the information has tobe timely,therefore,being available when the management needs it. Lastly, the informationhas to be verifiable and so being accurate (Kirkwood,2016).
Astatementthat puts some form of restriction regarding the database is calledbusiness rule. It is formed basing on how an organization runs theirbusiness or functions. A Vitalfeature of any project process is through making a choice. Fordatabase design, for instance,one must be in a position to choose the type of data to warehouse inthe database the college should not store everything concerning thestudents’ life. The datawilldepend on how the universityfunctions.
Anexampleof the business rules can include: student with less than 40 percentin any given unit should sit the supplementaryexam. Students with an averageof 40 percent and above should begivena pass. Lastly, students owning the college more than 10 percent ofthe fee should not sit the exam.
Theconceptual model may include the following data: the date ofadmission, students’ address and year of study. While the physicalmodel may include: portraits of students, home county and contactaddress (VisualParadigm, 2015).
Kirkwood,H. P. (2016, May). DataProcessing and Management.Retrieved from Reference for Business:http://www.referenceforbusiness.com/management/Comp-De/Data-Processing-and-Data-Management.html
VisualParadigm. (2015, January 15). Conceptual,Logical and Physical Data Model.Retrieved from Visual Paradigm:https://www.visual-paradigm.com/support/documents/vpuserguide/3563/3564/85378_conceptual,l.html
Zandbergen,P. (2016, June). Whatis a Database Management System? – Purpose and Function.Retrieved from Study.com:http://study.com/academy/lesson/what-is-a-database-management-system-purpose-and-function.html