SEMESTER 2 CRISIS RESPONSE ASSESSMENT 2019/2020
MODULE: EE417 - Web Application Development
PROGRAMME(S):
MECE MEng Electronic & Computer Engineering
ECE BEng Electronic & Computer Engineering
MCTY MSc Electronic and Computer Technology
ECSAO Study Abroad (Engineering & Computing)
Note: This examination was a digital examination submitted via Loop/Moodle.
PLEASE DO NOT TURN OVER THIS PAGE UNTIL YOU ARE INSTRUCTED TO DO SO.
The use of programmable or text storing calculators is expressly forbidden.
Please note that where a candidate answers more than the required number of questions, the examiner will mark all questions attempted and then select the highest scoring ones.
There are no additional requirements for this paper.
QUESTION 1 - (Pre-prepared Question) [TOTAL MARKS: 34]
Description: You have previously built a web application using the core technologies from the EE417 course. This prototype application has been well received by your company and they have now provided you with funding to develop your application into a fully-featured, production-ready application for deployment in the real-world.
You have a team of four junior developers who report to you and who are ready to begin development of the software application. As you are the original designer and the most senior developer, the team is looking to you for guidance on a range of areas:
Application framework and architecture
Front-end framework and design
Data integration of components
Deployment & Hosting
Multi-user development issues
Testing
B2B (Business to Business) integration
Any other areas you feel important
You are required to prepare a document for the team providing them with big picture details for design, deployment, implementation and running of your software application.
This document should be concise, to the point and should not exceed 1500 words. This should be a highly personal document based on your own experience and your understanding of the course material. You should principally use the course material, but are not specifically limited only to elements from the course.
If you have not previously submitted Assignment #1, then you should make the assumption that you have built an application as described in the prior assignment description. All other aspects of this specification then apply as normal as you are not asked to write or enhance code for this assignment.
Submission:
-Submit into Loop using the instructions provided
Or
-In the case of network/Loop issues, submit your response as part of this document
Answer to Question 1 (1500 words max):
QUESTION 2 [TOTAL MARKS: 8]
Using HTML and CSS, create a web page which looks like the following. This page should scale with browser width and should be achieved using block elements for layout (e.g. do not use the table element).
Answer to Question 2:
QUESTION 3 [TOTAL MARKS: 8]
Using your HTML page from Q2, create a working calculator using JavaScript. The application should work for the following operators: plus, minus, multiply and divide. The result should update if any change is made to either value or the operator. If the result is invalid (due to missing or invalid data), the result should show ‘NaN’.
Answer to Question 3:
QUESTION 4 [TOTAL MARKS: 15]
Write the SQL to build three tables to represent your student registration record at Dublin City University. This database should record three main elements:
1)Biographical information (e.g. name, email etc.)
2)Registration on annual programmes
3)Registration on modules linked to those programmes
(8 marks)
Using the resulting tables generated by your SQL:
i)Demonstrate a multi-table join statement(2 marks)
ii)Explain the DELETE rules you have applied to your foreign key relationships(3 marks)
iii)Provide an SQL example that would violate referential integrity. Briefly explain why this violation occurs. (2 marks)
Answer to Question 4:
QUESTION 5 [TOTAL MARKS: 8]
The following class ‘StringCheck.java’ will compare two strings A and B and check whether the string B is a substring of string A.
public class StringCheck {
public static void main(String[] args) {
String a = "LongerWordContainingOtherWords";
String b= "Word";
if (args.length==2) {
a = args[0];
b = args[1];
}
System.out.println(isASubstring(a, b)); // true
}
public static boolean isASubstring(String a, String b) {
return a.contains(b);
}
}
Write a unit test class ‘MyTest.java’ which will contain four unique test methods, two of which will be successful and two of which will fail.
Note: TestRunner.java and a template class for your unit tests can be found here (http://ee417.eeng.dcu.ie/course-content/section-x-testing)
Answer to Question 5:
QUESTION 6 [TOTAL MARKS: 7]
Modify StringCheck.java from Question 5 so that it passes all of your previous tests, is robust against any submitted inputs and is case insensitive.
Answer to Question 6:
QUESTION 7 – Multiple Choice [TOTAL MARKS: 20]
7(a)
Which of the following statements about Model 2 architecture is FALSE?
A)Servlets can be used as the front component
B)JSPs can be used as the front component
C)JSPs are better than servlets for implementing the view component
D)A single component handles both the request and the response
Answer:
7(b)
How are java web applications packaged?
A)jar
B)war
C)zip
D)Both jar and war
Answer:
7(c)
Which of the following has data stored at client side?
A)URL rewriting
B)Cookies
C)SSL sessions
D)Hidden Form Fields
Answer:
7(d)
When trying to access a URL, the following message is displayed in on the browser: Server Error 403. What could be the reason for the message?
A)The requested HTML file is not available
B)The path to the interpreter of the script file is invalid
C)The first line of the output from the script is not a valid HTTP header
D)None of the above
Answer:
When migrating a Hibernate-based web application from Oracle to MySQL, which of the following statements is an incorrect statement:
A)Existing database drivers can be reused
B)The existing Hibernate javabeans can be reused
C)Any existing HQL statements can be reused
D)The Hibernate configuration file must be modified with updated details
Answer:
7(f)
Which is the following characteristics is most correct regarding the elements
and
.
A)Element
inherits properties defined for
in a stylesheet
B)Elements and
define content to be inline or block-level
C)
and
are used as alternatives for the element
D)
is used inside element
Answer:
7(g)
What does the XMLHttpRequest object accomplish in Ajax?
A)It is the programming language used to develop Ajax applications
B)It allows the opening of a web socket to transmit asynchronous requests using XML
C)It provides the ability to asynchronously exchange data between web browsers and web servers
D)It provides the ability to mark up and style the display of a dynamic web page
Answer:
7(h)
Amazon Elastic Compute Cloud (EC2) does which of the following?
A)Provides customers with an isolated section of the AWS cloud where they can launch AWS resources in a virtual network that they define
B)Provides resizable computing capacity in the cloud
C)Provides a simple web services interface that customers can use to store and retrieve any amount of data from anywhere on the Web
D)Provides a web service allowing customers to easily set up, operate and scale relational databases in the cloud
Answer:
7(i)
What type of servlets use these methods: doGet(), doPost(), doHead() and doDelete()?
A)Generic servlets
B)HttpServlets
C)Both A and B
D)Neither A or B
Answer:
7(j)
Why should we use PreparedStatements when building JDBC applications?
A)They provide increased protection against SQL Injection attacks
B)They operate more efficiently particularly when re-used in loops
C)They solve issues with special characters such as quote marks appearing in input data
D)All of the above