Week 7-13

Question 1

Types of Relationships

Answer 1

Generalisation:
- Denotes inheritance (“a-kind-of”)
Aggregation:
- Denotes logical a-part-of relationship
Association:
- Any other relationship

Question 2

SQL Create Table Syntax

Answer 2

CREATE TABLE Project (
ProjectCode Char(10) NOT NULL,
ProjectTitle Char(10),
ProjectManager Char(20),
ProjectBudget INT,
PRIMARY KEY (ProjectCode) );

Question 3

SQL Insert Data Syntax

Answer 3

INSERT INTO Project (ProjectCode, ProjectTitle, ProjectManager, ProjectBudget) VALUES (‘PC010’, ‘Pension System’, ‘M Phylips’, 24500)

Question 4

SQL Selecting Data Syntax

Answer 4

SELECT ProjectTitle, ProjectManager, ProjectBudget
FROM Project
WHERE ProjectBudget < 20000
ORDER BY ProjectBudget;

Question 5

SQL Updating Data Syntax

Answer 5

UPDATE Project
SET ProjectTitle = ‘Payroll System’
WHERE ProjectCode = ‘PC010’;

Question 6

SQL Deleting Data Syntax

Answer 6

DELETE FROM Employee
WHERE employeeNo = ‘10001’;

Question 7

Principles of UI Design

Answer 7

• Layout
• Content Awareness
• Aesthetics
• Consistency
• Minimal user effort
• Usability

Question 8

What is overloading?

Answer 8

Methods within a class that have the same name but different signatures.

Question 9

What is overriding?

Answer 9

Allows a subclass to provide its own implementation of a method that is already defined in the superclass.

Question 10

What is coupling?

Answer 10

When changes in one part of the program requires changes in another part

Question 11

What is cohesion?

Answer 11

A method should be implemented into a single function

Question 12

What is high fan-in?

Answer 12

High fan-in refers to the number of methods in a class that calls a particular method

Question 13

Types of Architecture Patterns:

Answer 13

• Monolith
• N-Tier
• Serverless
• Microservices
• Peer-to-peer

Question 14

What are the type of tests?

Answer 14

• Unit tests, Single part of the program
• Integration tests, Assess if classes work together without error
• System tests, Ensures all classes work without error
• Acceptance tests, Performed by users to confirm user and business needs

Question 15

What is the difference between black box and white box tests?

Answer 15

Black box tests are external test while white box tests are internally based on method specification

Question 16

What is information hiding used for?

Answer 16

Information hiding is used to prevent access to particular attributes

Question 17

What is polyporphism?

Answer 17

Polymorphism is the ability of an object to take on many forms (implemented in multiple ways in different classes/objects)

Question 18

Why do we used architecture patterns?

Answer 18

We used architecture patterns to make code recognisable to other developers.

Question 19

What do deployment diagrams show?

Answer 19

Deployment Diagrams shows hardware/software components (locations and how they are networked)

Question 20

What is cloud computing?

Answer 20

Cloud computing uses external data centers or servers to handle tasks and provide services instead of local servers or computers.

Question 21

What is Green IT?

Answer 21

Green IT is anything that reduces the environmental impact of IT

(Such as reducing E-Waste, going paperless, or reducing energy consumption of data centres and desktops)

Question 22

UI Evaluation Techniques

Answer 22

• Heuristic
• Walkthrough Evaluation
• Iterative
• Formal Usability Testing