db211 - unit 11 - formal recommendation
TRANSCRIPT
Global Computer Solutions
Database Recommendation
By
Database Functionality
• GS Managers can track all aspects of projects, including:– Employees: Make Assignments, track skills, billable
time, and rates.– Customers: Generate schedules, show progress, and
bill weekly hours.– Schedules: Project delivery dates, determine tasks,
and display status.– Assignments: Create tasks for each employee,
require time entry, generate reports for customers.– Invoices: Determine costs, work completed, and bill
customers for work.
Database Functionality (cont.)
• GS Managers can manage regular billing to customers.– Determine tasks being scheduled, work in
progress, and bill hours already completed.
• GS Manager can manage employee skills– Track employee skills, billable rates, and
assign available employees to projects.
Database Model
Database Structure
Database Structure (cont.)
Database Structure (cont.)