Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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)

image text in transcribed

  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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Database Management

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

1st edition

133405680, 9780133547702 , 978-0133405682

More Books

Students also viewed these Databases questions

Question

Do you consider yourself a people pleaser?

Answered: 1 week ago