Question: Connect to your database name your _ matric _ num ( eg: A 1 2 3 4 5 6 7 ) . Show all the

Connect to your database name "your_matric_num" (eg: A1234567).
Show all the tables.
Add the table (Student) then add data into the table (Student) below (the rows is not added before):
Add another table Course then add data into this table (Course) below (the rows is not added before):
Display student's name with cgpa more than 3.0.
Display the course's name and the number of students where the number of students
is less than 200.
Display student's name and address where the students live at Selangor only.
Display student's name, address, and cgpa where the students have cgpa more than
3.0 and live at Selangor only.
Kelly Katriona has changed her address to new places at Ipoh, Perak. Update her data.
Luth Wafiy had moved to another Faculty. Delete his data.
Connect to your database name "your _ matric _

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 Programming Questions!