A computer is a landmark development of mankind civilization. It is also a nowadays characteristic in the various fields of science, industry, economic and military as they provide to humans from the speed and accuracy in completing many of the calculations and routine and ability to save and retrieve information in a timely manner to make the right decisions. Computer science and the databases have recently entered in all areas of life from simple library household organization to the large public libraries .The draft registration system is a correlation between student databases and the Internet.
This chapter contains and includes brief principles and definitions of websites and database types in general.
1.2. The database:
Database is a coherent set of data which can be used to extract the information you want or a group of very large amount of data and information presented in an easier way to find. For example, the telephone directory is the simplest database that can be dealt with as you can record your friends names and phone numbers and where you can later look for the name of a friend's engagement by entering a number or address and so on . There is another definition of the database which is an ordered list of data that can provide a way to access quick and easy methodology of information on a systematically selected point. It is considered that any organized group such as the story as a database here, cannot secure the arrival of a methodology for information that does not exist in the story which is not going according to a specific sequence of events . the most common examples of databases of this concept is the phone book and dictionary.
1.2.1. Advantage of the database:
The provision of required information is at breakneck speed in record time if it is compared to working or simple manual systems for data storage handling.
2. The possibility of sharing in the data:
The database management systems could provide the same data to more than one user and that is through the development of the database on a separate device called server. the system and its data can be connected and accessed by using a database management system.
3. Easy to use:
Database management which is easy to use by normal users . They do not need a specialist or professionals to deal with other systems. It is a very easy system to use and not complex.
4. Confidentiality and security of data:
The advantages of data management systems are multi-user who can handle data at the same time, A secret art and information security will provide the confidentiality and will not allow to have shame and a grave mistake by providing the opportunity for all users to see all the data without permission.
1.2.2 .Database types:
1. Hierarchy Database: It is considered the most forward and the form here is organizing and arranging data in a compulsory way and in a form of a pyramid or a forked one.
2. Network Database: In this model, it is possible to link each statement or information with other data or other information related. There are no limits to this linkage as any component that can be associated with many other elements related .The Network Database is richer than Hierarchy Database, but reflects a corresponding difficulty in the management where the data is difficult to break the link between the data and its each other.
3. Relational Database: This model is the most modern and commonly used in organizing and sorting data base which is dependent mainly on the chain that could link things and these relationships are often reviewed in the form of two-dimensional tables.
1.3. The internet:
Internet is a huge collection of networks linked to each other, connecting computers via telephone line, and through this device user can send up any information, and receives what they want.
The Internet was introduced in all areas of life, there are special sites for news, and other various ideas. There are specialized sites of scientific, economic, social, commercial professional comic, political, religious and administrative. Internet has made the obvious effects in the communication system of the new world, until it has become the first global forum, and the greatest global library. For the first time in history, internet has enabled endless numbers of people to communicate with each other easily and smoothly, using audio and video live and direct important with a little financial cost. It has entered the satellite television, daily newspapers, periodicals, and most other means of communication.
1.4. Word wide web:
The www stands for word wide web and it is the main way to access the sites on the presentation of any information available on the Internet. Users can occupy a large part of the Internet if they include a vast array of documents which are posted on web pages that are stored and saved in the computers around the world.
1.5. The website:
Web site is a collection of text documents interdependent that are stored in web servers (hypertext documents). The main principles for any website are:
â€¢ Design (layout).
â€¢ Content (Content).
â€¢ Links (links).
The websites can be categories in two types according to the way of making such as :
1. Static Web Page
2. Dynamic Web Page
1.5.1. The static web page:
Sites that have always the same results upon request from users. Users prefer to use this product in simple and small locations that do not have constant updating.
1.5.2. Dynamic Web Page:
They are the sites that offer different results according to the information provided by the user, like university websites where the student enters the file number and password then put up his or her results or materials available to them and these results and materials vary according to the data file number and password.
1.6. The link between database and web sites:
Database is driven web sites that are all on ranges nowadays.Â They basically consist of a back-end database with web pages that contain script programming language capable of pulling specific information from the database depending on what the user wants to know.
Analyze and design
2.1. Database types:
There are many database types such as
2.1.1. Hierarchical Database:
The data is organized in the form of hierarchy or any form of inverted tree root at the top and out of the branches. It is like a structure of a family tree and with several children, sons, grandchildren and parents.
Files and hierarchical files are the same build tree and have the same relations. Among the records is an example of some types of records that can be found in the composition hierarchy, there are records of sales multiple for each vendor, where no record of statistics, one for each process. Records of customers for each vendor are available as well as several records for each client accounts debtors with each seller.
It is important to understand that it is not necessary to relate all the files in the database with each other. All that is required is to relate the files that are used in combination with each other in applications. The records of previous sales that have such a logical relationship are called a set. The Category Set is a collection of records connected with each other logically.
On this database can become a pyramid which is a compilation of files and categories of files that are connected with each other logically.
2.1.2. Database Network:
Data which is stored in the network structure are chains of interconnected data, and thus this structure represents the logical relations in a more complex way. The users still users use network databases systems with database management systems for large computers. This rule represents a pattern relations, much to the - many of the records. For example, students relations with multi-courses with different professors and many other multiple words where the beneficiary can access to the data item by selecting the course of several paths and access data. Despite its imperfection and inflexibility as well as its difficulty or complications in terms of programming and maintenance, it deals with information efficiently.
Moreover, it is also a more flexible structure than the hierarchical model or relational model, but what pays for it is in processing time and specialization of types. Some object-oriented database systems is used as a general network model, but most have some hierarchical limitations.
The neural network is an important modern example of a network database. It has a large number of similar simple processing units, analogous to neurons in the human brain that learn the differences and similarities among a number of its inputs. At one time the weights are assigned to different connections among layers of neuron-like processing units which constitute a set of assertions about what is most closely related to. 
2.1.3. Relational Database:
One of the most types used widespread, especially after the emergence of packaged systems, The formation of the database structure of tables are called relations and each table consists of columns which represent fields and rows . They represent records and are linked to the table through the fields Key (The key field and the secondary key field) and can easily be integrated with information from various sources. They are more flexible than other types of databases, but the most important problems facing this type are weaknesses in the efficiency of treatment, where the response time can be slow if there is a large number of requests for access to data that is selected and the request and retrieval of tables.
Furthermore, the relational database of the most important databases is characterized as the base data received by users in the form of linked tables that are created in the database. These tables include records and rows and fields and columns which is the most widespread and commonly used.
The record is a collection of storage units include all the information on one element of the elements of the database while the field is the presentation of the statement given to all elements of the database. For example, if we create a database for a school, each student is a element and the student data is a record of the statement represents the age of the students of the field.
2.1.4. Principles of Relational Database :
A proved truth is commonly argued that the simplest is the most beautiful and efficient. The more you live simply, the less problems you have. Similarly, when a machine is simple, its management and maintenance is facilitated. This was confirmed by dealing with databases and the hierarchical network, which are complicated files and management methods to the point threatened to lead the new applications that are added or new requirements, which require new indicators, including large and holding.
These problems were the starting point for search for solutions and make these goals:
It can understand the database for those who did not study Computer Science.
2. It can modify, add, and delete data without changing the logical schema of the database.
3. It allows the user to the highest degree of flexibility in dealing with the data
2.1.5. Relational Database Contains:
Relations: are a process through which they link the database tables with each other to gain access to all information for the item you want.
Field: Is a specific item within the record that is specified in terms of type and size is determined by the database.
Record : A record is a single line in the table and contains a set of fields
Table: Is a set of records and every record is a line within a table, and these records contain information from the same type. This means that the table is a collection of records, "rows" and a set of fields "columns."
5. Database: Is a set of data tables that contain information related to each other, also contains a set of constraints and specifications for each table. And it can contain a database table data or more.
2.1.6. Relational Database properties:
1. Each table in a relational database comprises one type of recurring records.
2. There is no particular order of the fields.
3. There is no particular order of records - both at the top of the table or anywhere else in him.
4. There is only one value for each field (not iterative).
5. For each record field or several fields is the key to distinguish it from any other record in the same table.
6. Commands to deal with the database is not limited to four (choose - Event - Delete - Enter) but use other instructions such as join "link" with the terms and mathematical basis in dealing with this matter.
7. It allows you to relational databases by combining data from different tables to get new information.
8. If you change the data in one of the tables, the data will change on all related tables. And it will save you time because you would change the data only once.
2.1.7. Advantages of Relational Database:
1. Structural independence
2. Improved conceptual simplicity
3. Easy database to design it
4. Powerful database management system.
2.1.8. Disadvantage of Relational Database:
1. expensive of setting up and maintaining the database system
2. Less experienced database designers may develop poor database design
3. Substantial hardware and system software overhead.
2.1.9. The difference between all database types :
The hierarchical and network database use links and indicators (pointers) to link records together in a system, called the Systems in Static or compact. This is because that the records are linked together physically by their definitions, and features of these systems need complex work and difficult adjustment, but it is the speed of access that cover such imperfections. In the new relational linkage among the records, they are not being physically showed through the indicators, but by the real names of fields, like a field employee number ID, or a field name or field ID card.. etc,
Registries in this system are addressable contents to being accessed by matching data values stored with each other.
2.2. Websites types: there are two types of websites such as
2.2.1. Static web site:
This Web sites is the regular containing text, images and other means of display text and Graphics fixed and Animated, according to the content of the pages and the theme of the site. However, these kind of sites do not contain the possibility of changing its variable data dynamically or database which can update the data from which, requiring change any information or image using the tools and languages to develop sites and then re-posted on the internet again. of course, the number of pages the site offers is limited and can be added more at any time in accordance with the required content of the site.
2.2.2. Advantage of static web site :
Easy to create
2. difficult to break
3. the speed of browsing through the Internet
Â Â Â Â Â Â Â Â Â Â
2.2.3. Disadvantage of static web site :
Maintenance very difficult, especially when expanding the site, as you will have to modify some of 3000 files, instead of two files or three
2. Difficult to update and develop on a daily
3. Services that can be created by this type of sites is very small, and limited only to offer no more, no less
4. Faces insurmountable problem with some companies distributed Internet.
2.2.4 Dynamic websites:
These are the sites that offer different results according to the information provided by the user, such as university websites, where it enters the student file number and password and then put up his results or materials available to him These results and materials vary depending on the data (file number and password)
In the first class, it is always getting the same results since it cannot create a database containing the names of students and their grades, and all information about them.
Moreover, this is the kind of sites which are more developed static sites that allow change, add, or remove any information or pictures of pages and tables quite easily by the owner of the site or asked about any time the owner wishes for any number of times without reference to the website designer or company designed. the introduction is shown through information, spreadsheets and images in dynamic pages sites and through large databases to allow addition . The continuous updating of pages is called the dynamic site, and the site owner or administrator to manage updates the location data through the control panel locked always with a password known only to the responsible manager of the site.
Dynamic websites empower their owners with the ability to upload and change information on their websites, preferably through password protected administrative interfaces.
Most large websites are dynamic, since they are easier to maintain than static websites. This is because static pages each contain unique content, meaning they must be manually opened, edited, and published whenever a change is made. Dynamic
pages, on the other hand, access information from a database. Therefore, to alter the content of a dynamic page, the webmaster may only need to update a database record.
While a dynamic website typically cost more because of its complexity, it can be a more cost effective solution on the long run. A dynamic website is the most effective solution for sites with content requiring frequent updates and/or interaction with the visitors.
2.2.5. Advantage of dynamic websites:
Easy of maintenance
the possibility of updating the site easily
The ability to search the site
Possibility of classifying all materials published on the site
the possibility of the purchase and donate through the site
access to accurate information about the users who enter the site like (from which country, what is more material that they see it, entering hours)
2.2.6. Disadvantage of dynamic website:
May face many of the bugs that could cause failures in the site is fully operational
Browse this types of sites needs to be more time
This kind of sites is in the range where hackers penetrated and its easier to break the first type
Making this type of sites you need to high experience
3.1.the project diagram:
This block diagram display us the system of web based registration system in use case strategy showing in Figure 3.1
Add and drop page
The weekly schedule page
The Admin page
Figure 3.1: Use case block diagram
3.2. The database of the project:
The project contain many tables such as
3.2.1. The main database table :
As show in Figure 3.2 the database contains 6 tables which include class, courses,etcâ€¦
Figure 3.2.the main table
3.2.2. Class table:
The table contains the details of each class as shown in Figure 3.3 and all the table details show in Table3.1
Figure 3.3.class table
1- ClID - the ID of the table
2- ClName - Name of the class
3- ClStart - when the class starts
4- ClEnd - when the class ends
5- ClDays - This class in which days
ClSeats - Total number of seat in the class 6-
7- ClAvailableSeats - available seats in this class
8- CID - the ID of the Course which this class in
9- LID - Lecture ID of this class Table3.1.details of classes table
3.2.3. Course table:
The table contains the details of each Course as shown in Figure 3.4 and all the table details show in Table3.2
Figure 3.4.course table
1- CID - the ID of the table
2- CName - Name of the course
3- CCost - the cost of the course
3- CCridit - the Credit of the course
4- SID - the ID of the Semester witch the course in
Table3.2.details of courses table
3.2.4. Lecture table:
The table contains the details of each Lecture as shown in Figure 3.5 and all the table details show in Table3.3
Figure 3.5.Lecture table
1- LID - the ID of the table
2- LName - the name of the lecture
3- LNat - the nationality of the lecture
Table3.3.details of Lecture table
3.2.5. Simster table :
The table contains the details of each simster as shown in Figure 3.6 and all the table details show in Table3.4
Figure 3.6.Simster table
Table3.4.details of Simster table
1- SID - the ID of the table
2- SName - the name of the semester
3.2.6. Student class table :
The table contains the details of each Student class as shown in Figure 3.7 and all the table details show in Table3.5
Figure 3.7.Student class table
1- ID - the ID of the table
2- StID - the ID of the Student
3- ClID - the ID of the class
Table3.5.details of Student class table
3.2.7. Student table :
The table contains the details of each Student class as shown in Figure 3.8 and all the table details show in Table3.6
Figure 3.8.Student table
StID - the ID of the table
StFName - Student first Name
StLName - Student last name
StAge - Student age
StSex - student sex
StEmail - Student email
StSemister - Student semester
StCridit - Student allowed credits
StUsername - Student login username
StPassword - Student login password
Table3.6.details of Student table
3.2.8. The relationships:
There are many relationships between the project table show in figure 3.9 such as :
Students table linked to Classes with Many-Many (each Student has many Classes and each Class has many Students) so we break this relation into two One-Many relations so that it become Students table linked to StudentClass with One-Many (each Student has many Classes) and Classes table linked to StudentClass with One-Many (each Class has many Students)
Classes table linked to Courses table with Many-One (each Course has many Classes)
Classes table linked to Lecture with One-One (each Class has One Lecture)
Courses table linked to Semister table with Many-One (each Semester has many Courses)
The website of the project contains the following:
The page shows student and the admin can login in to he /she username and password for access to the website 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 courses are available to the student so he / she can add,
Drop, and exchange classes and showing us the cost of each course and how many credits
Have each course and the lecture name of each classes and when the class starting and
Ending time and we can see the available seats of each class. And showing us one of
Student has already register to some courses as shown in Figure 3.11
Figure 3.11.Add and drop
3.3.3. The weekly schedule page:
The figure showing us the weekly schedule for one of the students sorting from Sunday
To Thursday and he can see the time of each class as shown in Figure 3.12
Figure 3.12.weekly schedule
3.3.4. The admin page:
The page the admin can add new students and take all the information from the student
Like first name, last name, age, sex, and email to the registration system so he / she can
Access to the system as shown in Figure 3.13
Figure 3.13.admin page
3.3.5. Error message 1:
The page error message appear because Students can't go over 18 credits and we can see
The counter of each total cost and credit as shown in Figure 3.14
Figure 3.14.error message 1
3.3.6. Error message 2:
The page error message appear because the student tray to register a class which already
He/she register on it as shown in Figure 3.15
Figure 3.15.error message 2
3.3.7. Error message 3:
The page error message appear because the student tray to register a class which already
Have class in the same time as shown in Figure 3.16
Figure 3.16.error message 3
3.3.8. Error message 4:
The page error message appear because the student tray to register a class but he cannot
Because there are no available seats for some class as shown in Figure 3.17
Figure 3.17.error message 4
3.3.9. Error message 5:
The page error message appear because the student tray to login in to the registration
System but he entered wrong username or password as shown in Figure 3.18
Figure 3.18.error message 5
Conclusions and future work
This project would be first step for any other academic Institution and The most
important aspect of this project is the student can register any Time any way.
The web-based student registration system is a project for the limited
Amount of time so This project provides a simple way with a simple interface of the
Existing registration system
4.2. Future work:
The student in the registration system cannot see the grades in end of semester
and there are no limitation date for registration the courses so it should be a dead line
For register. The data base should be more secure than what we use and the
Registration system don't have print command to print the weekly schedule page that
Can be added in the future .