Structured Query Language (SQL) is a language widely used in industry to create, update andquery data in relational databases. You are required to write the SQL code.Q.6.1The below sample data in the third normal form was provided by a databasedesigner. Answer the below questions using this data.Table: LawFirmPrimary key: LawFirmID (auto number)All fields are mandatoryLawFirmIDNameYearlncorporated1Ze Boss Attorneys20112Lawyers for the Win20183Court Rulez2019Table: LawyerPrimary key: LawyerlDForeign key: LawFirmIDLawyerIDLawFirmlDSurnameNameAgeBianchiAnna4572ModiseDikeledi5782FerreiraPiet343NkosiJabulani28Q.6.1.1 Write a SQL statement to create the table Lawyer.Hint: The sample data should give you an indication of the datatypes you should use.Q.6.1.2 Write a SQL statement that will calculate the average age of all thelawyers that are at least 40 years old.Q.6.1.3Write a SQL statement to insert the below row into table LawFirm.

Q6.1.1 CREATE TABLE Lawyer( LawyerID int NOT NULL PRIMARY KEY, LawFirmID int NOT NULL FOREIGN KEY…

Answered: Structured Query Language (SQL) is a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

PHP script
_&plase helo with Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers..
• Data Manipulation Language (DML): Develop the following SQL statements: o UPDATE statements to mark any previously unavailable products as "shipped" and any orders not previously completely shipped as "completely shipped" Be sure to provide a rationale for your approach to the SQL statements. All sources, both in-text and in the References section, should be cited using APA format. N N N Orders -order_id [PK] (int) - customer_id [FK) (int) - date (datetime) - shipment_status (varchar) Products -product_id [PK] (int) -name (varchar) - description (varchar) -price (decimal) -vendor_id (int) Vendors -vendor_id [PK] (int) -name (varchar) - email (varchar) -address (varchar) Purchase Details -purchase_details_id [PK] (int) -purchase_id [FK) (int) -product_id [FK] (int) -quantity (int) -price (decimal) N N N N Customers customer_id [PK] (int) - name (varchar) - email (varchar) - address (varchar) N N Order Details -order_details_id [PK] (int) -order_id [F] (int) -product_id [FK] (int)…
1-Write the syntax to insert into a relational table called students the address column references an object table called addresses that was created using an address_type. Other columns exist in the students table, but you are only inserting into the ones below. Aliases used should be the first letter of the table name, eg students would be s, addresses would be a Relational Table Name students attribute student_id attribute surname attribute address
SQL Query question
Db&__Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers...
You have given a table from a database and the name of the table is Employees Please display the following from the Employees 1) The Employee Id, Last Name and First Name for each employee in order in terms of Last Name. 2) The employees who is title is Sales Representative 3) Delete the employee whose title of courtesy is Dr. 4) Update the title of the employee whose title is Sales Manager to Senior Sales Manager.
SQL Database help
Let's wa(k through a review of basic SQL syntax, using as an example the database that was mentionedearlier. This database has the following simple structure(* indicates a primary key):Courses: CourseID*, CourseName, TeacherIDTeachers: TeacherID*, TeacherNameStudents; StudentID*, StudentNameStudentCourses: CourseID*, StudentID*Using the above table, implement the following queries.Query 1: Student Enrollment Query 2: Teacher Class Size
Software engineering
01.
Database Systems SQL

SEE MORE QUESTIONS

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS