Answered: earch activities. As a co

Database System Concepts

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

See similar textbooks

Related questions

Question

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) who runs the department. Professors work in one or more departments, and for each department that they work in, a time percentage is associated with their job. Graduate students have one major department in which they are working on their degree. Each graduate student has another, more senior graduate student (known as a student advisor) who advises him or her on what courses to take.

Answer the following questions;

c. FOSCO is contemplating the possibility of creating a suitable software to improve the overall performance of the system. For the purpose of this software, FOSCO will have computer sites located at various four satellite campuses across the country i.e. (Accra, Kumasi, Ho and Takoradi). At each of these sites, we expect frequent access to the Staff and student’s information for the Staff who work on that campus. Further, we assume that these sites mainly access the First Name, Last Name, SSN, Sex and Address attributes of Staff. The Site at the headquarters houses a copy of the complete database and accesses all Staff information including salary (since salary is processed at the main campus office) and students’ information regularly, in addition to keeping 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 at least the records of three entities and attributes for FOSCO.

iii. Do you agree that the software will help improve operational efficiencies in the college? Discuss, which aspect of your proposed software solutions will help the college.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions