Answered step by step
Verified Expert Solution
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
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,4Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started