Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Structured Query Language (SQL) is a language widely used in industry to create, update and query data in relational databases. You are required to write the SQL code. Q.6.1 The below sample data in the third normal form was provided by a database designer. Answer the below questions using this data. Q.6.1.1 Write a SQL statement to create the table Lawyer. Hint: The sample data should give you an indication of the data types you should use.  Q.6.1.2 Write a SQL statement that will calculate the average age of all the lawyers that are at least 40 years old.  Q.6.1.3 Write a SQL statement to insert the below row into table LawFirm.

Structured Query Language (SQL) is a language widely used in industry to create, update and query data in relational databases. You are required to write the SQL code. Q.6.1 The below sample data in the third normal form was provided by a database designer. Answer the below questions using this data. Q.6.1.1 Write a SQL statement to create the table Lawyer. Hint: The sample data should give you an indication of the data types you should use.  Q.6.1.2 Write a SQL statement that will calculate the average age of all the lawyers that are at least 40 years old.  Q.6.1.3 Write a SQL statement to insert the below row into table LawFirm.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Structured Query Language (SQL) is a language widely used in industry to create, update and
query data in relational databases. You are required to write the SQL code.
Q.6.1 The below sample data in the third normal form was provided by a database
designer. Answer the below questions using this data.

Q.6.1.1 Write a SQL statement to create the table Lawyer.
Hint: The sample data should give you an indication of the data
types you should use. 
Q.6.1.2 Write a SQL statement that will calculate the average age of all the
lawyers that are at least 40 years old. 
Q.6.1.3 Write a SQL statement to insert the below row into table LawFirm.

Table: LawFirm Primary key: LawFirmID (auto number) All fields are mandatory LawFirmID Name Yearlncorporated Ze Boss Attorneys 2011 1 2 Lawyers for the Win 2018 3 Court Rulez 2019 Table: Lawyer Primary key: LawyerlD Foreign key: LawFirmID LawyerID LawFirmID Surname Name Age 6 1. Bianchi Anna 45 7 Modise Dikeledi 57 8. Ferreira Piet 34 Nkosi Jabulani 28
Transcribed Image Text:Table: LawFirm Primary key: LawFirmID (auto number) All fields are mandatory LawFirmID Name Yearlncorporated Ze Boss Attorneys 2011 1 2 Lawyers for the Win 2018 3 Court Rulez 2019 Table: Lawyer Primary key: LawyerlD Foreign key: LawFirmID LawyerID LawFirmID Surname Name Age 6 1. Bianchi Anna 45 7 Modise Dikeledi 57 8. Ferreira Piet 34 Nkosi Jabulani 28
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS