Question: Hi, I would like to do this assignment today in SQL with output please, with details Someone in chegg solved it for me incompletely please

Hi, I would like to do this assignment today in SQL with output please, with details

Someone in chegg solved it for me incompletely please help me:(

Database Mining and Data Warehousing-Lab

Notes:

  • Write your name and ID at the beginning of the answer paper.
  • Print screen your codes and output and paste them on the answer paper.
  • Submit the activity in pdf file.
  • Any similar answer will be considered as cheating and both students will take Zero.
  • Two marks will be cut for late submission.

Create the following tables and Link the tables using foreign key: (1 Mark)

Hi, I would like to do this assignment today in SQL with

  1. sID and CID are the primary key.
  2. CName could not be null.
  3. Write a query to show all the data in the second table.
  4. Write query to show students name that start with M.
  5. Write a query to show data for students with age more than 20 and GPA less than or equal to 4.
  6. Write a query to show students name with taken courses name.
  7. Write a query to order student information based on their GPA.
  8. Write a query to show the courses with more than two with credit hours.

Employee: SID 1 WN sName Amal Sara Mona Rjaa sAge 21 20 22 22 GPA 3.4 4.5 4.3 4 4 Courses cHrs SID 2 CID 121 135 177 187 CusName IS IT CS DM room 401 202 300 201 1 3 3 2 3 3 2 4 Nw

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!