Question: Please do the following: Part 1. SQL DDL (36 points) You are given a following schema: PublicChauffeurs(License Number, Renewed, Status, Status Date, Driver Type, License

Please do the following: Please do the following: Part 1. SQL DDL (36 points) You are

Part 1. SQL DDL (36 points) You are given a following schema: PublicChauffeurs(License Number, Renewed, Status, Status Date, Driver Type, License Type, Original Issue Date, Name, Sex, Chauffer City, Chauffer State, Record Number) The table is based on a real data set original taken from City of Chicago data portal (located here: https://data.cityofchicago.org/Community-Economic-Development/ Public-Chauffeurs/97wa-y6ff A. Write SQL DDL to create the table. Make sure to look at the data to decide reasonable domains. B. Declare primary and foreign keys as necessary in your SQL code. C. Create at least three reasonable additional attribute-level, tuple-level, NOT NULL, or UNIQUE constraints in your SQL code

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Oracle For both Parts 1 and 2, please submit your SQL code. Submitting your output is optional. Part 1. SQL DDL (36 points) You are given a following schema: PublicChauffeurs (License Number,...

Please help me learn by being specific and clear with answers Part 1. SQL DDL (36 points) You are given a following schema: PublicChauffeurs(License Number, Renewed, Status, Status Date, Driver Type,...

Universal Furniture Outlet Universal Furniture Outlet (UFO) sells quality furniture for home and office use. Its sales representatives use the attached form to take orders. Customer account numbers...

provide the answers for the following multiple choice questions base on the best of your knowledge. Thank you! To properly identify your signer named in documents as "James Carl Braden", his...

5/13/2016 MGMT404 Course Home Course Project (SEP15) Course Project Listen What's this? Objectives The objective of the Course Project is to give you an opportunity to practice the skills learned in...

Project 2 50 points Building upon your project 1, the park will be a Star Wars themed park. You must design additional parts of the database and create the following SQL Script. Step 1: Design and...

John and Shannon O'Banion, who live at 3222 Pinon Drive, Mesa, CO 81643, file as a married filing jointly. Please prepare a form 1040 woth a Schedule 1 and Schedule A gor the O'Banions using any...

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

In the following table we present prices for three commonly used sources of energy-motor gasoline, natural gas, and electricity-for the years 1990 through 1996: a. Consider a family that consumes...

1. The CHCl3 (chloroform) molecule belongs to the point group C3. List the symmetry elements of the group and show where each is located in the molecule (show one of each kind). H CIC CI 2. The CCl4...

Weller Corporation Comparative Income Staterent and Reconciliation ( dollars in thousands ) \ table [ [ , This yean,Last Year ] , [ Sales , $ 7 9 , 0 0 0 , % 7 4 , 0 0 0 ] , [ Cost of goods sold, 5 2...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

1 Why is time important to competitive advantage? Identify and explain six key contributions that speed can make to logistics strategy.

2 What are the potential negatives of WDTs new JIT system in terms of limiting customer choice and short-circuiting the design process? Sid Beckett, the Managing Director of Wiltshire Distribution...

Assess the benefits and concerns that may arise as a result of the relative sizes of P-time and Dtime. Compile your views in the table below: Benefits P-time greater than D- P-time = D-time time...