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