Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. Given the follwing a table OFFICE-STAFF OfficeID Office JobID JobTitle Salary Phone years Employ OfficeLoc OfficeManager Name No. In Job Name Acct. Prog 32

image text in transcribed
4. Given the follwing a table OFFICE-STAFF OfficeID Office JobID JobTitle Salary Phone years Employ OfficeLoc OfficeManager Name No. In Job Name Acct. Prog 32 150 15 John LA Lee Acct. 2 Analyst 32 150 6 John LA Smith Mkt Prog 10 120 Robert NY Kelly HR Prog 10 120 Kim INY Smith HR 2 Analyst 10 120 2 Kim NY Smith HR Prog 15 140 Petter NY Smith 41. make the table in the format : table_name (attribute], attribute2, ...) and assuming all possible FDs are implied by the given data. Background informtion: a project may include several tasks to be done by employees. A project may have a few managers. 42. List all functional dependencies (FDs) 43 Define the key for this table based on given data. 44. State the normal form this table is currently in, give your justification 45. How many themes are in this table? What are they? Describe an anormaly this table may have? 45. How do you normalize it? Show tables. Underline the PK and italize FK

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

Information Technology Project Management

Authors: Kathy Schwalbe

6th Edition

978-111122175, 1133172393, 9780324786927, 1111221758, 9781133172390, 324786921, 978-1133153726

More Books

Students also viewed these General Management questions