You may want to build a database with the required tables

Assignment Help PL-SQL Programming

Reference no: EM13973776

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:

<?xml version="1.0" encoding="ISO-8859-1"?>

<courseid>COMPS311F</courseid>

</course>

</record>

<courseid>COMPS311F</courseid>

</course>

</record>

<courseid>COMPS311F</courseid>

</course>

</record>

</records>

Note that in the XML file, you need to add the following tag to use the xslt file:

<?xml-stylesheet href="records.xsl" type="text/xsl"?>

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:

<code>COMPS811</code>

</course>

<code>COMPS838</code>

</course>

</result>

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

Reference no: EM13973776

Questions Cloud

Annual rate compounded monthly : You plan to retire with $750,000 in 20 years. How much should you deposit each month into an account that pays 9.0% annual rate compounded monthly? (Note: Compounding frequency is the same as the deposit frequency.)

A project to develop an e-commerce website : A project to develop an e-commerce website with the use of a database,

An overviewing of ict adoption in scm : Write a Dissertation Proposal on "Topic: An overviewing of ICT adoption in SCM, Your proposal must include more than 5000 words including table of content and references.

An overviewing of ict adoption in scm : Write a dissertation on "An over viewing of ICT adoption in SCM",

You may want to build a database with the required tables : 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.

You are required to prepare your own career plan : First you will have to select a field of professional interest; Marketing, Finance, Human resources, Information Technology or International business.

Recruitment and selection strategy to attract 20 new tutors : You have been asked to plan for the recruitment and selection strategy to attract 20 new tutors for a new college delivering business degree courses in Peterborough in September 2014

Correlation itrapolation extrapolation : One way is to try to find a function that best fits my data. I was thinking about one bestfit graph representing the correlation of all the ages of all the strikers and the goals they have scored.

Describe situations and organizational variables : Prepare a PowerPoint presentation that addresses the following elements surrounding employee morale and its effects on the workplace and describe situations and organizational variables that impact employee morale.

User Account

All Pages