Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Instructions Answer each question based on the instructions for that question, referencing the JOB table and its sample data. For context, the JOB table describes

Instructions Answer each question based on the instructions for that question, referencing the JOB table and its sample data. For context, the JOB table describes truck driving jobs at a trucking company. Normalization Exercise (30 pts) [Trucking Company] Normalization: Dependency Analysis and Relational Schemas. Use the JOB table below. JOB table driver_id first_name last_name age license_class 1 Michael Johnson 25 CDL20 2 license_details Gross weight up to 20 tons truck_id truck_name rate 101 2 Emily Brown 35 CDL30 Gross weight up to 30 tons 102 $ Delivery Blue Transfer Orange $ job_date 1.10 2020-05-29 3 3 David Lee 41 CDL40 Gross weight up to 40 tons 103 Deep Freeze 1 $ 2.20 2.50 2020-06-27 2020-07-11 2 Emily Brown 35 CDL30 Gross weight up to 30 tons 101 Delivery Blue $ 1.70 2020-05-28 4 1 Michael 4 Maria Johnson Davis 25 32 CDL20 CDL40 Gross weight up to 20 tons Gross weight up to 40 tons 104 102 Transfer Green $ Transfer Orange $ 1.65 2020-06-17 2.50 2020-06-20 5 12 1 6 points Write the relational schema for 1NF. Make sure to identify any keys using bold, italics, underlines, etc., as appropriate. BIUA A xx, EE 12pt Paragraph eme driver age license class license detail truk id truck name ich rate iob datel

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

Simplifying Finance And Accounting Function

Authors: Mr. Dauji Gupta

1st Edition

9353467276, 978-9353467272

More Books

Students also viewed these Accounting questions