Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write the relational schema for 1NF. Make sure to identify any keys using bold, italics, underlines, etc., as appropriate. JOB table driver id first name
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
Step by Step Solution
★★★★★
3.37 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
The relational schema for 1NF is as follows CREATE TABLE JOB driverid INT NOT NULL ...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