| Home | Sign up! | Projects | Seminars | Research Notes | Today's Lecture | About |
Member ID: 26

Jasdeep Singh

Email
bjasdeep@hotmail.com

Profile: I'm a sophomore student at AIT which is affiliated to Tarleton State University, Texas. Till now I've done advanced courses in MySQL, Visual C++ which includes windows programming, PHP and ASP.

Prof. Ashay Dharwadker's Courses (4):

CourseSemesterGrade
Information SystemsFall 2003View
Database SystemsFall 2003View
Probability & StatisticsSpring 2003View
Algorithm Design - IFall 2002View



Projects (1)


Project ID: 26
Course: Database Systems
Topic: Periodic Table
Description: We plan to make database systems project related to the periodic table of chemical elements.
The tables are as given below:
TABLE1: ELEMENTS
FIELD TYPE COLLATION
ATM_NO INT(11) BINARY
MASS_NOINT(11) BINARY
NAME CHAR(15) LATIN1_SWEDISH_CI
SYMBOL CHAR(4) LATIN1_SWEDISH_CI
WEIGHT INT(11) BINARY
TABLE2: COMPOUNDS
NUMBER INT(11) BINARY YES
SALT CHAR(10) LATIN1_SWEDISH_CI
FORMULA CHAR(10) LATIN1_SWEDISH_CI
MOL_WEIGHT INT(11) LATIN1_SWEDISH_CI
TABLE:3 RELATION
(ATM_NO,NUMBER) INT(11) BINARY YES NULL


Seminars (2)


Seminar ID: 17
Course: Information Systems
Topic: SSL and FTP
Description: Dev Agarwal and I presented this seminar on 6th November, 2003.

SSL: Digital certificates encrypt data using Secure Sockets Layer (SSL) technology, the industry-standard method for protecting web communications developed by Netscape Communications Corporation. The SSL security protocol provides data encryption, server authentication, message integrity, and optional client authentication for a TCP/IP connection. Because SSL is built into all major browsers and web servers, simply installing a digital certificate turns on their SSL capabilities.

FTP: It promotes sharing of files and hence the indirect use of remote computers.The data through FTP is transfered reliably and efficiently. All data transfer takes place over the data connection.

Reference: Netscape Tech Brief


Seminar ID: 35
Course: Information Systems
Topic: Seven bridges of Königsberg
Description: This seminar was given by me and my group partner Dev Agarwal on November 20, 2003:

Historical Problem:

In the town of Koenigsberg there was a river with two islands and seven bridges. Each Sunday people would go for a walk, and after a while someone noticed that no matter where they started they were never able to cross each bridge once and only once during their walk. It seemed that no matter where they started and where they walked, they would always end up in the wrong place for crossing that last bridge.

Euler`s Solution :

Euler demonstrated the main ideas found in all mathematics:
(1) Abstraction: The first thing that Euler did was to say that several things didn't matter. The shapes of the islands, the lengths of the bridges, the distances between the bridges, and so on. He threw away these details and ended up with a simpler diagram.
(2) Reasoning: There are four meeting places and all of them will have to be visited on our walk. You might start at one and finish at another, but there will always be at least two of them that are neither start nor finish. Let's pick one to think about, we'll call it X. Since X has some bridges coming to it we will have to visit it at least once. Since we neither start nor finish there, every time we come in we must go out again, and on a different bridge. That means that the total number of bridges that land at X must be even. For every in there is an out and if there's an odd number of bridges, that won't work. So X our place that is neither start nor finish, must have an even number of bridges. However, all our landing places have odd numbers of bridges,and that makes it impossible to do our walk.
(3) Generalisation: No diagram can be drawn if it has more than two places with an odd number of lines. If a diagram does have two places with an odd number of lines, then one of them must be the start and the other must be the end.

Note: This analysis by Euler created the subject of Graph Theory. The "diagrams" are now called graphs, the "places" are now called vertices and the "lines" are now called edges.



Research Notes (1)


Research Note ID: 36
Course: Database Systems
Topic: Database Snapshots
Description: Snapshots are much like executing a query but still there are exceptions. Snapshots have common points as ‘view’ but not the same thing as 'view'. They are real not virtual unlike 'view'. Their own separately materialized copy of the data defines them. Snapshots represents the relevant data as it was at most 24 hours ago…
Exceptions of snapshots not being much like a query are:
a) The result of a query in the database under the specified name as a read-only relvar.
b) Periodically the snapshot is refreshed. That means the current value is discarded. And when it is executed again – the result is new snapshot after the execution.
For example: VAR JAS SNAPSHOT ((S JOIN SP) WHERE P#=P# (‘P2’)) {S#, CITY} REFRESH EVERYDAY;
The above query means: The query has specified name JAS and some conditions for snapshot to be made, and REFRESH EVERYDAY means that whenever it is refreshed snapshot gets a new snapshot value.

Last updated on Sunday, 23rd November 2003, 10:09:49 AM.

Prof. Ashay Dharwadker