Q 1 Write the SQL query to Create two tables Teacher and Course as per the below structure Make Teacherno as primary key in the teacher table and foreign key in the course table Insert 10 records in both the tables as given below Teacher Table Teacherno Teachername Job officeno 1211 Dr Atef Masmoudi HOD 128 1212 Ashique Rasool Lecturer 129 1213 Raja Abdul Sattar Lecturer 130 1214 Prof Jalel Akaichi Professor 131 1215 Prof Jalel Akaichi Professor 132 1216 Asharul Islam Lecturer 128 1217 Hesham HUmmadi Lecturer 129 1218 Dr Usman Ahmed Professor 130 1219 Dr Yessine Alqassem Professor 131 1220 Dr Ali Algarwi Dean 132 Course Table courseno coursename crhr day Teacherno 121ISM Intro to IS 3 1, 3 222ISM DBMS 3 2, 4 223ISM Data Mining 3 3, 5 224ISM SAD 1 3 2, 4 225ISM GIS 3 1, 3 326ISM SAD 2 3 1, 3 341ISM Operations Research 3 2, 4 362ISM Internet Technologies 3 3, 5 383ISM Knowledge Base System 3 2, 4 435ISM Multimedia 3 1, 3 After inserting data write queries for the following Display the details of teachers whos office number is 128 Display the details of teachers whos office number is 129 or 130 Display the details of teachers whos office number is in (129, 130, 131) Display the details of courses taught by Mr Asharul Islam Change the office of Mr Raja from 130 to 131

The Answer is in the image, click to view ...

Question: Q 1: Write the SQL query to Create two tables Teacher and Course as per the below structure. Make Teacherno as primary key in the

Q 1: Write the SQL query to Create two tables Teacher and Course as per the below structure. Make Teacherno as primary key in the teacher table and foreign key in the course table. Insert 10 records in both the tables as given below.

Teacher Table

Teacherno	Teachername	Job	officeno
1211	Dr. Atef Masmoudi	HOD	128
1212	Ashique Rasool	Lecturer	129
1213	Raja Abdul Sattar	Lecturer	130
1214	Prof. Jalel Akaichi	Professor	131
1215	Prof. Jalel Akaichi	Professor	132
1216	Asharul Islam	Lecturer	128
1217	Hesham HUmmadi	Lecturer	129
1218	Dr. Usman Ahmed	Professor	130
1219	Dr. Yessine Alqassem	Professor	131
1220	Dr. Ali Algarwi	Dean	132

Course Table

courseno	coursename	crhr	day	Teacherno
121ISM	Intro to IS	3	1, 3
222ISM	DBMS	3	2, 4
223ISM	Data Mining	3	3, 5
224ISM	SAD - 1	3	2, 4
225ISM	GIS	3	1, 3
326ISM	SAD - 2	3	1, 3
341ISM	Operations Research	3	2, 4
362ISM	Internet Technologies	3	3, 5
383ISM	Knowledge Base System	3	2, 4
435ISM	Multimedia	3	1, 3

After inserting data write queries for the following:

Display the details of teachers whos office number is 128.
Display the details of teachers whos office number is 129 or 130.
Display the details of teachers whos office number is in (129, 130, 131)
Display the details of courses taught by Mr. Asharul Islam
Change the office of Mr. Raja from 130 to 131.

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!

Draw an ERD to reflect the requirements of the following scenario. You should copy and paste the image of your diagram into the box below. Scenario: "A motor vehicle has a make, a model, and a...

Please provide just queries for all the questions below Problem 1: Write an SQL query to join three related tables using JOIN ON in the JustLee Books. Select four-five columns that you would like to...

Introduction to databases Assignment 1 Description of the schema The following database is used by a building materials company to edit invoices for its customers and to manage its inventory The...

Project: Relational Modeling Note: This project must be unique in its design (E-R diagram) and implementation (SQL queries). You are not to copy or use any part of a database project that was...

On SQL Managment studio This lab is all about database normalization. Download, from DocShare, and run Week 6 Normalizing.sql to create the four databases, UNF (Unnormalized Form), FNF (First Normal...

computer science Introduction to databases SP22 Assignment ! Description of the schema The following database is used by a building materials company to edit invoices for its customers and to manage...

Question 2 . Use the Baseball database you created in the first week for this assignment (copy and save as YourLastNameLec3). Now by analyzing the baseball inventory data, we know one table design is...

Please help with step by step Question 2. Use the Baseball database you created in the first week for this assignment (copy the file). Now by analyzing the baseball inventory data, we know one table...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Problem 3 (Parts a-b are 3 points each, c-fare 4 points each; 22 points total) Here are some more challenging problems to try against the banking database. a) Generate a list of all cities that...

Adopting a "Cost-Plus" Pricing strategy, Jazzy-J Consulting is considering a 20% markup above full costs for fiscal year 2023. He estimates his variable costs will be $65 per unit and fixed costs...

Obtain the inverse transform in the form x(t) = A sin(t +(), where A > 0. X(s) = (4s + 9)/(s2 + 25)

Points or loan origination fees are up - front payment of the interest that you owe your lender.

Label all of the cell structures ( listed on the previous page ) on the drawing below. 4 3

What combination of Key Fields in a Salary Structure Table allows for storage of historical Pay Grade Data for multiple Occupation Group Pay Grade Structures?

Explain the function and purpose of the Job Level Table.

What are Compa-Ratios? Explain the difference between Internal and External (Market Based) Compa-Ratios.