Question

QUESTION/ SOALAN 1. Consider the following schema in a university database: student (matricNo, studentName, address, major) course (courseNo, courseName, credit) MARKS/MARKAH Based on the database schema above, you are required to write SQL statement for each of the following: i) Create a new table called \"Result\" with the following structure: resultID (Auto-increment, Primary Key) matricNo (Foreign Key referencing student.matricNo) courseNo (Foreign Key referencing course.courseNo) Grade (VARCHAR(2)) ii) Insert a new result record for a student named \"Harith\" in the \"Database\" course with a grade of \"A\" (assume this record exists in the related table). Display the updated table with all student records. iii) Retrieve the names of students along with their enrolled courses and grades. Sort the result in alphabetical order based on the student names. iv) Retrieve the names of students who are not enrolled in any course. v) Calculate the number of students in the \"Cyber Security\" major. vi) Update the grade of the student named \"Fathin\" in the \"Networking\" course to \"B+\" (assume this record exists in the related table). (Total / Jumlah: 20)

          QUESTION/ SOALAN
1. Consider the following schema in a university database:
student (matricNo, studentName, address, major)
course (courseNo, courseName, credit)
MARKS/MARKAH
Based on the database schema above, you are required to write SQL statement for each of
the following:
i) Create a new table called \"Result\" with the following structure:
resultID (Auto-increment, Primary Key)
matricNo (Foreign Key referencing student.matricNo)
courseNo (Foreign Key referencing course.courseNo)
Grade (VARCHAR(2))
ii) Insert a new result record for a student named \"Harith\" in the \"Database\" course with a
grade of \"A\" (assume this record exists in the related table). Display the updated table with
all student records.
iii) Retrieve the names of students along with their enrolled courses and grades. Sort the
result in alphabetical order based on the student names.
iv) Retrieve the names of students who are not enrolled in any course.
v) Calculate the number of students in the \"Cyber Security\" major.
vi) Update the grade of the student named \"Fathin\" in the \"Networking\" course to \"B+\"
(assume this record exists in the related table).
(Total / Jumlah: 20)

QUESTION/ SOALAN
1. Consider the following schema in a university database:
student (matricNo, studentName, address, major)
course (courseNo, courseName, credit)
MARKS/MARKAH
Based on the database schema above, you are required to write SQL statement for each of
the following:
i) Create a new table called R̈esultẅith the following structure:
resultID (Auto-increment, Primary Key)
matricNo (Foreign Key referencing student.matricNo)
courseNo (Foreign Key referencing course.courseNo)
Grade (VARCHAR(2))
ii) Insert a new result record for a student named Ḧarithïn the D̈atabasec̈ourse with a
grade of Ä(̈assume this record exists in the related table). Display the updated table with
all student records.
iii) Retrieve the names of students along with their enrolled courses and grades. Sort the
result in alphabetical order based on the student names.
iv) Retrieve the names of students who are not enrolled in any course.
v) Calculate the number of students in the C̈yber Securitym̈ajor.
vi) Update the grade of the student named F̈athinïn the N̈etworkingc̈ourse to B̈+(̈assume this record exists in the related table).
(Total / Jumlah: 20)

Added by Austin G.

Question

Please give Ace some feedback