PART B Consider the college database you implemented in the image provided and answer the following questions.i. Write SQL statements to populate the relevant tables with the following data StudnogivenNamefamilyNamefacultyhonsyearcoursenoequipmentusedsubjectsubject220123AngelMatheausFCIComputer Science2CSC101laptopjava227456MichaelJacksonACCAccounting3ACC510calculatorStatistics223546JoyWillianMGTManagement1MGT305project leadership NameroomnocourseAndrea Kulima709ACC510Princess BukohwoFCI 6CSI101Peter Jones201MGT305Thandeka PhetoOB 12CSI101 All staff (appraisees) are appraised by Thandeka Pheto.ii. Write an SQL statement to change Thandeka Pheto’s room number to “PH506”iii. Joy Willian decided to transfer to another college, write SQL statement to remove her details from the college’s database. iv. Write an SQL query to show all students in year 2 of their studies v. Write an SQL query to list all courses that require a “laptop” as equipment vi. Write an SQL query to print details of the Staff members whose FIRST_NAME ends with ‘a’. 1111

Solution: 1.SQL statement that displays the data of the STUDENTS table SQL Query to create table1 :…

Answered: PART B Consider the college database…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

PART B
Consider the college database you implemented in the image provided and answer the following questions.

i. Write SQL statements to populate the relevant tables with the following data

Studno	givenName	familyName	faculty	hons	year	courseno	equipmentused	subjectsubject
220123	Angel	Matheaus	FCI	Computer Science	2	CSC101	laptop	java
227456	Michael	Jackson	ACC	Accounting	3	ACC510	calculator	Statistics
223546	Joy	Willian	MGT	Management	1	MGT305	project	leadership

Name	roomno	course
Andrea Kulima	709	ACC510
Princess Bukohwo	FCI 6	CSI101
Peter Jones	201	MGT305
Thandeka Pheto	OB 12	CSI101

All staff (appraisees) are appraised by Thandeka Pheto.

ii. Write an SQL statement to change Thandeka Pheto’s room number to “PH506”
iii. Joy Willian decided to transfer to another college, write SQL statement to remove her details from
the college’s database.
iv. Write an SQL query to show all students in year 2 of their studies
v. Write an SQL query to list all courses that require a “laptop” as equipment
vi. Write an SQL query to print details of the Staff members whose FIRST_NAME ends with ‘a’.