Modern applications ranging from enterprise to social network applications are essentially designed and implemented based on the widely-adopted three-tier architecture, in which user interface, functional process logic and data storage/access are developed and maintained as independent modules.
For tomorrow’s Mission Control, we shall go through basic concepts and techniques in designing and implementing the data storage and data access component for those applications.
In the process, we will learn about various sub-phases of database design including conceptual, logic and physical design. We also have some hands-on practice on designing databases with a CASE tool (RISE Editor), and working with a popular open-source database management system (MySQL).
The following pieces of software will be used in this mission control:
1.) RISE Editor for drawing ERDs (Entity Relationship Diagram)
We have been in talks with the InfoComm Development Authority of Singapore (IDA) to have them over to talk about the data.gov.sg initiative. They have also told us that they are in the midst of organizing some events that might be of interest to all of you. You may want to consider joining in these two events happening next week (of course, please log your attending hours as part of your Orbital timesheet, as with everything else). Some of these events are happening at Blk 71 (again!).
[Snip — what follows is from IDA]
A. Google Cloud SQL Workshop on 18th June 2013 (Tuesday)
We will be working with developer groups in Singapore to bring to you workshops which incorporate the latest technologies with government data.
The first of our workshops will be a collaboration effort between IDA and the Google Developer’s Group :
Google Cloud SQL and Big Query with Government data.
B. Tech Talk on Entrepreneurship and Civic Innovation
Join us for an evening with speakers from Google Ventures and Washington DC’s iStrategy Labs. Innovators in their own right, Bridgette and Peter will share tips on how developers and start-ups bring their solutions forward by dreaming big and aiming high.
For tomorrow’s Mission Control, we will be going over two common web application vulnerabilities (including some live examples, Demo God willing) and their mitigations.
In the process, you will learn a little bit about cookies, sessions, password storage, and several web development and debugging tools that can make your life easier as a developer, or form part of your arsenal as an attacker.
The talk is rather unlikely to be recorded. Parts of the presentation containing personal information that was magically obtained may be omitted due to their sensitive nature.
To help you with what is expected for the first peer evaluation, we have done a sample project report, evaluation and response for the example Giftbook project. To see it:
On IVLE, under CS3108B_Orbital, go to Project -> **MISSION CONTROL** (Orbital Instructing Staff) -> Project Wiki to find the project report
You can find a sample evaluation of the project in the Folders.
The project report also contains a response to the peer review — after peer evaluation is completed on Monday 2 June, we will send you a copy of the feedback provided by your peers, and you are supposed to respond in your report by Wed 5 June.
Min will be giving a short tutorial and hands-on for Twitter Bootstrap — the CSS framework that is useful for giving a pretty decent look for most websites. A key part of Bootstrap is in its responsive design, making sites look decent on small resolutions (low res smartphones) as well as big ones (your 30″ Apple Thunderbolt Display).
This is a beginner level session — applicable to any web-based project.
The Mission Control Session will be held tentatively at SR3 from 6-8pm next week; please check back with us in IVLE and Askbot for updates.
UPDATE: We’ve gotten permission from Blk 71 to host it at their space!! Come join us over at Blk71’s Seminar Room 1. Click on the event venue Image on the right for Google Maps info.
Post event update — Re-Recording done
For those of you who missed it, or were a bit confused about it; you can watch the re-recording I’ve done of the show here.
Paypal’s team will be giving a short tutorial on Magento — an eCommerce web framework for PHP. Unfortunately, the presentation cannot be recorded (PayPal policy) so you’ll actually have to be on site to get access to this tutorial.
The Mission Control Session will be held in SR3 from 6-8pm. This is the default timing and location unless otherwise specified (we are working to have some sessions elsewhere when possible; we’ll let you know).
Also, if you want to participate in the hands-on session, you’ll need to have access to a LAMP / MAMP (virtual) machine. You can requisition one through eForms in MySoC or come with your own. For beginners, please note that this requirement (to set up a LAMP server) is not for the faint-of-heart — it can take more than several hours. You may find it more enjoyable just to come to listen to the tutorial instead of actually trying the hands-on-exercises. So this particular workshop may be considered more intermediate level.
We’ll also be on Askbot and G+ Hangouts (gmail ID knmnyn, perhaps others) to answer your technical questions (not just Magento) for those of you thinking of participating virtually.
I’ve uploaded some slides for the project documentation requirements for the “log” and “wiki” parts of the documentation. They are available in the IVLE workbin for the course: Click here to go to IVLE Workbin
I’ve also created a 25 minute video that you can watch for the purpose of the documentation.
You can watch the video here: