We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

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.

 

 

 

 

 

 

 

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 .

 

 

 

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 .

 

 

 

 

 

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.

Remember you have to apply following concepts for the test phase 2:

 

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.]

chlo ab achy bachon ki trha sb log discuss kro

 

 

 

 


+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 1282

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Replies to This Discussion

Lgta sary bzi ziada ho gay hain.

ahooooooo

anybody share some idea

asaan hi hai ye tu

اگر آپ کو آسان لگتا ہے تو ابھی تک مکمل کیو ں نہیں کیا جب بنائوں گے تو پتہ چلے گا

if it is easy for you then kindly guide us also about it

i want to discuss about Access code what is this?

+►r_t◄(PHP proj) brother ya tu mushkil ha agr ap ko asaan lagta ha tu bna hi do.hamari help ho jai gi

یہ ضروری تو نہیں اس کو پی ایچ میں بنائے اس کو ڈاٹ نیٹ یا سی شارپ ، ویذول سٹوڈیو  میں بھی تو بنا سکتے ہیں

جس میں مرضی بنائیں پر کوئی سٹارٹ تو کرے کہ کرنا کس طرح ہے ؟

kindly explain......

 

1.After login by user what information will give by user to View currently status his/her of file.

2.user type....how many and where is user type in assignment.

3.what is access code and  its role in the assignment and how the user access the access code.

kindly explain......

 

1.After login by user what information will give by user to View currently status his/her of file.

2.user type....how many and where is user type in assignment.

3.what is access code and  its role in the assignment and how the user access the access code.

RSS

Latest Activity

ùήķήόώή şόùĻ replied to ùήķήόώή şόùĻ's discussion Dard ..
26 seconds ago
+"illegal weapon"++ posted a discussion
2 hours ago
+"illegal weapon"++ replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Gham e Ashiqi tera shukriya...!
2 hours ago
+AH+ updated their profile
2 hours ago
+++Ayesha+++ replied to 2.O's discussion Voice Password :P :P
3 hours ago
+++Ayesha+++ updated their profile
3 hours ago
+ ! Ryan updated their profile
3 hours ago
Anu malik mcs updated their profile
3 hours ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service