SYSTEM DESIGN
INPUT DESIGN
This can be controlled by input design by using menu, interactive dialogue, consistent
format etc. In this system the users are provided with user friendly pages to give the input and if
the user gives any wrong input validations are done and message boxes are provided in the
necessary places. The message specified in the message box is specified in a polite and in an
informative manner.
System is interactive dialogue, which simplifies the data entry or access, instead of
remembering what to enter. User can choose from a list of options and type it in the cursor
position. This will reduce the number of corrections while entering the data.
DATABASE DESIGN
The database design of project is designed in such a way values are kept without
redundancy and with normalized format. Refer the appendix for screen shots of database design.
Table name : Admin
Primary key : a_id
Field name Data type Width Description
a_id integer 10 Admin id
name char 20 Admin name
pwd varchar 20 Password
Table name : Staff
Primary key : stid
Field name Data type Width Description
stid integer 10 Staff id
stname varchar 20 Staff name
Table name : Student
Primary key : rollno
Field name Data type Width Description
rollno integer 10 Student roll no
dept varchar 20 Department
sem varchar 20 Semester
Table name : Department
Primary key : did
Field name Data type Width Description
did integer 10 Department id
rollno integer 10 Student roll no
dept varchar 20 Department
sem varchar 20 Semester
Table name : Semester
Primary key : sid
Field name Data type Width Description
sid integer 10 Semester id
rollno integer 10 Student roll no
dept varchar 20 Department
sem varchar 20 Semester
Table name : Seat arrangement
Primary key : id
Field name Data type Width Description
id integer 10 Seating id
room integer 20 Room number
row integer 20 Row number
depart varchar 15 Department
sem varchar 15 Semester
noofstu integer 20 Number of student
rollno varchar 15 Roll number
Inv1 varchar 15 Invigilator1
Inv2 varchar 15 Invigilator1
timing time - Timing
cancel varchar 10 Seat cancel
CODE DESIGN
Code is an order collection of symbols designed to provide unique identification of an
entry or attribute. Sometimes used in the place of name of the item they can be specified all
object’s physical or performances characteristics or operational instructions. They can also show
inter relationship and may sometime be used to achieve secrecy or confidentiality.
OUTPUT DESIGN
The proposed system is a web oriented system and hence it does not provide any reports.
The output results are viewed in the web pages itself. Outputs from the computer system are
required primarily to communicate the result of processing to users. They are also used to
override a permanent copy of the results for later consultation. The output reports and input
documents should be documented in terms of data content and approximate layout; it is not
necessary to define the methods of presentation. It is possible to work back for the output data
items are derived by calculations or by logical deduction.
DATA FLOW DIAGRAM
Level 0
Exam hall seat
Send Request
Admin arrangement system Student
Response
Level 1
Manage
Admin Login Student stu_db
Process Staff
staff_db
Process Department
dept_db
Process
Semester sem_db
Allocate seat
Seat arrangement
seat_db
Level 2
Invalid
Student Login Exit
Valid
Search Department dept_db
Search Semester sem_db
Search Seat info seat_db
ENTITY RELATIONSHIP DIAGRAM
stnme
stid
Manage
Admin Staff Details
dept
dept rollno
rollno
Add/ Update
Student details
sem
did sem
Department
row
room rollno dept
depart
id sid sem
sem
Process
Semester
noofstu
cancel
rollno
timing
Inv1
Inv2
