CASE STUDY- SOFTWARE FOR OLA COLLEGE OF EDUCATIONFosu College of Education (FOSCO) is one of the colleges of education in Ghanaknown for its significant drives for quality education in Ghana. The college have asoftware that keep records of all academic records of the college. In recent times,management descried to outsource and develop a state-of-the-art software which willkeep all the relevant records of the college's research activities. As a consultant, thefollowing information about a college database was outlined to you during theproject initiation state and requirement stage:Professors have an SSN, a name, an age, a rank, and a research specialty. Projectshave a project number, a sponsor name (e.g., GETFUND), a starting date, an endingdate, and a budget. Graduate students have an SSN, a name, an age, and a degreeprogram (e.g., M.S. or Ph.D.). Each project is managed by one professor (known asthe project's principal investigator). Each project is worked on by one or moreprofessors (known as the project's co-investigators). Professors can manage and/orwork on multiple projects. Each project is worked on by one or more graduatestudents (known as the project's research assistants). When undergraduate studentswork on a project, a professor must supervise their work on the project. Students canwork on multiple projects; in which case they will have a (potentially different)supervisor for each one. Departments have a department number, a departmentname, and a main office. Departments have a professor (known as the chairman)who runs the department. Professors work in one or more departments, and for eachdepartment that they work in, a time percentage is associated with their job. Graduatestudents have one major department in which they are working on their degree. Eachgraduate student has another, more senior graduate student (known as a studentadvisor) who advises him or her on what courses to take.Answer the following questions;a. As a software engineer, develop an appropriate requirement analysis of thecase. You may note any unspecified requirements from the scenario, and makeappropriate assumptions to make the specification complete.b. Draw the following diagrams to depict the scenario towards the developmentof the system:i.Flowchartii.The Context Level Diagramiii.Entity Relationship Diagramiv.Data Flow Diagram for FOSCO specifying the key attributes of eachentity type, and the structural constraints on each relationship type.Use case diagram for the caseV. c. FOSCO is contemplating the possibility of creating a suitable software toimprove the overall performance of the system. For the purpose of thissoftware, FOSCO will have computer sites located at various four satellitecampuses across the country i.e. (Accra, Kumasi, Ho and Takoradi). At eachof these sites, we expect frequent access to the Staff and student's informationfor the Staff who work on that campus. Further, we assume that these sitesmainly access the First Name, Last Name, SSN, Sex and Address attributesof Staff. The Site at the headquarters houses a copy of the complete databaseand accesses all Staff information including salary (since salary is processedat the main campus office) and students' information regularly, in addition tokeeping track of students' project information.i.Using an appropriate software development technique of your choice,discus how you will implement this scenario within six weeks.ii.Draw an appropriate Graphical User Interface (GUI) form to capture atleast the records of three entities and attributes for FOSCO.iii. Do you agree that the software will help improve operationalefficiencies in the college? Discuss, which aspect of your proposedsoftware solutions will help the college.

a.) As being a software engineering i would be making the requirement on the basis of the front-end…

CASE STUDY-SOFTWARE FOR OLA COLLEGE OF EDUCATION Fosu College of Education (FOSCO) is one of the colleges of education in Ghana known for its significant drives for quality education in Ghana. The college have a software that keep records of all academic records of the college. In recent times, management descried to outsource and develop a state-of-the-art software which will keep all the relevant records of the college's research activities. As a consultant, the following information about a college database was outlined to you during the project initiation state and requirement stage: Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., GETFUND), a starting date, an ending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). Each project is managed by one professor (known as the project's principal investigator). Each project is worked on by one or more professors (known as the project's co-investigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project's research assistants). When undergraduate students work on a project, a professor must supervise their work on the project. Students can work on multiple projects; in which case they will have a (potentially different) supervisor for each one. Departments have a department number, a department name, and a main office. Departments have a professor (known as the chairman)

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE