Question: Assignment Instructions: Create a logical database design for the construction company data in the attached Excel file. Your logical design must be in Third Normal

Assignment Instructions:

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.

Assignment Instructions: Create a logical database design for the construction company data

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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). example PROJ_NUM PROJ_NAME Evergreen 15 Amber...

Assignment Instructions: 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...

Overview Rick and Morty is an animated, comedic, science-fiction television series that premiered in the United States in December of 2013. Rick and Morty has received near-universal critical acclaim...

A.3. Scenario, Background and Tasks Scenario need to submit the data modelling phase for this assignment by The implementation phase needs to be completed and submitted by Choice Appointments is a...

I wanted to see if I could get some help with creating this logical design database. The entities I have come up with are: Technicians, Customers, Chemicals, and Transactions. I'm not sure if they...

IDS 4 1 0 Business Database Technology Individual Assignment # 2 ( database design ) Logical Database Design for a Simple Restaurant System Due: Submit your solution file to the Blackboard by 1 1 : 5...

How would one create deliverable 1 in 3rd Normal form? Thanks! CIS3050-03 Project 1 - Protected View- Saved to this PC ApacheWarloed OfTheSouth-X File Home Insert Draw Design Layout References...

How would one create deliverable 3 a fully functioning entity relationship diagram with subtypes and supertypes? Thanks! CIS3050-03 Project 1 - Protected View- Saved to this PC ApacheWarloed...

How would one create deliverable 2 with business rules being added? Thanks! CIS3050-03 Project 1 - Protected View- Saved to this PC ApacheWarloed OfTheSouth-X File Home Insert Draw Design Layout...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

When bunting, a baseball player uses the bat to change both the speed and direction of the baseball. (a) Will the magnitude of the change in momentum of the baseball before and after the bunt be (1)...

CFA An analyst gathered the following data about stocks J, K, and L, which together form a value-weighted index: Stock Price c December 31, Year 1 K Shares Outstanding $40 10,000 $30 6,000 $50 9,000...

Which of these is a correct statement about LIRP withdrawals? A ) They are subject to required minimum distribution ( RMD ) rules. B ) They are not used in the Social Security provisional income...

A Treasury bill with 81 days to maturity is quoted at 90.543. What is the percentage effective annual return?

2. How did business and political interests influence what early intercultural communication researchers studied and learned?

4. Explain the strengths and weaknesses of each approach.

1. Identify four early foci in the development of intercultural communication.