Develop a College Education File System backed up by a relational Database. There will be two users for this application i.e. Admin and registered use
[Test
Phase] Problem Statement for project: College Education File System
Develop a College Education File System backed up by a relational Database. There will be two users for
this application i.e. Admin and registered users
Following are the tasks Admin can perform:
|
Tasks |
Login
to the system with id and password. |
|
View
all pending files |
|
|
Access to add the file record |
|
|
Update status of pending files to mark as
received |
|
|
Delete and Update 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). Detail
of table is as follow:
|
Column Name |
Data Type |
|
name |
Varchar(50) |
|
id [primary key] |
Integer |
|
password |
Varchar(50) |
|
emailid |
Varchar(100) |
|
contact |
Varchar(100) |
When trying to log in, the system shall check for correct id and
password. If incorrectly entered by the user, system shall show error message.
Task 2
1.
Two tables (UserType and UserDetails) are
required for storing details of Users, the relationship will be 1 to many from
UserType table to UserDetails table.
2.
The columns and datatypes of these columns
shall be:
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 |
UserType
|
Column Name |
Data Type |
|
usertypeid [primary key] |
Integer |
|
typetitle |
Varchar(50) |
Task 3
You have to design Main interface as per
following sample screen shot.
Task 4
You have to deisgn
Login interface as per following sample :
Task 5
User will be able to register himself/
herself by clicking 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 any user don't enter the Access code then
he/she will not be allowed for registration.
You have to deisgn
Registration interface as per following sample :
Task 6
Admin should be able to add file
Record whereas file attachment is not required just need to add all required
information related to file.
You have to deisgn
Add File Record as per following sample :
Task 7
Admin should be able to view all pending
files and Mark as received any pending status. Amin should also be able to
delete and update any file record.
You have to deisgn
interface as per following sample :
Remember you have to apply following concepts
for the test phase:
Syntax and Logical errors
Exception Handling
Class and Object
OOP concepts [Inheritance, Association, Aggregation, Composition, Polymorphism]
Collections
Multi Dimensional Arrays
Forms/GUIs
Database Operations [Create, Read, Update, Delete etc.]
Project Review Video:
Click here to Join This WhatsApp Group If you want this VU Collage Education File System Project Test Phase complete code with database
Post A Comment: