Download Database System Development: UI, Data Validation, & Querying Across Multiple Tables and more Summaries Information Technology in PDF only on Docsity!
ASSIGNMENT 2 FRONT SHEET
Qualification BTEC Level 5 HND Diploma in Computing
Unit number and title Unit 04: Database Design & Development
Submission date 7/12/2023 Date Received 1st submission
Re-submission Date Date Received 2nd submission
Student Name Student ID
Class Assessor name
Student declaration
I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand that
making a false declaration is a form of malpractice.
Student’s signature
Grading grid
P2 P3 P4 P5 M2 M3 M4 M5 D2 D
❒ Summative Feedback: ❒ Resubmission Feedback:
Grade: Assessor Signature: Date:
Signature & Date:
- I. Introduction.........................................................................................................................................................................................................
- II. Content................................................................................................................................................................................................................
- Develop a fully functional relational database system, based on an existing system design...........................................................................
- 1.1. Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables........
- Test the system against user and system requirements................................................................................................................................
- 2.1. Test the system against user and system requirements........................................................................................................................
- Produce technical and user documentation..................................................................................................................................................
- 3.1. Produce technical and user documentation..........................................................................................................................................
- III. Conclusion......................................................................................................................................................................................................
- IV. References.....................................................................................................................................................................................................
- Figure 1: Database connection.................................................................................................................................................................................... Table of Figure
- Figure 2: Login form.....................................................................................................................................................................................................
- Figure 3: Data in "user" table.......................................................................................................................................................................................
- Figure 4: Enter correct username and password.........................................................................................................................................................
- Figure 5: Enter wrong username and password..........................................................................................................................................................
- Figure 6: SQL query for the login.................................................................................................................................................................................
- Figure 7: Take query....................................................................................................................................................................................................
- Figure 8:Home display.................................................................................................................................................................................................
- Figure 9: Class management display............................................................................................................................................................................
- Figure 10: SQL query for class......................................................................................................................................................................................
- Figure 11: Add function button....................................................................................................................................................................................
- Figure 12: Add Student Display..................................................................................................................................................................................
- Figure 13: Example for add student function (1).......................................................................................................................................................
- Figure 14:Example for add student function (2)........................................................................................................................................................
- Figure 15: Users don't enter information to add display...........................................................................................................................................
- Figure 16: Add Querry................................................................................................................................................................................................
- Figure 17:Edit button.................................................................................................................................................................................................
- Figure 18: Edit display................................................................................................................................................................................................
- Figure 19: Change student code................................................................................................................................................................................
- Figure 20: After edit...................................................................................................................................................................................................
- Figure 21: Edit Querry................................................................................................................................................................................................
- Figure 22:Delete button.............................................................................................................................................................................................
- Figure 23: Delete notify.............................................................................................................................................................................................
- Figure 24: After delete...............................................................................................................................................................................................
- Figure 25: Delete Querry...........................................................................................................................................................................................
- Figure 26: Grade display............................................................................................................................................................................................
- Figure 27: Add Grade (1)............................................................................................................................................................................................
- Figure 28: Add Grade (2)............................................................................................................................................................................................
- Figure 29:Add grade (3).............................................................................................................................................................................................
- Figure 30: Rating student (1).....................................................................................................................................................................................
- Figure 31: Rating Student (2).....................................................................................................................................................................................
- Figure 32: Export to excel..........................................................................................................................................................................................
- Figure 33: Add grade query.......................................................................................................................................................................................
- Figure 34: Rating Function.........................................................................................................................................................................................
- Figure 35: Show student who have Merit or Distinction............................................................................................................................................
- Figure 36: Statistics query..........................................................................................................................................................................................
- Figure 37: Logout function.........................................................................................................................................................................................
- Figure 38: Step 1........................................................................................................................................................................................................
- Figure 39: Step 2........................................................................................................................................................................................................
- Figure 40: Step 3........................................................................................................................................................................................................
- Figure 41: Step 4........................................................................................................................................................................................................
- Figure 42: Step 6........................................................................................................................................................................................................
- Figure 43: Step 7........................................................................................................................................................................................................
- Figure 44: Step 8........................................................................................................................................................................................................
- Figure 45: Step 9........................................................................................................................................................................................................
- Table 1: Test plan....................................................................................................................................................................................................... Table of Figure
- Table 2: Test case.......................................................................................................................................................................................................
II. Content
1. Develop a fully functional relational database system, based on an existing system
design.
1.1. Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables.
1.1.1. Connect to database
To get and show all data we need connect to database first.
Figure 1 : Database connection
1.1.2. Login interface
a) User interface
This login form that user can enter username and password to login
Figure 2 : Login form Figure 3 : Data in "user" table b) Input, output data and validation:
First, I made a SQL Query for the login function Figure 6 : SQL query for the login Secondly, I took data from SQL Query to check username and password. If username and password correct, it will allow user went into dashboard or if username and password incorrect, it will show Error message. Figure 7 : Take query
1.1.3. View function
a) User interface
That interface will help user can see program and information this program.
Figure 8 :Home display b) Input, output data You can see all items in this display and I will example for items “Class Manage”
Figure 10 : SQL query for class
1.1.4. Add Function
a) User interface This interface has necessary function help user can add more information to the table, you can press add button to add more information to the table.
Figure 11 : Add function button After press this button, add display will appear and you can add information to each row. With each row have another information in this table.
Figure 14 :Example for add student function (2) So, information you fill will appear in this table. If users don’t enter information to add display, there will be messaged notice. There is one of example if user don’t enter student code.
Figure 15 : Users don't enter information to add display c) Querry data: Code for this function: This is the SQL query for the add function Figure 16 : Add Querry
1.1.5. Edit Function
a) User interface: This interface that will help user can repair wrong information. You can see edit button near add button.
Figure 18 : Edit display Figure 19 : Change student code You can save after you edit by save button. And will return to student display with information edited.
Figure 20 : After edit c) Querry data This is the SQL query for the edit function
