Answered step by step
Verified Expert Solution
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
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
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