Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use Excel Sheet to work with tables The deadline/requirements of the submission will be provided by the instructor Bluewater Construction Company Consider the simplified

image text in transcribed

Use Excel Sheet to work with tables The deadline/requirements of the submission will be provided by the instructor Bluewater Construction Company Consider the simplified database activities of a construction company that manages several building projects Each project has its own project number, name, assigned employees, and so on. Each employee has an employee number, name, and job classification, such as engineer or computer technician. The company charges its clients by billing the hours spent on each contract. The hourly billing rate is dependent on the employee's position. For example, one hour of computer technician time is billed at a different rate than one hour of engineer time. Periodically, a report is generated that contains the information displayed in Figure 1. Complete the following: Lambton College Database Design & SQL CSD 2206 1. Create an un-normalized tabular format (flat spreadsheet-like table) from the report format| 2. Convert to 1NF: a. Each cell contains a single value b. Identify the primary key 3. Convert to 2NF: a. Identify the partial dependencies b. Convert tables to 2NF (table form and relational schema) by eliminating partial dependencies 4. Convert to 3NF: a. Identify the transitive dependencies Fo

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

Data Communications and Networking

Authors: Behrouz A. Forouzan

5th edition

73376221, 978-0073376226

More Books

Students also viewed these Computer Network questions

Question

\(\Sigma \ln A_{k}=\ln \Pi A_{k}\) (a) True (b) False

Answered: 1 week ago

Question

14. Let X be uniform over (0, 1). Find E[X|X Answered: 1 week ago

Answered: 1 week ago