A computing machine is a landmark development of world civilisation. It is besides a nowadays feature in the assorted Fieldss of scientific discipline, industry, economic and military as they provide to worlds from the velocity and truth in finishing many of the computations and everyday and ability to salvage and recover information in a timely mode to do the right determinations. Computer scientific discipline and the databases have late entered in all countries of life from simple library family organisation to the big public libraries.The bill of exchange enrollment system is a correlativity between pupil databases and the Internet.
This chapter contains and includes brief rules and definitions of web sites and database types in general.
1.2. The database:
Database is a consistent set of informations which can be used to pull out the information you want or a group of really big sum of informations and information presented in an easier manner to happen. For illustration, the telephone directory is the simplest database that can be dealt with as you can enter your friends names and phone Numberss and where you can later look for the name of a friend ‘s battle by come ining a figure or reference and so on. There is another definition of the database which is an ordered list of informations that can supply a manner to entree quick and easy methodological analysis of information on a consistently selected point. It is considered that any organized group such as the narrative as a database here, can non procure the reaching of a methodological analysis for information that does non be in the narrative which is non traveling harmonizing to a specific sequence of events. the most common illustrations of databases of this construct is the phone book and dictionary. [ 5 ]
1.2.1. Advantage of the database:
The proviso of needed information is at breakneck velocity in record clip if it is compared to working or simple manual systems for informations storage handling.
2. The possibility of sharing in the informations:
The database direction systems could supply the same information to more than one user and that is through the development of the database on a separate device called server. the system and its informations can be connected and accessed by utilizing a database direction system.
3. Easy to utilize:
Database direction which is easy to utilize by normal users. They do non necessitate a specializer or professionals to cover with other systems. It is a really easy system to utilize and non complex. [ 5 ]
4. Confidentiality and security of informations:
The advantages of data direction systems are multi-user who can manage informations at the same clip, A secret art and information security will supply the confidentiality and will non let to hold shame and a sedate error by supplying the chance for all users to see all the informations without permission.
1. Hierarchy Database: It is considered the most forward and the signifier here is forming and set uping informations in a mandatory manner and in a signifier of a pyramid or a bifurcate 1. [ 8 ]
2. Network Database: In this theoretical account, it is possible to associate each statement or information with other informations or other information related. There are no bounds to this linkage as any constituent that can be associated with many other elements related.The Network Database is richer than Hierarchy Database, but reflects a corresponding trouble in the direction where the information is hard to interrupt the nexus between the informations and its each other. [ 8 ]
3. Relational Database: This theoretical account is the most modern and normally used in forming and screening informations base which is dependent chiefly on the concatenation that could associate things and these relationships are frequently reviewed in the signifier of planar tabular arraies. [ 8 ]
1.3. The cyberspace:
Internet is a immense aggregation of webs linked to each other, linking computing machines via telephone line, and through this device user can direct up any information, and receives what they want. [ 9 ]
The Internet was introduced in all countries of life, there are particular sites for intelligence, and other assorted thoughts. There are specialised sites of scientific, economic, societal, commercial professional amusing, political, spiritual and administrative. Internet has made the obvious effects in the communicating system of the new universe, until it has become the first planetary forum, and the greatest planetary library. For the first clip in history, cyberspace has enabled eternal Numberss of people to pass on with each other easy and swimmingly, utilizing sound and picture unrecorded and direct of import with a small fiscal cost. It has entered the orbiter telecasting, day-to-day newspapers, periodicals, and most other agencies of communicating. Read also are newspapers necessary nowadays
1.4. Word broad web:
The World Wide Web stands for word broad web and it is the chief manner to entree the sites on the presentation of any information available on the Internet. Users can busy a big portion of the Internet if they include a huge array of paperss which are posted on web pages that are stored and saved in the computing machines around the universe. [ 11 ]
1.5. The web site:
Web site is a aggregation of text paperss interdependent that are stored in web waiters ( hypertext paperss ) . The chief rules for any web site are:
aˆ? Design ( layout ) .
aˆ? Content ( Content ) .
aˆ? Links ( links ) .
The web sites can be classs in two types harmonizing to the manner of doing such as:
1. Inactive Web Page
2. Dynamic Web Page
1.5.1. The inactive web page:
Sites that have ever the same consequences upon petition from users. Users prefer to utilize this merchandise in simple and little locations that do non hold changeless updating.
1.5.2. Dynamic Web Page:
They are the sites that offer different consequences harmonizing to the information provided by the user, like university web sites where the pupil enters the file figure and watchword so put up his or her consequences or stuffs available to them and these consequences and stuffs vary harmonizing to the informations file figure and watchword.
1.6. The nexus between database and web sites:
Database is driven web sites that are all on scopes nowadays.A They fundamentally consist of a back-end database with web pages that contain script scheduling linguistic communication capable of drawing specific information from the database depending on what the user wants to cognize.
Analyze and design
2.1. Database types:
There are many database types such as
2.1.1. Hierarchical Database:
The information is organized in the signifier of hierarchy or any signifier of upside-down tree root at the top and out of the subdivisions. It is like a construction of a household tree and with several kids, boies, grandchildren and parents.
Files and hierarchal files are the same physique tree and have the same dealingss. Among the records is an illustration of some types of records that can be found in the composing hierarchy, there are records of gross revenues multiple for each seller, where no record of statistics, one for each procedure. Records of clients for each seller are available every bit good as several records for each client accounts debitors with each marketer.
It is of import to understand that it is non necessary to associate all the files in the database with each other. All that is required is to associate the files that are used in combination with each other in applications. The records of old gross revenues that have such a logical relationship are called a set. The Category Set is a aggregation of records connected with each other logically.
On this database can go a pyramid which is a digest of files and classs of files that are connected with each other logically. [ 5 ]
2.1.2. Database Network:
Data which is stored in the web construction are ironss of interrelated informations, and therefore this construction represents the logical dealingss in a more complex manner. The users still users use web databases systems with database direction systems for big computing machines. This regulation represents a form dealingss, much to the – many of the records. For illustration, pupils dealingss with multi-courses with different professors and many other multiple words where the donee can entree to the informations point by choosing the class of several waies and entree informations. Despite its imperfectness and inflexibleness every bit good as its trouble or complications in footings of scheduling and care, it deals with information expeditiously.
Furthermore, it is besides a more flexible construction than the hierarchal theoretical account or relational theoretical account, but what pays for it is in treating clip and specialisation of types. Some object-oriented database systems is used as a general web theoretical account, but most have some hierarchal restrictions.
The nervous web is an of import modern illustration of a web database. It has a big figure of similar simple treating units, correspondent to nerve cells in the human encephalon that learn the differences and similarities among a figure of its inputs. At one clip the weights are assigned to different connexions among beds of neuron-like treating units which constitute a set of averments about what is most closely related to. [ 5 ]
2.1.3. Relational Database:
One of the most types used widespread, particularly after the outgrowth of packaged systems, The formation of the database construction of tabular arraies are called dealingss and each tabular array consists of columns which represent Fieldss and rows. They represent records and are linked to the tabular array through the Fieldss Key ( The key field and the secondary cardinal field ) and can easy be integrated with information from assorted beginnings. They are more flexible than other types of databases, but the most of import jobs confronting this type are failings in the efficiency of intervention, where the response clip can be slow if there is a big figure of petitions for entree to data that is selected and the petition and retrieval of tabular arraies. [ 6 ]
Furthermore, the relational database of the most of import databases is characterized as the base informations received by users in the signifier of coupled tabular arraies that are created in the database. These tabular arraies include records and rows and Fieldss and columns which is the most widespread and normally used.
The record is a aggregation of storage units include all the information on one component of the elements of the database while the field is the presentation of the statement given to all elements of the database. For illustration, if we create a database for a school, each pupil is a component and the pupil informations is a record of the statement represents the age of the pupils of the field. [ 6 ]
2.1.4. Principles of Relational Database:
A proven truth is normally argued that the simplest is the most beautiful and efficient. The more you live merely, the less jobs you have. Similarly, when a machine is simple, its direction and care is facilitated. This was confirmed by covering with databases and the hierarchal web, which are complicated files and direction methods to the point threatened to take the new applications that are added or new demands, which require new indexs, including big and keeping.
These jobs were the get downing point for hunt for solutions and do these ends:
It can understand the database for those who did non analyze Computer Science.
2. It can modify, add, and delete informations without altering the logical scheme of the database.
3. It allows the user to the highest grade of flexibleness in covering with the informations
2.1.5. Relational Database Contains:
Relationss: are a procedure through which they link the database tables with each other to derive entree to all information for the point you want.
Field: Is a specific point within the record that is specified in footings of type and size is determined by the database.
Record: A record is a individual line in the tabular array and contains a set of Fieldss
Table: Is a set of records and every record is a line within a tabular array, and these records contain information from the same type. This means that the tabular array is a aggregation of records, “ rows ” and a set of Fieldss “ columns. ”
5. Database: Is a set of informations tabular arraies that contain information related to each other, besides contains a set of restraints and specifications for each tabular array. And it can incorporate a database tabular array informations or more.
2.1.6. Relational Database belongingss:
1. Each tabular array in a relational database comprises one type of repeating records.
2. There is no peculiar order of the Fieldss.
3. There is no peculiar order of records – both at the top of the tabular array or anyplace else in him.
4. There is merely one value for each field ( non iterative ) .
5. For each record field or several Fieldss is the key to separate it from any other record in the same tabular array.
6. Commands to cover with the database is non limited to four ( take – Event – Delete – Enter ) but use other instructions such as articulation “ nexus ” with the footings and mathematical footing in covering with this affair.
7. It allows you to relational databases by uniting informations from different tabular arraies to acquire new information.
8. If you change the information in one of the tabular arraies, the information will alter on all related tabular arraies. And it will salvage you clip because you would alter the informations merely one time.
2.1.7. Advantages of Relational Database:
1. Structural independency
2. Improved conceptual simpleness
3. Easy database to plan it
4. Powerful database direction system. [ 6 ]
2.1.8. Disadvantage of Relational Database:
1. expensive of puting up and keeping the database system
2. Less experient database interior decorators may develop hapless database design
3. Substantial hardware and system package operating expense. [ 6 ]
2.1.9. The difference between all database types:
The hierarchical and web database usage links and indexs ( arrows ) to associate records together in a system, called the Systems in Static or pack. This is because that the records are linked together physically by their definitions, and characteristics of these systems need complex work and hard accommodation, but it is the velocity of entree that cover such imperfectnesss. In the new relational linkage among the records, they are non being physically showed through the indexs, but by the existent names of Fieldss, like a field employee figure ID, or a field name or field ID card.. etc,
Registers in this system are addressable contents to being accessed by fiting informations values stored with each other.
2.2. Web sites types: there are two types of web sites such as
2.2.1. Inactive web site:
This Web sites is the regular containing text, images and other agencies of show text and Graphics fixed and Animated, harmonizing to the content of the pages and the subject of the site. However, these sort of sites do non incorporate the possibility of altering its variable informations dynamically or database which can update the informations from which, necessitating alteration any information or image utilizing the tools and linguistic communications to develop sites and so re-posted on the cyberspace once more. of class, the figure of pages the site offers is limited and can be added more at any clip in conformity with the needed content of the site. [ 10 ]
2.2.2. Advantage of inactive web site:
Easy to make
2. hard to interrupt
3. the velocity of shoping through the Internet
A A A A A A A A A A
2.2.3. Disadvantage of inactive web site:
Maintenance really hard, particularly when spread outing the site, as you will hold to modify some of 3000 files, alternatively of two files or three
2. Difficult to update and develop on a day-to-day
3. Servicess that can be created by this type of sites is really little, and limited merely to offer no more, no lupus erythematosus
4. Faces unsurmountable job with some companies distributed Internet. [ 1 ]
2.2.4 Dynamic web sites:
These are the sites that offer different consequences harmonizing to the information provided by the user, such as university web sites, where it enters the pupil file figure and watchword and so put up his consequences or stuffs available to him These consequences and stuffs vary depending on the information ( file figure and watchword )
In the first category, it is ever acquiring the same consequences since it can non make a database incorporating the names of pupils and their classs, and all information about them.
Furthermore, this is the sort of sites which are more developed inactive sites that allow alteration, add, or take any information or images of pages and tabular arraies rather easy by the proprietor of the site or asked about any clip the proprietor wants for any figure of times without mention to the website interior decorator or company designed. the debut is shown through information, spreadsheets and images in dynamic pages sites and through big databases to let add-on. The uninterrupted updating of pages is called the dynamic site, and the site proprietor or decision maker to pull off updates the location informations through the control panel locked ever with a watchword known merely to the responsible director of the site.
Dynamic websites empower their proprietors with the ability to upload and alteration information on their web sites, sooner through watchword protected administrative interfaces.
Most big web sites are dynamic, since they are easier to keep than inactive web sites. This is because inactive pages each contain alone content, intending they must be manually opened, edited, and published whenever a alteration is made. Dynamic
pages, on the other manus, entree information from a database. Therefore, to change the content of a dynamic page, the webmaster may merely necessitate to update a database record.
While a dynamic web site typically cost more because of its complexness, it can be a more cost effectual solution on the long tally. A dynamic web site is the most effectual solution for sites with content necessitating frequent updates and/or interaction with the visitants. [ 1 ]
2.2.5. Advantage of dynamic web sites:
Easy of care
the possibility of updating the site easy
The ability to seek the site
Possibility of sorting all stuffs published on the site
the possibility of the purchase and donate through the site
entree to accurate information about the users who enter the site like ( from which state, what is more material that they see it, come ining hours )
2.2.6. Disadvantage of dynamic web site:
May face many of the bugs that could do failures in the site is to the full operational
Browse this types of sites demands to be more clip
This sort of sites is in the scope where hackers penetrated and its easier to interrupt the first type
Making this type of sites you need to high experience [ 1 ]
3.1.the undertaking diagram:
This block diagram show us the system of web based enrollment system in usage instance scheme demoing in Figure 3.1
Add and bead page
The hebdomadal agenda page
The Admin page
Figure 3.1: Use instance block diagram
3.2. The database of the undertaking:
The undertaking contain many tabular arraies such as
3.2.1. The chief database tabular array:
As show in Figure 3.2 the database contains 6 tabular arraies which include category, classs, etcaˆ¦
Figure 3.2.the chief tabular array
3.2.2. Class tabular array:
The tabular array contains the inside informations of each category as shown in Figure 3.3 and all the tabular array inside informations show in Table3.1
Figure 3.3.class tabular array
1- ClID – the ID of the tabular array
2- ClName – Name of the category
3- ClStart – when the category starts
4- ClEnd – when the category ends
5- ClDays – This category in which yearss
ClSeats – Entire figure of place in the category 6-
7- ClAvailableSeats – available seats in this category
8- CID – the ID of the Course which this category in
9- LID – Lecture ID of this category Table3.1.details of categories table
3.2.3. Course tabular array:
The tabular array contains the inside informations of each Course as shown in Figure 3.4 and all the tabular array inside informations show in Table3.2
Figure 3.4.course tabular array
1- CID – the ID of the tabular array
2- CName – Name of the class
3- CCost – the cost of the class
3- CCridit – the Credit of the class
4- SID – the ID of the Semester witch the class in
Table3.2.details of classs table
3.2.4. Lecture tabular array:
The tabular array contains the inside informations of each Lecture as shown in Figure 3.5 and all the tabular array inside informations show in Table3.3
Figure 3.5.Lecture tabular array
1- LID – the ID of the tabular array
2- LName – the name of the talk
3- LNat – the nationality of the talk
Table3.3.details of Lecture tabular array
3.2.5. Simster tabular array:
The tabular array contains the inside informations of each simster as shown in Figure 3.6 and all the tabular array inside informations show in Table3.4
Figure 3.6.Simster tabular array
Table3.4.details of Simster tabular array
1- SID – the ID of the tabular array
2- SName – the name of the semester
3.2.6. Student category tabular array:
The tabular array contains the inside informations of each Student category as shown in Figure 3.7 and all the tabular array inside informations show in Table3.5
Figure 3.7.Student category tabular array
1- ID – the ID of the tabular array
2- StID – the ID of the Student
3- ClID – the ID of the category
Table3.5.details of Student category tabular array
3.2.7. Student tabular array:
The tabular array contains the inside informations of each Student category as shown in Figure 3.8 and all the tabular array inside informations show in Table3.6
Figure 3.8.Student tabular array
StID – the ID of the tabular array
StFName – Student foremost Name
StLName – Student last name
StAge – Student age
StSex – pupil sex
StEmail – Student electronic mail
StSemister – Student semester
StCridit – Student allowed credits
StUsername – Student login username
StPassword – Student login watchword
Table3.6.details of Student tabular array
3.2.8. The relationships:
There are many relationships between the undertaking tabular array show in figure 3.9 such as:
Students table linked to Classs with Many-Many ( each Student has many Classs and each Class has many Students ) so we break this relation into two One-Many dealingss so that it become Students table linked to StudentClass with One-Many ( each Student has many Classes ) and Classes tabular array linked to StudentClass with One-Many ( each Class has many Students )
Classs tabular array linked to Courses table with Many-One ( each Course has many Classs )
Classs tabular array linked to Lecture with One-One ( each Class has One Lecture )
Courses table linked to Semister tabular array with Many-One ( each Semester has many Courses )
3.3. Web site:
The web site of the undertaking contains the followers:
The page shows pupil and the admin can login in to he /she username and watchword for entree to the web site as shown in Figure 3.10
Figure 3.10.Login page
3.3.2. Add and drop page:
The page it shows us what the classs are available to the pupil so he / she can add,
Drop, and exchange categories and demoing us the cost of each class and how many credits
Have each class and the talk name of each categories and when the category starting and
Ending clip and we can see the available seats of each category. And demoing us one of
Student has already register to some classs as shown in Figure 3.11
Figure 3.11.Add and bead
3.3.3. The hebdomadal agenda page:
The figure demoing us the hebdomadal agenda for one of the pupils screening from Sunday
To Thursday and he can see the clip of each category as shown in Figure 3.12
Figure 3.12.weekly agenda
3.3.4. The admin page:
The page the admin can add new pupils and take all the information from the pupil
Like first name, last name, age, sex, and electronic mail to the enrollment system so he / she can
Entree to the system as shown in Figure 3.13
Figure 3.13.admin page
3.3.5. Error message 1:
The page mistake message appear because Students ca n’t travel over 18 credits and we can see
The counter of each entire cost and recognition as shown in Figure 3.14
Figure 3.14.error message 1
3.3.6. Error message 2:
The page mistake message appear because the pupil tray to register a category which already
He/she registry on it as shown in Figure 3.15
Figure 3.15.error message 2
3.3.7. Error message 3:
The page mistake message appear because the pupil tray to register a category which already
Have category in the same clip as shown in Figure 3.16
Figure 3.16.error message 3
3.3.8. Error message 4:
The page mistake message appear because the pupil tray to register a category but he can non
Because there are no available seats for some category as shown in Figure 3.17
Figure 3.17.error message 4
3.3.9. Error message 5:
The page mistake message appear because the pupil tray to login in to the enrollment
System but he entered incorrect username or watchword as shown in Figure 3.18
Figure 3.18.error message 5
Decisions and future work
This undertaking would be first measure for any other academic Institution and The most
of import facet of this undertaking is the pupil can register any Time any manner.
The web-based pupil enrollment system is a undertaking for the limited
Sum of clip so This undertaking provides a simple manner with a simple interface of the
Existing enrollment system
4.2. Future work:
The pupil in the enrollment system can non see the classs in terminal of semester
and there are no restriction day of the month for enrollment the classs so it should be a dead line
For registry. The informations base should be more secure than what we use and the
Registration system do n’t hold print bid to publish the hebdomadal agenda page that
Can be added in the hereafter.