Write the relational schema for 1NF. Make sure to identify any keys using bold, italics, underlines, etc., as appropriate.

Transcribed Image Text:

JOB table driver id first name last_name age license class 1 Johnson 25 35 2 3 41 Brown Lee Brown 35 Johnson 25 2 1 4 Davis 32 Michael Emily David Emily Michael Maria CDL20 CDL30 CDL40 CDL30 CDL20 CDL40 license details Gross weight up to 20 tons Gross weight up to 30 tons Gross weight up to 40 tons Gross weight up to 30 tons Gross weight up to 20 tons Gross weight up to 40 tons truck id 101 102 103 101 104 102 truck name Delivery Blue Transfer Orange Deep Freeze 1 Delivery Blue Transfer Green Transfer Orange job_date rate $ 1.10 2020-05-29 2.20 2020-06-27 $ $ 2.50 2020-07-11 $ 1.70 2020-05-28 $ 1.65 2020-06-17 $ 2.50 2020-06-20 JOB table driver id first name last_name age license class 1 Johnson 25 35 2 3 41 Brown Lee Brown 35 Johnson 25 2 1 4 Davis 32 Michael Emily David Emily Michael Maria CDL20 CDL30 CDL40 CDL30 CDL20 CDL40 license details Gross weight up to 20 tons Gross weight up to 30 tons Gross weight up to 40 tons Gross weight up to 30 tons Gross weight up to 20 tons Gross weight up to 40 tons truck id 101 102 103 101 104 102 truck name Delivery Blue Transfer Orange Deep Freeze 1 Delivery Blue Transfer Green Transfer Orange job_date rate $ 1.10 2020-05-29 2.20 2020-06-27 $ $ 2.50 2020-07-11 $ 1.70 2020-05-28 $ 1.65 2020-06-17 $ 2.50 2020-06-20

Answer rating: 100% (QA)

The relational schema for 1NF is as follows CREATE TABLE JOB driverid INT NOT NULL ... View the full answer