Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Database Management Help. Please don't copy-paste because i already looked them up and i did not understand. please keep it as simple as possible. this

image text in transcribed

Database Management Help.

Please don't copy-paste because i already looked them up and i did not understand.

please keep it as simple as possible. this is confusing to me.

thank you!

Table name: RPT_FORMAT PROJ NUM PROJ NAME EMP NUM 15 Evergreen 103 101 105 106 32.4 102 Amber Wave 114 118 104 112 Rolling Tide 105 104 113 111 106 Starflight 115 101 114 108 118 112 EMP NAME June E. Arbough John G. News Alice K. Johnson * William Smithfield David H. Senior Annelise Jones James J. Frommer Anne K. Ramoras* Darlene M. Smithson Alice K. Johnson Anne K. Ramoras Delbert K. Joenbrood Geoff B. Wabash William Smithfield Maria D. Alonzo Travis B. Bawangi John G. News Annelise Jones Ralph B. Washington James J. Frommer Darlene M. Smithson Database man 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.50 23.8 $105.00 19.4 $105.00 35.7 $35.75 12.6 $96.75 23.8 $48.10 24.6 $18.36 45.3 $96.75 $45.95 44.0 $105.00 64.7 $96.75 48.4 $48.10 23.6 $26.87 22.0 $35.75 12.8 $35.75 24.6 $96.75 45.8 $105.00 $48.10 33.1 $96.75 23.6 $18.36 30.5 $45.95 41.4 25 107 56.3 Consider the table above. Identify the tables in their current normal forms (1, 2, 3 or no forms). Follow the stepwise process an normalize the table and create a relations between the tables. You are only responsible up to 3NF. Show step by step process. Create dependency diagrams Use conventional methods (all caps) to write the table name, primary key/s, functional dependencies, partial dependency and transitive dependency. Purpose: Comprehend the normalization concept and implement in designing database. SLO: 1,4 Table name: RPT_FORMAT PROJ NUM PROJ NAME EMP NUM 15 Evergreen 103 101 105 106 32.4 102 Amber Wave 114 118 104 112 Rolling Tide 105 104 113 111 106 Starflight 115 101 114 108 118 112 EMP NAME June E. Arbough John G. News Alice K. Johnson * William Smithfield David H. Senior Annelise Jones James J. Frommer Anne K. Ramoras* Darlene M. Smithson Alice K. Johnson Anne K. Ramoras Delbert K. Joenbrood Geoff B. Wabash William Smithfield Maria D. Alonzo Travis B. Bawangi John G. News Annelise Jones Ralph B. Washington James J. Frommer Darlene M. Smithson Database man 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.50 23.8 $105.00 19.4 $105.00 35.7 $35.75 12.6 $96.75 23.8 $48.10 24.6 $18.36 45.3 $96.75 $45.95 44.0 $105.00 64.7 $96.75 48.4 $48.10 23.6 $26.87 22.0 $35.75 12.8 $35.75 24.6 $96.75 45.8 $105.00 $48.10 33.1 $96.75 23.6 $18.36 30.5 $45.95 41.4 25 107 56.3 Consider the table above. Identify the tables in their current normal forms (1, 2, 3 or no forms). Follow the stepwise process an normalize the table and create a relations between the tables. You are only responsible up to 3NF. Show step by step process. Create dependency diagrams Use conventional methods (all caps) to write the table name, primary key/s, functional dependencies, partial dependency and transitive dependency. Purpose: Comprehend the normalization concept and implement in designing database. SLO: 1,4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database And SQL

Authors: Lucy Scott

3rd Edition

1087899699, 978-1087899695

More Books

Students also viewed these Databases questions

Question

What is profit-linked productivity measurement and analysis?

Answered: 1 week ago

Question

1. Does your voice project confidence? Authority?

Answered: 1 week ago