Database management software

Free essays 0 Comments

Databasemanagement software

Databasemanagement software

In recent years, there has been an increase in the wave oftechnological advancements. Institutions such as have foundthemselves in states where they have huge data sets, those ofemployees, students and the day to day activities run (Detert, KOPEL,Mauriel, &amp Jenni, 2014). The huge amount of informationinstitutions has negated the need to have an elaborate databasemanagement software that seeks to improve the manner in whichoperations are conducted. In the same regard, Birchwood Lane Schoolshave the mandate to have a DBMS model that seeks to align themanagement of data in the institution. The board of the school shouldtake measures that will see to it that data management is effective.Birchwood Lane has various data and information requirements. Forexample, they are dealing with large data sets, that are numeric,textual and they all come in different formats. For the same reason,it becomes vital to have a DBMS that is capable of meeting therequirements (Galliers, &amp Leidner, 2014). Also, the decision tohave the DBMS system at Birchwood Lane is to ensure that there is anelaborate framework of operations in the school as pertains to schoolactivities.

Proposal for a Conceptual DBMS

A proposal for a potential DBMS model to be used at Birchwood Lane isdepicted. The model depicts the manner in which students, theircredits, tutors and the department relate to each other. Thetechnology provided by the DBMS seeks to smoothen operations and themanner in which the data is handled (Ramakrishnan, &amp Gehrke,2000). For example, the data ensures that the student information iskept in an appropriate manner. Their results are also kept in anorderly manner such that it can easily be retrieved. The model isdesigned in such a way that there is a relationship between thefaculty and the individual departments to avoid overlaps. Informationabout the tutors is included in the model and the subjects that theyteach.

Dept.

Position

Department

Dept.

Credit

s

ENROLLMENT

Department

Year

GPA

FACULTY

Outlineof the logical model

The DBMS is designed in such a way that each faculty within theschool has a systematic way in which they store information. The nameof the faculty is stated and the corresponding departments that fallwithin it are stipulated. Each department handles particular courses.In each department, there are students who take given courses and thenames of tutors teaching them stipulated. The DBMS also hasinformation about the enrollment of students, year and the coursesthey are undertaking. Information about the GPA points is alsostipulated alongside the position of each student in class. Theinformation contained in each section of the DBMS, however, doesrelate to what is contained in the school records (Pifia, 2013).

Importanceof the logical aspects

The model seeks to consolidate information of students, tutors andthe courses they undertake. It serves to group particular students totheir respective faculties and departments.

Main elements for implementation

It is vital to have software developers and programmers design asoftware that consolidates all the information in the respectivefaculties.

The team will be given information of faculties, departments and thatof the students and the same used to design the DBMS model.

Upon completion, users will be trained on how to go about the use ofthe system. It will include tutors, administrators and the students.

Justification

The DBMS meets the information needs of Birchwood Lane since itconsolidates data about the students, tutors and the courses offered.Retrieval of such information is made easier by the presence of themodel.

Closing statement

Birchwood Lane needs a system that streamlines activities within theschool. Adopting the DBMS model is one of conforming to technologicaladvancements aimed at improving operations in the school.

References

Detert, J. R., KOPEL, M. E. B., Mauriel, J. J., &amp Jenni, R. W.(2014). Quality Management in US High Schools: Evidence from theField1, 2. Jsl Vol 10-N2, 10, 158.

Galliers, R. D., &amp Leidner, D. E. (2014). Strategicinformation management: challenges and strategies in managinginformation systems. Routledge.

Pifia, A. A. (2013). Learning management systems: A look at the bigpicture. Learning management systems and instructional design:Best practices in online education, 1.

Ramakrishnan, R., &amp Gehrke, J. (2000). Database managementsystems. Osborne/McGraw-Hill.