College Education File System Project
Develop a School Education File System backed up by a relational
Database. There will be two user for this application i.e. Admin and registered
users
Following are the tasks Admin can perform:
Task 1
|
Login
to the system with id and password.
|
Task 2
|
View
all pending files
|
Task 3
|
Admin have to access to add the file record
|
Task 4
|
Update status of pending files to mark as
received
|
Task 5
|
Delete and Edit any file record
|
Following are the tasks, user can perform:
Ø User
can register himself/herself
Ø View
currently status his/her of file
Following are the details for each task:
Task 1
There should be a separate table to
store Admin user details (such as name, id, password, emailid, contact). When
trying to log in, the system shall check for correct id and password. If
incorrectly entered, system shall show error message.
Column Name
|
Data Type
|
name
|
Varchar(50)
|
id [primary key]
|
Integer
|
password
|
Varchar(50)
|
emailid
|
Varchar(100)
|
contact
|
Varchar(100)
|
Task 2
Two tables are required for details of
Users, the relationship will be 1 to many from UserType table to UserDetails
table, the columns and datatypes of these columns shall be:
1.
UserDetails
Column Name
|
Data Type
|
name
|
Varchar(50)
|
user_id [primary key]
|
Integer
|
password
|
Varchar(50)
|
emailid
|
Varchar(100)
|
contact
|
Varchar(100)
|
usertype [forieng key from UserType table]
|
Integer
|
registerationdate
|
Date or Date Time
|
modifydate
|
Date or Date Time
|
2.
UserType
Column Name
|
Data Type
|
usertypeid [primary key]
|
Integer
|
typetitle
|
Varchar(50)
|
This
table will have two rows
usertypeid
|
typetitle
|
1
|
Temporary User
|
2
|
Permanent User
|
Task 2
User will be able to register himself/
herself by cling on register link on main page of system:
In the registration form you are
require to give access code for registration e.g (Access Code: VU-Test-Phase)
here you will use mask text. If anyuser don't enter the Access code then he/she
will not be allowed for registration.
Solution:
Video 01:
Video 02:
Video 03:
Video 04:
Video 05:
Video 06:
No comments: