SEAR, Software Engineering for Academic Research, a non-existent non-profit dedicated to helping aspiring software engineers solve real world problems

To: Spring 2017 CS131 and CS170 student teams

Request for Proposal

For

A Database System to Generate Faculty Information Cards

Due Date/Time: February 26, 11:59 PM

I. Introduction

a.  The CS department must post Faculty Information Cards each
    semester outside the office where they sit. This project is to
    create a system to solve that need. A sample of the card is in
    Appendix A

b.  Proposals for this project must be received by email in PDF for
    before 11:59 PM at <dale.fletter@csus.edu>.

c.  Questions regarding this solicitation must be brought up in
    class so all bidders can hear the additional information. No
    emails or personal consultations outside of class will get a
    response.

d.  A student is expected to put in approximate 6 hours per week
    into the project work for this class. Your proposal must provide
    a total work hour estimate and this rough guide should be used
    both for your estimated effort and for your final summary. You
    must be truthful in your final report since the amount of effort
    above or below your estimate is an important metric for this
    agency.

II. Scope

a.  There are only two staff members involved; the office
    administrator and a clerk. The information about a faculty
    member should only be changeable by the office administrator.
    The entry of faculty office hours and the viewing of all
    information is allowed for the clerk. The only information that
    should be seen by anyone else (optional) it must be limited to
    the faculty information card itself.

b.  The system must be capable of printing all of the cards in one
    operation for the initial posting. It must also be capable of
    printing an individual card on request.

c.  All of the needed database maintenance screens to build and
    maintain the database are part of this project.

d.  An optional feature is to allow the generation for a new
    semester based on the information from the prior semester and
    keep both in the database.

e.  Another optional feature is to create a system that can serve
    more than one academic department. Note that each department has
    its own administrator and clerk. Only an administrator can setup
    a clerk. But any administrator can create a new academic
    department and grant authority to the admin or reset the
    password of another admin. But no admin should be able to
    directly see the data of a different department.

f.  The scope of work will depend upon your course.

    i.  If you are in CS131, you will be expected to produce a
        Systems Design Specification, a project plan for the
        construction phase, and a test plan that can be used to
        assess the quality of any construction.

    ii. If you are in CS170, your final deliverable will be a
        complete Systems Requirements Specification, SRS.

III. The Proposal

a.  The proposal must consist of two parts: the Vision and Scope
    document and the estimate of cost and effort. The Vision and
    Scope document must follow the outline given in the text
    Software Requirements 3e found on page 82. The estimate of cost
    and effort must include the name of the project team (your
    organization), the team members for your organization and their
    resumes, a suggested list of features you will use to begin your
    work given in the form of a product backlog list and the total
    number of work-hours your team will put in on this project
    before the final. This is a key part of the deliverable since
    you do not want to over or understate the time or the functions
    you will include.

IV. The Award

a.  If this were a commercial competitive bid, this section would
    describe the method by which this organization would choose
    between the various bidders. As a student project however we
    will allow everyone to create their own version of the
    deliverables for this project.

example 1 example 2