EMP_NUM EMP_NAME June E. Arbough PROJ_NUM PROJ_NAME JOB_CLASS CHG_HOUR HOURS Elect. Engineer Database Designer Database Designer 15 Evergreen 103 84.5 23.8 101 John G. News 105 19.4 105 Alice K. Johnson 105 35.7 106 William Smithfield Programmer Systems Analyst Applications Designer 48.1 General Support 35.75 12.6 102 David H. Senior 96.75 23.8 18 Amber Wave 114 Annelise Jones 24.6 118 James J. Frommer 18.36 45.3 Anne K. Ramoras Darlene M. Smithson DSS Analyst Alice K. Johnson Anne K. Ramoras 104 Systems Analyst 96.75 32.4 112 45.95 44 22 Rolling Tide 105 Database Designer 105 64.7 Systems Analyst Delbert K. Joenbrood Applications Designer 48.1 Clerical Support 104 96.75 48.4 113 23.6 111 Geoff B. Wabash 26.87 22 106 William Smithfield Programmer 35.75 12.8 25 Starflight 107 Maria D. Alonzo Programmer 35.75 24.6 Travis B. Bawangi Systems Analyst Database Designer 115 96.75 45.8 101 John G. News 105 56.3 114 Annelise Jones Applications Designer 48.1 33.1 Ralph B. Washington Systems Analyst General Support 108 96.75 23.6 118 James J. Frommer 18.36 30.5 112 Darlene M. Smithson DSS Analyst 45.95 41.4

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
icon
Related questions
Question
  • Create a logical database design for the construction company data in the attached Excel file.
  • Your logical design must be in Third Normal Form (3NF).
  • Document your logical design using SQL Create Table statements as shown in Figure 4-6 on page 162 of the textbook.
PROJ_NUM PROJ_NAME
JOB_CLASS
Elect. Engineer
CHG HOUR HOURS
EMP_NUM EMP_NAME
June E. Arbough
15
Evergreen
103
84.5
23.8
101
John G. News
Database Designer
105
19.4
105
Alice K. Johnson
Database Designer
105
35.7
106
William Smithfield
Programmer
35.75
12.6
David H. Senior
Systems Analyst
Applications Designer 48.1
102
96.75
23.8
18
Amber Wave
114
Annelise Jones
24.6
118
James J. Frommer
General Support
18.36
45.3
Anne K. Ramoras
Darlene M. Smithson DSS Analyst
104
Systems Analyst
96.75
32.4
112
45.95
44
22
Rolling Tide
105
Alice K. Johnson
Database Designer
105
64.7
Anne K. Ramoras
Systems Analyst
Delbert K. Joenbrood Applications Designer 48.1
104
96.75
48.4
113
23.6
111
Geoff B. Wabash
Clerical Support
26.87
22
106
William Smithfield
Programmer
35.75
12.8
25
Starflight
107
Maria D. Alonzo
Programmer
35.75
24.6
Travis B. Bawangi
Systems Analyst
Database Designer
115
96.75
45.8
101
John G. News
105
56.3
114
Annelise Jones
Applications Designer 48.1
33.1
Ralph B. Washington Systems Analyst
James J. Frommer
108
96.75
23.6
118
General Support
18.36
30.5
112
Darlene M. Smithson DSS Analyst
45.95
41.4
Transcribed Image Text:PROJ_NUM PROJ_NAME JOB_CLASS Elect. Engineer CHG HOUR HOURS EMP_NUM EMP_NAME June E. Arbough 15 Evergreen 103 84.5 23.8 101 John G. News Database Designer 105 19.4 105 Alice K. Johnson Database Designer 105 35.7 106 William Smithfield Programmer 35.75 12.6 David H. Senior Systems Analyst Applications Designer 48.1 102 96.75 23.8 18 Amber Wave 114 Annelise Jones 24.6 118 James J. Frommer General Support 18.36 45.3 Anne K. Ramoras Darlene M. Smithson DSS Analyst 104 Systems Analyst 96.75 32.4 112 45.95 44 22 Rolling Tide 105 Alice K. Johnson Database Designer 105 64.7 Anne K. Ramoras Systems Analyst Delbert K. Joenbrood Applications Designer 48.1 104 96.75 48.4 113 23.6 111 Geoff B. Wabash Clerical Support 26.87 22 106 William Smithfield Programmer 35.75 12.8 25 Starflight 107 Maria D. Alonzo Programmer 35.75 24.6 Travis B. Bawangi Systems Analyst Database Designer 115 96.75 45.8 101 John G. News 105 56.3 114 Annelise Jones Applications Designer 48.1 33.1 Ralph B. Washington Systems Analyst James J. Frommer 108 96.75 23.6 118 General Support 18.36 30.5 112 Darlene M. Smithson DSS Analyst 45.95 41.4
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Top down approach design
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education