A Tribute to Ms. Khairunnisha in My Life

A Tribute to Ms. Khairunnisha in My Life from ICT course
Abstract from Information Computer and Technology

Monday 16 April 2012

Web Applications

Tour with the Internet and the WWW


In the World of Internet and World Wide Web :

The Difference between  the Internet and WWW:


Major Networking and Computing Technologies : Chronological Order


Internet and WWW at Present : An Overview

The graph on your right shows the current situation of connectivity world wide. We can easily understand almost the whole world now having coverage of internet.






On your right, it's an statistic showing number of Websites reached over 165000000 in 2008.









A Web-based System : 

- Uses Dynamic Class Loader and Security Manager to compute server
- Clients are Applet, CGI script, stand-alone
- it also has Logging facilities
- It has searching facilities for computing resources

Internet Infrastructure :

The internet infrastructure include cable and wireless both the networks. It includes the server, user, computer and networks of computer.



Internet is such a system that allows user to send instant message globally.



How Instant Messaging works






Trends in the Internet and WWW

All About Web 2.0 :

Features :  - Use network as a platform as it deliver or receive applications thoroughly via a browser.
                - Users gets, manipuates and cntrolled the data on the site.
                - User can edit or add value to the application according to their requirement.
                - A rich, interactive and user-friendly interface.
                - Enhanced graphical interfaces which is absent in so-called Web 1.0.

Web 2.0 Elements
Categories of Web 2.0 Sites :

There are three categories of Web 2.0 Sites :

1. Social Networking
2. Mashups
3. Aggreators

Social Networking Sites : Web 2.0



Reflections Finally :

A great Concept on Database and Database system


On the track with Database & DBMS

After the Information System we were waiting for another new chapter. And when our lecturer introduced us with it we were eager to learn about it. The topic is Database. From previous course we got to know about Database but never tried ourselves how it actually works. Only theory covered ourselves.

But now even i can give a brief idea on Database. so what is Database? Database is the place to store the data in a system. It's the pool of data.

And Database Management System which is also called DBMS is a system to manipulate the database.

Example of Database System Management Tool: Microsoft Access      









Database Components: It has 4 main components.

1. Data Item : Data is used as a input for database.
2. Relationship : Connection between two or more tables.
                         There are also 3 types of relationship in database:  - 1 to 1
                                                                                                     - 1 to many
                                                                                                     - many to many
3. Constraints : Restriction of the contents of the database
4. Schema : Formal Language to support the database management system. Also to describe the organizational data in database.


Database Management System :
- Has 5 primary functions
- Database uses syntax similar to computer language called DDL (Data Definition Language). It defines the structure of data in database.
- It also uses DML (Data Manipulation Language) to edit, process, manipulate the data.
- Query Database uses SQL (Structured Query Language) to retrieve specific information or data in database.

Database Models: There are 4 types of Database Models.

1. Hierarchical Database: Apply 1 to many relationship concept.
2. Network Database: Many to many relationship.
3. Relationship Database: Connections between rows and tables in database. Apply one to one, one to many and many to many relationship.
4. Object-Professional Database: Object Oriented Programming Language

Special Terminology:

- Field : represents by the columns
- Record : represents by the rows.
- Key Field : the primary key or key field for students is their matric no. For certain subject the key filed is a unique number for the subject.
- Object : the entity of the database.
- Table : the collection of records.

How to Create a Database on MS Access 2010 :


1. First open MS Access 2010 and rename your database and press create button on your right corner.







2. When you press Create button, it will open for you a new page in MS Access. The page you are viewing now is a datasheet view of the database. You may select design view from the Home tab view button



3. Then you can edit your datasheet view depending on your information.








4. Then when you shift to design view it may look like this. But before this select one of the criteria in your database as a primary key to make a relationship with another datasheet.




5. Then you can create another datasheet without closing the MS Access and save and close it by right click on the datasheet tab bar.







6. You may make a relationship by clicking on the relationship button on the table tools Deign Tab.








7. Now you also can create a form like database which will allow you to input data and record it as well. You just have to click on the Form button on Create Tab.






8. You can create Queries and Reports from Queries Wizard and Report Wizard button respectively from Create Tab.






These were glimpse from our lab exercise and test.

Reflections Finally :


1. From the weeks we got to know about Data and Database Management system in brief.

2. We also got to know that Database system is the combination of Database and Database Management System.

3. We also were taught about the advantages of Database System.

4. 4 types of Database models were interesting and we got to know about the example of relationships.

5. Finally Lab Test and Exercise made everything easy to understand and apply on MS Access effectively.