Wednesday, June 17, 2020

HTML2

Hypertext Markup Language (HTML) 2

Learning Outcomes:
Compulsory C. c. Elementary Web Authoring
  • Design and construct web pages for an intended audience and upload them onto the World Wide Web.
    • The organisation of information includes ease of navigation, appropriate placement of links, tables, frames and multimedia elements, colour combinations, background designfont size and style, for an intended audience.
    • Students are not required to memorise HTML codes. (you still need to memorise them for elective part)
Hyperlink <a href=”…”>

<a> defines a hyperlink
Attributes: href (destination address), target (where to open the linked document)

<a href=”http://...”> Full web address is used, this is known as absolute URL </a>
<a href=”local.html”> Relative URL is used for own web site. </a>

How relative URL works: https://kb.iu.edu/d/abwp

Bookmark/Anchor <a name=”…”> <… id=”…”>

2 HTML ways to create bookmark:
  • <a name=”youranchor”></a>: name can only be used with <a>
  • <p id=”youranchor”></p>: id can be used with any tag

Jump to the bookmark:
  • <a href=”#youranchor”>: same page
  • <a href=”URL.html#youranchor”>: different web page

Table <table> <tr> <th> <td>

<table>..</table> defines a table
<tr>..</tr> defines a row
<th>..</th> and <td>..</td> defines a cell, with <th> representing heading, specifically the content is bold and centered.

Visually, this is how it works,
<table>
<tr>
<th>..</th>
<th>..</th>
</tr>
<tr>
<td>..</td>
<td>..</td>
</tr>
</table>

Attributes: colspan (merge column), rowspan (merge row)
Some table attributes such as border, width, cellpadding, cellspacing, bgcolor, background and bordercolor are removed in HTML5. Using CSS to edit them is recommended.

Frames

<frame> and <frameset> tags are removed in HTML5. Using <iframe> is recommended.

  • Old method:
    <frameset> defines the layout of the whole web page.
    <frame> loads web pages into each frame defined in <frameset>.

    Example:

<frameset cols=”30%,70%”>                      
            <frame src=”link to your left side web page”>
            <frame src=” link to your right side web page”>
</frameset>

Created a frameset with 2 columns
First frame
Second frame
Manipulating frames

To open web page in certain frame / new browser. Compatible with <iframe>
(<frame> and <frameset> tags are removed in HTML5)

<a href=”new.html” target=”_blank”>                 Open in new window
<a href=”new.html” target=”_self”>                    Open in same frame
<a href=”new.html” target=”_parent”>                Open in parent frame (When frameset nested in frameset, it opens in the inner frameset)
<a href=”new.html” target=”_top”>                     Open in full browser window
<a href=”new.html” target=”(frame name)”>      Open in a named frame

Embed multimedia elements <embed> <img> <video> <audio>

<embed src=”…jpg”>
Attributes: src (source link), type (plug-in to initiate), width, height

<img src=”…jpg”>
Attributes: src (source link), alt (text description), width, height and many more

<video>
<audio>

Image with multiple links

Color combinations

Color can be represented using different formats in HTML5/CSS.

Black color can be represented by
  • the name black
  • Hex code #000000
  • RGB (0,0,0)
  • HSLa (0, 0%, 0%, 1)

Hex code #000000:
  • the first 00 represents the amount of red color. #FF0000 is red. (FF=255)
  • the second 00 represents the amount of green color. #00FF00 is green.
  • the last 00 represents the amount of blue color. #0000FF is blue.
  • #FFFFFF is white.

Background design

The attributes bgcolor and background are removed in HTML5. Using CSS to edit background design is recommended.

  •  Old method:
    <body bgcolor=”red”> </body>
    <body background=”….jpg”></body> this image will be displayed as tiles by default.

Friday, June 12, 2020

HTML 1


Hypertext Markup Language (HTML) 1

Learning Outcomes:
Compulsory C. c. Elementary Web Authoring
  • Recognise the basic constructs of Hypertext Markup Language (HTML) which is a means to address cross-platform issues.
  • Design and construct web pages for an intended audience and upload them onto the World Wide Web.
    • The organisation of information includes ease of navigation, appropriate placement of links, tables, frames and multimedia elements, colour combinations, background design, font size and style, for an intended audience.
    • Students are not required to memorise HTML codes. (you still need to memorise them for elective part)

HTML
  • Stands for Hypertext Markup Language
  • Markup Language: a computer language using symbols/tags in a text document to control its layout and format. E.g. html, xml
  • Function: create web pages
  • Current version: HTML5
    • Reason to use current version: follow new standards, support new functions, avoid deprecated(outdated) element/attribute
    • Possibly not supported by some old browsers


Basic structure of HTML document

<html>
<head>
<title> THIS IS TITLE </title>
<!--SOME OTHER ELEMENTS ARE ALSO PLACED IN THE HEAD SECTION-->
</head>
<body>
THIS IS WITHIN WORKSPACE OF THE BROWSER, ENCLOSED BY THE BODY TAGS
</body>
</html>

  • Tags: Building blocks of a HTML document. Most tags work in pairs. E.g. <html> </html>.
  • Attributes: For example, when using <font size=”1”>, size=”1” is known as attribute. It provides additional information about the <font> tag. Different attributes are available to different tags.

HTML tags:

Font size and style <font>

The <font> tag is removed in HTML5. To format font size, font-family and color, Cascading Style Sheets (CSS) is recommended.

  • Old method: <font size=”1” face=”arial” color=”green”> YOUR TEXT </font>


Text formatting <b> <i> <u> <del> <sub> <sup>

<b> bold </b>
<i> italic </i>
<u> underlined </u>
<del> deleted </del>
<sub> subscript </sub>
<sup> superscript </sup>

Text alignment

The <center> tag and align attribute are removed in HTML5. Using CSS to edit text alignment is recommended.

  • Old method:
    <center> This is center alignment </center>
    <p align=”left”> This paragraph is left aligned. </p>


Heading <h1> to <h6>

<h1> This is largest. </h1>
<h6> This is smallest. </h6>

Paragraphs <p> <br> <pre>

<p> Text within the tag forms a paragraph </p>
<p> This is another paragraph. <br> br stands for line break. <br> No new paragraph is formed. </p>
<pre> Pre stands for preformatted text.
It preserves the line breaks and spaces as you typed in the HTML document. </pre>


Character entities/Escape characters

Tags used the reserved characters < and >. To properly displace it in the web page, we use character entities/escape characters.
<: &lt;
>: &gt;
Multiple consecutive space in a HTML document will automatically be reduced to a single space.
To displace multiple space, use <pre> or escape character known as,
non-breaking space: &nbsp;

Comments

If you want to include comments in the HTML document, you can enclose the message with <!-- and -->. The message will not be displayed in the web page.

Reference:
https://www.w3schools.com/html/default.asp

Saturday, May 30, 2020

Future database development


Future database development


Learning Outcomes:
  • Discuss the needs and trends of future database development and the corresponding applications.
    • Students should be able to discuss the impact of technologies, and dynamic web pages on database development.
    • In considering the need for different database applications, factors such as volume of data, variety of data and variety of users should be discussed.

Relevant past paper:
DSE Elec A(SP-2016): 2012 4e. 2014 3d. 2016 2c.


Dynamic web pages and database

Contents of dynamic web pages change on interaction with user. For examples, user can login to their own account and make purchases in a web page, which will be saved in the DBMS. The web page content show what you have purchased based on the information from DBMS.
Different systems are necessary to provide dynamic web pages including a web server, a database system and application system to build the dynamic web page.
They are more costly and slower than usual static web pages. Yet, it allows interaction with users and provides up-to-date information to users.

Variety of data

Image data and other types of data can be stored in a database table or outside the database.
Store images in database tables:
  • Advantages: data consistency maintained by DBMS, security provided by DBMS.
  • Disadvantages: large volume of data to process - slower, inconvenient to view the images.



References:

Sunday, May 3, 2020

Data Privacy


Data Privacy


Learning Outcomes:
Discuss the importance of data privacy and develop proper attitudes to be an ethical user of database to respect data privacy.
Ways to achieve data privacy in database applications using access rights should be discussed.

Relevant past paper:
DSE ICT Elec A(SP-2016): SP 4ab. PP 4b. 2012 2eii. 2013 2c, 4di. 2015 4d. 2016 2e.

Data Protection Principles

  1. Data collected should be necessary and adequate but not excessive.
  2. Ensure the personal data is accurate and not kept longer than necessary.
  3. Prohibit use of personal data for new purpose not related to original purpose.
  4. Take all practical steps to protect the personal data.
  5. Take all practical steps to ensure openness of personal data policies and practices.
  6. Provide data subjects with the right to request access to and correction of their own personal data.

 Ways to achieve data privacy in database applications - Access control

  • Use of login and password
  • Access rights to database objects according to user groups
  • Create views for different user groups - only provide the necessary information



References:

Sunday, March 15, 2020

Database Personnel


Database Personnel

Learning Outcomes:
  • Identify different database personnel such as database administrators, designers, developers and data entry operators, and describe their roles and responsibilities in database development and maintenance.
    • The responsibilities and ethics of different database personnel should be stressed.


Relevant past paper:
DSE ICT Elec A(SP-2016): 2013 4a. 2014 4b. 2016 4a.


Duties of database personnel (some examples)

Database administrators

Operational maintenance stage.
Monitor the daily operation of the database system.
Fine-tuning the system e.g. optimize query commands.
Control access rights of different user groups.

Database designers

Application and database design stage.
Create a database design including data type, table structure etc. Create view for different user groups.

System analysts

Requirements collection and analysis stage.
Collect the requirements information from different users.
Design the conceptual database.

Database developers/programmers

Implementation stage.
Programmers write program codes based on “database and application design”.

Data entry operators

Enter data into database for its operation.


References:

Saturday, February 22, 2020

Data Mining


Data Mining

Learning Outcomes:
Be aware of the uses and applications of data mining in daily life and explain how data mining can improve the quality of living.

Relevant past paper:
DSE ICT Elec A(SP-2016): PP 4d. 2013 4f. 2015 4c. 2016 4eii.


Questions on data mining focus on application, rather than the techniques of data mining.
The focus is on:
  • Purpose of data mining
  • What data you are going to collect
  • How you can use the generated information


Purpose

Data mining helps to discover the hidden patterns and trends. This knowledge allows prediction of future trends and behaviours. An organisation can use this information to make appropriate decision.

What data to collect

Depending on what you want to know.
For example, if you want to promote sales, you want to present relevant items to the buyers when they are making purchases on the web. You may see other products as “Related to items you viewed”. So you may want to collect data on buying habits and what items are usually bought together in order to achieve that.

Generated information

With further analysis, you can now group different people into groups with different behaviours. You can present different products to the groups based on their behaviours.



References:

Tuesday, February 18, 2020

Database application development lifecycle

Database application development lifecycle


Learning Outcomes:
  • Understand the stages involved in the database application development lifecycle and the links between them.
    • The main stages involved in the database application development lifecycle include requirements collection and analysis, system definition, application and database design, DBMS selection, form and report design, prototyping, implementation, data migration, conversion and loading, testing, and operational maintenance.
    • Students should recognize that the stages of the database application development lifecycle often involve review and repetition of previous stages through feedback loops.
  • Practise the main activities associated with the stages of the database application development lifecycle in an educational or commercial scenario.
    • Students should be able to apply simple Computer Aided Software Engineering (CASE) tools to automate, manage and simplify the database design process. CASE supports may include tools for data dictionary construction, and those for facilitating data models development, etc.

Relevant past paper:
DSE Elec A(SP-2016): 2012 4a. 2013 3d. 2014 3bc. 2015 4ab. 2016 4bc.

Stages involved in the database application development lifecycle:

Variations exist for what should be included in the lifecycle. This is a general guide.
Components
Deliverables i.e. Products of the development process / Details of the stages
System definition
5Ws (What, Why, Who, When, Where)
Feasibility report, project plan
Requirements collection and analysis
Collect information from potential users
e.g. questionnaires, interview
à know what data to collect for the DBMS, what functions are expected
Application and database design
DBMS selection (database)
Form and report design (application)
Conceptual, logical, physical design…
Conceptual – ER diagrams
Logical – normalisation of tables
Physical - hardwares, physical data design
Prototyping
Implementation
An early model is presented to users for feedback
Errors can be detected earlier and resolved by going through previous stages
Data migration, conversion and loading
Format of original data may not be suitable for use à need conversion to usable format
Ensure data consistency
Testing
Test plan with different test cases (create pseudo-data)
Use of real data after data conversion
Operational maintenance
System put into use
Documentation: system and user manuals (for record and future maintenance)
Backup, monitor for errors, etc.
The lifecycle often involves review and repetition of previous stages through feedback loops.

Computer Aided Software Engineering (CASE) tools

These tools are software tools that assist the development of a database application in different stages of the development lifecycle. A long list of CASE tools exists.
CASE tools have a central repository, function as a data dictionary, source of common information and storage of product specifications, documents and diagrams. Different CASE tools can obtain essential information from the central repository.

Some examples:
Stages
CASE tools
Deliverables from CASE tools
Definition/Planning
Project management tool
Project schedule
Application and database design
Graphical modelling tool
ER diagram
implementation
Query editor
Query command
Testing/maintenance
Query analysis tool
Database performance


References:


Syllabus comparison

 Syllabus comparison   DSE ICT 2025 New syllabus DSE ICT 2012-2024 CE CIT 2005-2011 CE CS 1994-2004 ...