GCS has many customers. Each customer has a customer ID, name, phone number, and region. GCS works by projects. A project is based on a contract between the customer and GCS to design, develop, and implement a computerized solution. Each project has specific characteristics such as the project ID, the customer to which the project belongs, a brief description, a project date (the date the contract was signed), an estimated project start date and end date, an estimated project budget, an actual start date, an actual end date, an actual cost, and one employee assigned as the manager of the project. The actual cost of the project is updated each Friday by adding that week’s cost to the actual cost. The week’s cost is computed by multiplying the hours each employee worked by the rate of pay for that skill. The employee who is the manager of the project must complete a project schedule, which effectively is a design and development plan. In the project schedule (or plan), the manager must determine the tasks that will be performed to take the project from beginning to end. Each task has a task ID, a brief task description, starting and ending dates, the types of skills needed, and the number of employees (with the required skills) needed to complete the task. General tasks are the initial interview, database and system design, implementation, coding, testing, and final evaluation and sign-off. F

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

GCS has many customers. Each customer has a customer ID, name, phone number, and region.
GCS works by projects. A project is based on a contract between the customer and GCS to design, develop, and implement a computerized solution. Each project has specific characteristics such as the project ID, the customer to which the project belongs, a brief description, a project date (the date the contract was signed), an estimated project start date and end date, an estimated project budget, an actual start date, an actual end date, an actual cost, and one employee assigned as the manager of the project.
The actual cost of the project is updated each Friday by adding that week’s cost to the actual cost. The week’s cost is computed by multiplying the hours each employee worked by the rate of pay for that skill.
The employee who is the manager of the project must complete a project schedule, which effectively is a design and development plan. In the project schedule (or plan), the manager must determine the tasks that will be performed to take the project from beginning to end. Each task has a task ID, a brief task description, starting and ending dates, the types of skills needed, and the number of employees (with the required skills) needed to complete the task. General tasks are the initial interview, database and system design, implementation, coding, testing, and final evaluation and sign-off. For example, GCS might have the project schedule shown in Table P5.11b.

TABLE P5.11B
PROJECT ID: 1
DESCRIPTION: SALES MANAGEMENT SYSTEM
COMPANY: SEE ROCKS CONTRACT DATE: 2/12/2018
REGION: NW
START DATE: 3/1/2018 END DATE: 7/1/2018
BUDGET: $15,500
START DATE END DATE TASK DESCRIPTION
SKILLIS) REQUIRED QUANTITY
REQUIRED
3/1/18
3/6/18
Initial interview
Project Manager
Systems Analyst I
DB Designer
DB Designer
Systems Analyst I
Systems Analyst i
1
3/11/18
3/15/18
Database design
1
System design
3/11/18
4/12/18
1
2
3/18/18
3/25/18
3/22/18
5/20/18
Database implementation
Oracle DBA
1
System coding and testing
Javal
2
Java II
Oracle DBA
3/25/18
6/10/18
System documentation
Final evaluation
6/7/18
Technical Writer
6/14/18
Project Manager
Systems Analyst I
DB Designer
Java II
6/17/18
6/21/18
On-site system online and data loading Project Manager
Systems Analyst i
DB Designer
Java II
7/1/18
7/1/18
Sign-off
Project Manager

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

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