Database is a highly significant tool when applied and verified to anorganization’s management. In the recent past, numerous colleges’managements have seen the need to proffer effectual and comprehensivedatabases to track information regarding students and their financesand the roles or job descriptions of teaching and non-teaching staff.One of the functions of a database in a collage is to arrange andkeep the student information in system files. The database keeps theinformation of the student regarding their performance, feesstructure and the courses or units they students undertake. Inaddition, the database is crucial in that it ensures the security ofa college’s data. Only those people who have consent to access thedata are permitted to have access thus, the capacity to keep theinformation confidential. On the other hand, the information storedin the database is not easy to manipulate since not everybody hasaccess to the data. In fact, a database allows a college or anadministration to cultivate the most possible confidential tools forinformation.
One can describe an entity of a database as any tool that anorganization can utilize to store information necessary for the dailyrunning of an organization. In this regards, an entity contains thelist of activities of all the subject fields in which information ismaintained. Some examples of data entities in a collage includeemployees and students i.e. in a college database for maintaining theinformation of a student, the application should have the data suchas the date the student joined the college, status of the student,course undertaken, performance of the student, and the graduationdate for the student. On the other hand, if a college develops adatabase of information about lectures, the entity should have theinformation on age, salary, the time the lecturer was hired, whetherthe lecturer is still in college, the department in which thelecturer teaches and department manager of the lecturer. Theattribute is the property that describes the relationship between theentities. For example, in the above example, the lecturer and thestudents are the entities and the attributes are the names, ages,courses, departments, salaries, and the performances.
Some business rules in a collage can determine the association of thedatabase, for example, in a college divided into various schools suchas school of business, arts, and education or school of appliedsciences, the dean of such schools provide the significant link withstudents and the school. Another example is in schools with severaldepartments, for example, in some colleges, the school of businesshas the department of accounts, finance, and economics, where thecardinality rule asserts that the smallest number of the departmentis one and the largest is intermediate. On the other hand, eachsingle school has only one department thus, the minimum number of adepartment as one gives cardinality, which is also the maximumnumber.
Conceptual data model acts as a summary data model, which peoplemostly use on premeditated projects. It has the characteristics of awide range of concepts of businesses as it makes the objectivity of abusiness to the audience explicitly. On the other hand, a conceptualmodel has connections between entities although it does notnecessary encompass a cardinality. Physical data model is a modelthat is dependent upon a specific and a given version of datapersistence technology. It has features that allow approaches to giverequirement of data for one project or the application. Moreover, onecan integrate the model among other physical data models through arepository of shared entities.