Download Asm2 database greenwich and more Study notes Database Programming in PDF only on Docsity!
ASSIGNMENT 2 FRONT SHEET
Qualification TEC Level 5 HND Diploma in Computing Unit number and title Unit 04: Database Design & Development Submission date 28/04/2022 Date Received 1st submission 28/04/ Re-submission Date 04/05/2022 Date Received 2nd submission 04/05/ Student Name Nguyen Van Hoa Student ID GCH Class GCH1002 Assessor name Ha Minh Phuong 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:
- Chapter 1 - Develop the database system...................................................................................................................
- 1.1 Final Mock-up of the application and user documentation
- A. Login case....................................................................................................................................................
- B. Login............................................................................................................................................................
- 1.2 Queries to create database with results
- Create database:................................................................................................................................................
- Create Table Admin...........................................................................................................................................
- Create Table Student.........................................................................................................................................
- Create table Teacher:........................................................................................................................................
- Create table Subject:........................................................................................................................................
- Create table TeacherSubject:.............................................................................................................................
- Create Table Parent:..........................................................................................................................................
- Create Table Lesson...........................................................................................................................................
- Create table Attendence:.......................................................................................................................................
- Chapter 2 – Produce queries.....................................................................................................................................
- 2.1 Queries to INSERT data with illustrations of final result..................................................................................
- Insert a student into table student....................................................................................................................
- Insert data into table Parent:............................................................................................................................
- Insert data into table Teacher:..........................................................................................................................
- 2.2 Queries to UPDATE data with illustrations of final result................................................................................
- 2.3 Queries to DELETE data with illustrations of final result..................................................................................
- 2.4 Queries to SELECT data with illustrations of final result..................................................................................
- 2.5 Advanced queries:...........................................................................................................................................
- Chapter 3 – Test the system......................................................................................................................................
- 3.1 Test cases.........................................................................................................................................................
- Chapter 4 – Technical and User Documentation.......................................................................................................
- 4.1 Technical Documentation................................................................................................................................
- I. OverView of System.......................................................................................................................................
- II. User requirement..........................................................................................................................................
- III. System requirement.....................................................................................................................................
- IV Bussiness Process:.........................................................................................................................................
- V Design.............................................................................................................................................................
- a. Logical Design............................................................................................................................................
- 4.2 Sourece code...................................................................................................................................................
- References.................................................................................................................................................................
Chapter 1 - Develop the database system
1.1 Final Mock-up of the application and user documentation A. Login case The users must first pick the login object in order for the system to recognize if they as a student, teacher, or system administrator. The system can then recognize and grant rights to each object, allowing the user to get the most out of the system. Figure 1: Login case B. Login Figure 2: Login
Figure 4: Student’s Information
- Student’s view class: Example a student has ID: GCH3002 click on view class.
Figure 5: Student check the class.
- Student View curriculum: Figure 6: Student View curriculum: Option for teachers: When The teachers select "Login for Teachers," Who'll be requested to fill up the blanks with information in order to login. The teacher's email address and password are included in this
Figure 8: Options
- Teacher view Curriculum Figure 9 Teacher view Curriculum
- Teacher view Information: a. Class:
Figure 9: Teacher view Class b. Teacher view student’s parent Figure 10: Teacher view parent information
Option for administrators When Admin click “ Login for Admin’, the system will display the login interface as follows: Figure 13: Admin login The system will check whether the account and password are correct or incorrect by using the choose... statement with the admin and password values: If it true:
Figure 15: Diagram 1.2 Queries to create database with results
Create database:
Create Table Admin
Result:
Create Table Student
Create table Subject:
Result:
Create table TeacherSubject:
Result:
Create Table Parent:
Result:
Create Table Lesson
Result:
