2. Insert the following data in the tables: (1.5 marks) DEPARTMENT dptID dpt Name BA DSG...

Transcribed Image Text:

2. Insert the following data in the tables: (1.5 marks) DEPARTMENT dptID dpt Name BA DSG IT SCORE st Num Business Administration Design dptBuilding с D Information Technology A scrMark 00 286860 85 crsCode scrDate 20201001 BADR1101 01/02/2020 75.55 COURSE 20201001 BAAC3101 20203001 ITDR1101 20203001 ITIN3101 20203001 ITDR2106 crsCode crs Title ITDR1101 Introduction to IT 01/06/2020 88.75 01/02/2020 85 01/09/2020 95 01/06/2020 88 20202001 DSDR2101 01/02/2020 95 20202001 DSGD3101 01/06/2020 20193015 ITDR1101 01/02/2018 20193015 ITDR2106 01/06/2018 BADR1101 Business Fundamentals DSDR2101 Photography 90 ITIN3101 Internship ITDR2106 Introduction to Databases BAAC3101 Accounting 20193015 ITIN3101 01/09/2018 20183014 ITDR1101 01/02/2018 55 DSGD3101 Graphical Design 3. Write an SQL command to list all student names and numbers in alphabetical order. (1 mark) 90 STUDENT stNum stName 20201001 Ahmed Mohammad 20203001 Ali Salem 20202001 Mariam Hamed 20193015 Hajer Sadeq Saleem Radhi Walid Alamri Fathi Fattoh 85 20191015 20193016 20183014 stAddress dptId BA IT DSG Ibri Nizwa Suhar 5. Write an SQL command to list student names, course titles they have finished. (1 mark) Sur Ibri Ibri Sur crsCredit 3 3 2 0 3 3 4 IT BA IT IT 4. Write an SQL command to list department code and number of students in each department. (1.5 marks) 6. Write an SQL command to list department name and number of courses of the department. (1.5 marks) dptId IT BA DSG 10. Write an SQL command to create the view mrksReport that contains student name, course title, score. (1.5 marks) IT IT BA DSG 7. Write an SQL command to display students' names and overall average. (1.5 marks) 8. Write an SQL command to display names and score of students who completed the course "Introduction to IT". (1.5 marks) 9. Write an SQL command to add the attribute crsPrereq to table COURSE. (1 mark) 2. Insert the following data in the tables: (1.5 marks) DEPARTMENT dptID dpt Name BA DSG IT SCORE st Num Business Administration Design dptBuilding с D Information Technology A scrMark 00 286860 85 crsCode scrDate 20201001 BADR1101 01/02/2020 75.55 COURSE 20201001 BAAC3101 20203001 ITDR1101 20203001 ITIN3101 20203001 ITDR2106 crsCode crs Title ITDR1101 Introduction to IT 01/06/2020 88.75 01/02/2020 85 01/09/2020 95 01/06/2020 88 20202001 DSDR2101 01/02/2020 95 20202001 DSGD3101 01/06/2020 20193015 ITDR1101 01/02/2018 20193015 ITDR2106 01/06/2018 BADR1101 Business Fundamentals DSDR2101 Photography 90 ITIN3101 Internship ITDR2106 Introduction to Databases BAAC3101 Accounting 20193015 ITIN3101 01/09/2018 20183014 ITDR1101 01/02/2018 55 DSGD3101 Graphical Design 3. Write an SQL command to list all student names and numbers in alphabetical order. (1 mark) 90 STUDENT stNum stName 20201001 Ahmed Mohammad 20203001 Ali Salem 20202001 Mariam Hamed 20193015 Hajer Sadeq Saleem Radhi Walid Alamri Fathi Fattoh 85 20191015 20193016 20183014 stAddress dptId BA IT DSG Ibri Nizwa Suhar 5. Write an SQL command to list student names, course titles they have finished. (1 mark) Sur Ibri Ibri Sur crsCredit 3 3 2 0 3 3 4 IT BA IT IT 4. Write an SQL command to list department code and number of students in each department. (1.5 marks) 6. Write an SQL command to list department name and number of courses of the department. (1.5 marks) dptId IT BA DSG 10. Write an SQL command to create the view mrksReport that contains student name, course title, score. (1.5 marks) IT IT BA DSG 7. Write an SQL command to display students' names and overall average. (1.5 marks) 8. Write an SQL command to display names and score of students who completed the course "Introduction to IT". (1.5 marks) 9. Write an SQL command to add the attribute crsPrereq to table COURSE. (1 mark)

Answer rating: 100% (QA)

Query 3 SELECT stNum stName FROM STUDENT ORDER BY stName ASC This query will list all student names ... View the full answer