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

CS506 - Web Design and Development Assignment No. 1 Solution Fall 2018 Due Date: December 07, 2018

CS506 - Web Design and Development Assignment No. 1 Solution Fall 2018 Due Date: December 07, 2018 

 

Assignment No. 01
Semester: Fall 2018

CS506 – Web Design and Development

 

 

Total Marks: 20

 

Due Date: 07/12/2018

 

Uploading instructions:

 

  • Your assignment should be in .zip /.rar format.
  • Save your assignment with your ID (e.g. bc000000000.rar).
  • No assignment will be accepted through email.

 

Rules for Marking:

 

It should be clear that your assignment will not get any credit if:

 

·         The assignment is submitted after due date.

·         The submitted assignment does not open, execute or file is corrupted.

·         Your assignment is copied from internet, handouts or from any other student

      (Strict disciplinary action will be taken in this case).

 

Assignment

 

 

Question:     (20 Marks)

 

You are required to write a program in java that will contain two modules i.e. Login module and Registration module. Furthermore, create a new database in MS Access and add a table in the database. The name of database must be same as your own VU ID (like BC0000000) and the name of table should be Student. Student table will have six attributes i.e. Student ID, Name, Email, Address, Study Program and Password.

 

In Login module, design a graphical user interface (GUI) which will have two text boxes (Student ID and Password) and two buttons (Login and Register). When user enters information (Student ID and Password) and clicks Login button then search this Student ID and password in the database. If this Student ID exists in database and Password is valid then display all information against this ID on the screen using a GUI. Otherwise, show message that no such record exists in database against this ID or Password is incorrect.

 

In Registration module, when user clicks on Register button then a student registration interface should be opened to register a new student. The user registration interface will have seven text boxes (i.e. Student ID, Name, Email, Address, Study Program, Password, and Retype Password) and a Register button. When user enters information and clicks Register button then verify that:

 

  • Password and Retype Password fields are same.
  • Email is in proper format (i.e. abc@xyz.com).
  • No text box is empty.
  • Student ID is unique and not available in database. 

 

If entered Student ID already exists in database then show message that “Student is already registered”. After all this verification, insert this information in database and display a message “Student Registered Successfully”.

 

Also note that title of all graphical user interfaces should be your VU ID (like BC0000000).

 

 

 

 

Important Regarding Development:

 

If you are using JDK1.8 or above then you’ll have to use ucanaccess driver to connect to MS Access database. In this case, I'll suggest you to view the following tutorial.

 

https://vulms.vu.edu.pk/Courses/CS506/Downloads/UCanAccess.mp4

 

Following links will be helpful in creating new database in MS Access.

 

https://support.office.com/en-us/article/Create-a-new-database-32a1...

http://www.dummies.com/software/microsoft-office/access/how-to-buil...

https://www.wikihow.com/Make-a-Database-Using-MS-Access

 

 

Important Regarding Submission:

 

After completing your code, execute your java file(s) on command prompt and enter students’ records to store them in database. You must have to provide your own information while entering first student’s record otherwise marks will be deducted accordingly. Your database must contain at least one record (containing your own information i.e. your id, name, email, address, study program and etc.). Now, compress your java file(s) and database file using winzip or winrar and upload it on VULMS.

 

NOTE:  Do not put any query on MDB about this assignment, if you have any query then email at cs506@vu.edu.pk.  Furthermore, if any student found cheating from any other student or from online forums then he/she will be awarded ZERO right away and strict disciplinary action will be taken against the student.

 

 

 

Deadline: Your assignment must be uploaded/submitted on or before 7th December 2018.

 

+ How to Follow the New Added Discussions at Your Mail Address?

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 4431

.

+ 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?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

String sql = "SELECT * FROM Student WHERE StudentID= '"+id.getText()+"' and Password= '"+pass+"'"; used this query for login method

pleasea sighnmnt bna doi 

student id bc160202107

on my mail id rabiamustafa250@gmail.com

cs506 assignment bana dy koi  mc170200357 id meri   extendday muhammadsalmankhan466@gmail.com 

Yar mae jamat mae hun mery pas pc nh hai app mujh say contact kar lyen plz.
03217008113
Call sms aur what's app

jo assignment upload ki hai wo netbeans ma banay ahai project us ma open karen aur changing kr k submit kr lain.

Plz yar meri help kar dayn
Dastgeer194 plz help me
Please any one can send me solution ?
Mc170203047@vu.edu.pk
Any one contact me.
03217008113
Call sms aur what's app
Mery paas pc nh hai plz meri help kar dayn plz plz.

RSS

Latest Activity

Babar ali updated their profile
2 minutes ago
+ ! ! ! ! ! AaiMa AnsaRi liked + M.Tariq Malik's group MGT211 Introduction To Business
6 minutes ago
Purple Work replied to + M.Tariq Malik's discussion MGT503 Assignment No 01 Fall 2019 Solution & Discussion in the group MGT503 Principles of Management
17 minutes ago
Rameesha joined + M.Tariq Malik's group
17 minutes ago
Rameesha replied to + M.Tariq Malik's discussion MGT211 GDB Fall 2019 Solution & Discussion in the group MGT211 Introduction To Business
19 minutes ago
Rameesha joined + M.Tariq Malik's group
20 minutes ago
ghazni replied to + M.Tariq Malik's discussion CS311 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 15-11-2019 in the group CS311 Introduction to Web Services Development
22 minutes ago
ghazni joined + M.Tariq Malik's group
22 minutes ago
Rameesha posted a status
"Plz moje b reply kar do koi"
29 minutes ago
ghazni left a comment for Nabeel Ahmed
29 minutes ago
= + = Handsom MunDa# updated their profile
31 minutes ago
Sana fatima replied to + M.Tariq Malik's discussion CS304 Assignment No 01 Fall 2019 Solution & Discussion in the group CS304 Object Oriented Programming
31 minutes ago
Rameesha replied to + M.Tariq Malik's discussion Criteria Required for Award Badges, Featured Members & Moderators
35 minutes ago
Rameesha posted a status
"Plz send me solution of assignment no 1 of mth202"
42 minutes ago
Rameesha commented on + M.Tariq Malik's page Past Papers
43 minutes ago
Hamza - BCS (6th) and Saleem Maheen are now friends
46 minutes ago
Rameesha liked Ayaat's profile
47 minutes ago
Rameesha left a comment for Ayaat
47 minutes ago
Uzma liked + M.Tariq Malik's group PSY101 Introduction to Psychology
49 minutes ago
Waseem Aziz added a discussion to the group MGMT627 Project Management
52 minutes ago

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

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