Answered step by step
Verified Expert Solution
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)
- 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started