Database for Student Registration System

Topics: Database, Database transaction, Concurrency control Pages: 23 (3140 words) Published: February 26, 2014
Int.
Thammasat J. Sc. Tech.,Vol.4, No.l, January1999

Registration
System
for
Database Student
At SIIT
Nakarin Netcharussaeng,Nichalin Suakkaphong
SirindhornInternationalInstitute of Technology
Thammasat
University
PathumThani l2l2l, Thailand
Apichat Tungthangthum,Pichet Chintrakulchai
Asian Universityof Science Technology
and
Chonburi20261.Thailand
Abstract
This paper presents the rectification of the student registration databasesystems of (SIIT). The experience
from using this registration
Instituteof Technology
SirindhornInternational
can
systemshowsthat many amendments be attainedin order to benefit the usersand the institute.A used for student
major anxiety at the first glance is about data protection. At present,the database registrationis the central database
that the institute usesfor many tasks such as studentregistration, studentacademicrecord, studentprofile, etc. Evidently, there is not much data protection control. Hence, if something adversely happened,the central databasewill be directly affected and may collapsespeciallyby those userswho are not aware of the mistakewhen using computer-based registration.Unexpectedproblemsmight occur and may needa tremendous amountof work to rectifu

problems
ofthe registration
suchas datainconsistency
database.
that the data might be exposedto. The other
caseconcernsupdates which might changethe

l.Introduction
Sirindhorn

Internationar Institute

of

(srrr),
rechnorogv rhammasat
Universirv, l*lJ:"ff'y;""lll'"rl'irt:il:;:T
uses
Microsoft Access version 2.0 as a database
management program for its registration
system. Due to the growth of the number of
students,many registrationworks have been
successfully
implemented
and are well served
from the use of the computerized database'
However flaws in the database
have shown up
from time to time causedby the experienceof
many users' The flaws signal that data
protection measures should be improved to
protectthe database
againsta variety ofpossible
threats (both deliberate and accidental)' For
example,
the systemmight crash in the middle
of someunfinishedtransactions,
therebyleaving
the central databasein an unpredictablestate.
considerthe casewhen two processes
executing
concurrentlyinterfere with one another,thereby
producing
incorrect
results.Sensitive
datamight
be exposed-or
worse, changedby unauthorized
users.The fact is there are indeedmany risks

t9

ffi;:

the databaseagainst such threats specifically'
recovery' concuftency' security' and integrity
controls' Forthe stabilityof the database'
using
one centraldatabase registrationis perilous
for
since some situationsmay adverselyhappen,
such as a systemcrash. Since only one central
databaseis used, the situation may reave the
database an incorrect state in which recovery
in
may not be possible.
consequentry, way to
one
ensure a recoverabledatabaseis to be certain
that every piece of information it contains can
be reconstructedfrom some other information
The
storedin other praces-redundancy. solution
we provide is that we createanotherdatabase
which is used only during the registration
period.we will refeito this new database the
as
registration database and the centrat database
asthemain databasethroughout paper.
this

Int. J. Sc. Tech., Vol.4, No.l, January 1999
Thammasat

2. Problems
2.1 Recovery
Before we go into the details of why we
need recovery controls, we would first like to
the meaning of recovery. In Date's
clarif
"Recovery in
words [l], recovery is depictedas
databasesystem means, primarily, recovering
the database itself-that is, restoring the
databaseto a state that is known to be correct
after some failure has renderedthe current state
incorrect, or at least suspicious." There are
severalpossiblereasonsfor a transactionto fail
in the middle of the execution. For example,
systemcrash(computerfailure) may causeerror
in the computer system...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Student registration system
  • Student Registration System Essay
  • Database Models and Legacy Systems Essay
  • Essay about registration
  • Concurrency Control In Database Systems Essay
  • Essay about Requirements for Student Registration System
  • Registration System Essay
  • Database Essay

Become a StudyMode Member

Sign Up - It's Free