2019
Revision on SQL, Database Design (Normalization)
- DSE paper (2012-2017)
- ASL (2010, 2011, 2012) - (Soft copy in Google Classroom)
- Practice paper (Soft copy in Google Classroom)
- Long Man (MC) - You may borrow from me.
- Long Man (Mock) - You may borrow from me.
- Long Man Text book (Integrated Exercise)
- DSE paper (2018 P2 and P1B) Apr 11 & Apr 15
SBA2018
SBA Phase 2 Schedule:
Explanation and Pre-Exercise: Nov 9 (Supplementary Lesson) and Nov 13 (L4-5)
Nov 17 L1-3
Nov 23 Supplementary Lesson (Deadline for Exercise 1)
Dec 1 L1-3 (Deadline for Ex.2)
Dec 4 Supplementary Lesson (Deadline for Ex3)
Dec 13 (Wednesday: Deadline for 1st draft report)
Dec 15 L1-3 (Deadline for submission: 10:30 p.m.)
ICT Exam date: 7th April, 2018 (Saturday)
DSE2017 : Do it together after Study Leave.
Supplementary Lesson 2018
Install VMWare player at home
Copy the VM with phpBB3 to your USB.
Basic VM commands
- Double click forum to run the VM
- CTRL + ALT to toggle between VM and your hosts.
Username and password
- administrator / administrator
- root / administrator
use ifconfig to check your IP
Access you web site with a browser http://<ip-address>/
http://<ip-address>/phpBB3/ to access your forum
http://<ip-address>/phpmyadmin/ to access DB
use "sudo init 0" to shutdown your VM.
Basic requirements in Design Stage (in S5)
Overview of the solution in the design with justification
PART 1
- Network design
(Compare different designs and explain the features)
- Hardware platform (Server, network devices)
You may also using virtualization technology OR hosting service
PART II
- Software platform (OS, Web Server, Programming + DB)
- other tools used in your development
PART III
The Hierarchical of the feature Design
- Chart
- Description
PART IV
Clear and user friendly interface
Screen capture is needed. (e.g. Page Layout, color scheme)
SBA Assignment 1
Study different Online forum features.
Reference:
https://download.phpbb.com/pub/documentation/3.1/ascraeus_documentation.pdf
http://www.quertime.com/article/15-best-online-forum-platforms-software-free-and-paid/
Draw a comparison table including at least 3 Online forum platforms. (must include phpBB) Must include the following items. (Not limited to)
Submit on Next Friday. (May 29)
SBA Assignment 2
You may assume the Management decided to setup its own server (hosting, virtual, real server is acceptable)
Compare different Network Design at least the following aspect
Justified your choice with explanation
Hosting Web sites
Amazon Cloud http://aws.amazon.com/
Microsoft Cloud http://azure.microsoft.com/
Submit on OR before June 5
SBA Assignment 3
With provided budgets, choose a suitable Hardware/Software platforms.
List out choose you have and compare.
Justified your choice.
Example:
Provided Budget: HKD50000 for the coming 5 years.
Compare software platform
1. Operating System (e.g. Ubuntu Linux, Windows Server 2012r2)
2. Web Server Software (e.g. Windows IIS, Apache ...)
3. Programming (jsp, php...)
4. DBMS (MySQL, ....)
Select and justified your answer.
e.g. support, costing, ...
Compare hardware.
Find a server configuration in web
You can also compare the Server hosting.
Select and justified your answer
Submit on OR before June 11
SBA Report for design (After Final Exam)
You will have time to revise and compile the above SBA assignment into a SBA Report after the final exam.
Exercise 4
At home http://comp.rhs.edu.hk/phpBB3/
Register an account with the name S6XYY where 6X is your class and YY is your class number.
Use your School Google Account for registration.
You can try out the user interface on or before next Thursday. (Oct 8)
I will set you to moderator on Oct 9. and you can try out the moderator features on the coming week.
Capture some useful interface and studying the features and setting..
SUPPLEMENTARY LESSON
Date: 17-21, Aug, 2015
Time: 8:30 - 12:00
Venue: Tentative Room 537
Topics Covered:
- Chapter 28 (Book 3)
- SBA Project (Design) : More information will be posted on Next week (on or before July 10)
Title: Discussion forum system
A Secondary School in Hong Kong is going to design a public discussion forum system in which a database is used to store user information and forum posts. Essential information about each post, such as the user identifier, IP address and time of the post, should be stored for security and user behavior analysis purposes.
The system should generate statistics and carry out analysis, such as:
² posting statistics
² user statistics
² online traffic analysis
² posting habits analysis
You are the IT project manager responsible for the project. You are going to provide solutions for some of the above requirements for above public discussion forum.