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)

- sID and CID are the primary key.
- CName could not be null.
- Write a query to show all the data in the second table.
- Write query to show students name that start with M.
- Write a query to show data for students with age more than 20 and GPA less than or equal to 4.
- Write a query to show students name with taken courses name.
- Write a query to order student information based on their GPA.
- 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
Get step-by-step solutions from verified subject matter experts
