Question 1
A database contains information regarding students and courses studied in a university.
Student (Information of students)
|
Attribute
|
Data type
|
Meaning
|
|
Name
|
varchar(50)
|
Name of the student
|
|
StudentID
|
varchar(10)
|
student id of the student
|
|
Address
|
varchar(100)
|
address of the student
|
Study (Study records of students)
|
Attribute
|
Data type
|
Meaning
|
|
StudentID
|
varchar(10)
|
Student id
|
|
CourseID
|
varchar(10)
|
course id of the course studied
|
|
Grade
|
varchar(2)
|
grade obtained by the student in the course
|
Course (Information of courses)
|
Attribute
|
Data type
|
Meaning
|
|
CourseID
|
varchar(10)
|
Course id of the course
|
|
Title
|
varchar(50)
|
Title of the course
|
Design a JSP that displays the information of courses that a student has studied. The student id of the student should have been passed as the parameter named studentID. The following example shows the content when the request URL is:
https://localhost:8080/web/index.jsp?studentID=s1234567
The student with student id s1234567 is Chan Tai Man. He studied two courses with grades C and B-.
In order to test your program, you may want to build a database with the required tables. However, the database is not part of the assessment of the assignment.
Question 2
Repeat Question 1 using servlet.
Question 3
Consider the following data structure for an ouhk student record:
l The root element is "records". It has a number of elements called "record"
n The element "record" which has the following attributes:
u name: name of the student
u address: address of the student
u dob: date of birth
u A number of elements called "course".
u The element "course" has the following elements:
l "courseid" which is the course id of the course studied.
l "score" which is the score of the course of the student.
(a) Define the XML file format using
(i) DTD [5]
(ii) XML schema [5]
(b)
Now, we want to display the following xml file as the following using XSLT:
COMPS311F
35
COMPS311F
45
COMPS311F
72
Note that in the XML file, you need to add the following tag to use the xslt file:
The tag assume that the xslt file is called records.xsl and the xml file is in the same location as the xslt file.
Question 4
You are given the following XML file:
COMPS811
43.5
COMPS838
35.0
Now, we want to produce the following output for the above file using SAX:
This is the result of student s345054
Score of COMPS811 is 43.5
Score of COMPS838 is 35.0
Total mark:78.5
Average mark:39.25
Write down the SAX program.
You can assume that the file name of the XML file is input as arg[0] in the main method of the program.
Attachment:- COMPS311_2015-SEP_TMA3booklet.zip