Global Computer Solutions (GCS) is an information technology consulting company with many offices throughout the United States. The company’s success is based on its ability to maximize its resources—that is, its ability to match highly skilled employees with projects according to region. To better manage its projects, GCS has contacted you to design a database, so GCS managers can keep track of their customers, employees, projects, project schedules, assignments, and invoices. The GCS database must support all of GCS’s operations and information requirements. A basic description of the main entities follows: The employees of GCS must have an employee ID, a last name, a middle initial, a first name, a region, and a date of hire recorded in the system.Valid regions are as follows: Northwest (NW), Southwest (SW), Midwest North (MN), Midwest South (MS), Northeast (NE), and Southeast (SE).Each employee has many skills, and many employees have the same skill.Each skill has a skill ID, description, and rate of pay. Valid skills are as follows: Data Entry I, Data Entry II, Systems Analyst I, Systems Analyst II, Database Designer I, Database Designer II, Java I, Java II, C++ I, C++ II, Python I, Python II, ColdFusion I, ColdFusion II, ASP I, ASP II, Oracle DBA, MS SQL Server DBA, Network Engineer I, Network Engineer II, Web Administrator, Technical Writer, and Project Manager. Table P5.11a shows an example of the Skills Inventory. TABLE P5.11ASKILLΕMPLOYEΕData EntrySeaton Amy: Williams Josh; Underwood TrishData EntrySystems Analyst iSystems AnalystDB DesignerDB Designer lWilliams Josh Seaton AmyCraig Brett; Sewell Beth: Robbins Erinç Bush Emily: Zebras SteveChandler Joseph: Burklow Shane: Robbins ErinYarbrough Peter; Smith MaryYarbrough Peter Pascoe JonathanKattan Chris: Ephanor Victor, Summers Anna; Ellis MariaJavalJavaKattan Chris: Ephanor Victor: Batts MelissaSmith Jose; Rogers Adam; Cope LeslieRogers Adam Bible HanahZebras Steve Ellis MariaZebras Steve: Newton ChristopherC++C++PythonPython IIColdfusionDuarte Miriam Bush EmilyColdfusion IlBush Emily: Newton ChristopherASPIDuarte Miriam Bush EmilyASP IIDuarte Miriam: Newton ChristopherOracle DBASmith Jose; Pascoe JonathanYarbrough Peter, Smith JoseBush Emily: Smith MaryBush Emily: Smith MaryBush Emily: Smith Mary: Newton ChristopherKilby Surgena; Bender LarryPaine Brad; Mudd Roger: Kenyon Tiffany: Connor SeanSQL Server DBANetwork EngineerNetwork EngineerWeb AdministratorTechnical WriterProject Manager

Answered: Global Computer Solutions (GCS) is an…

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

Global Computer Solutions (GCS) is an information technology consulting company with many offices throughout the United States. The company’s success is based on its ability to maximize its resources—that is, its ability to match highly skilled employees with projects according to region. To better manage its projects, GCS has contacted you to design a database, so GCS managers can keep track of their customers, employees, projects, project schedules, assignments, and invoices.

The GCS database must support all of GCS’s operations and information requirements. A basic description of the main entities follows:

The employees of GCS must have an employee ID, a last name, a middle initial, a first name, a region, and a date of hire recorded in the system.
Valid regions are as follows: Northwest (NW), Southwest (SW), Midwest North (MN), Midwest South (MS), Northeast (NE), and Southeast (SE).
Each employee has many skills, and many employees have the same skill.
Each skill has a skill ID, description, and rate of pay. Valid skills are as follows: Data Entry I, Data Entry II, Systems Analyst I, Systems Analyst II, Database Designer I, Database Designer II, Java I, Java II, C++ I, C++ II, Python I, Python II, ColdFusion I, ColdFusion II, ASP I, ASP II, Oracle DBA, MS SQL Server DBA, Network Engineer I, Network Engineer II, Web Administrator, Technical Writer, and Project Manager. Table P5.11a shows an example of the Skills Inventory.

TABLE P5.11A
SKILL
ΕMPLOYEΕ
Data Entry
Seaton Amy: Williams Josh; Underwood Trish
Data Entry
Systems Analyst i
Systems Analyst
DB Designer
DB Designer l
Williams Josh Seaton Amy
Craig Brett; Sewell Beth: Robbins Erinç Bush Emily: Zebras Steve
Chandler Joseph: Burklow Shane: Robbins Erin
Yarbrough Peter; Smith Mary
Yarbrough Peter Pascoe Jonathan
Kattan Chris: Ephanor Victor, Summers Anna; Ellis Maria
Javal
Java
Kattan Chris: Ephanor Victor: Batts Melissa
Smith Jose; Rogers Adam; Cope Leslie
Rogers Adam Bible Hanah
Zebras Steve Ellis Maria
Zebras Steve: Newton Christopher
C++
C++
Python
Python II
Coldfusion
Duarte Miriam Bush Emily
Coldfusion Il
Bush Emily: Newton Christopher
ASPI
Duarte Miriam Bush Emily
ASP II
Duarte Miriam: Newton Christopher
Oracle DBA
Smith Jose; Pascoe Jonathan
Yarbrough Peter, Smith Jose
Bush Emily: Smith Mary
Bush Emily: Smith Mary
Bush Emily: Smith Mary: Newton Christopher
Kilby Surgena; Bender Larry
Paine Brad; Mudd Roger: Kenyon Tiffany: Connor Sean
SQL Server DBA
Network Engineer
Network Engineer
Web Administrator
Technical Writer
Project Manager

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 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