List of Students:
Code Name
Date of birth Gender
Subject
SE170001 Tran Hung Cuong
1996-04-30
Male
Java core
SE170002 Le Khanh Van
1997-05-03
Female
Java web
SE170003 Nguyen Thanh Dat
1995-04-05
Male
Database
Detail information:
Code:
Name:
Date of birth:
Gender:
Male Female
Subject:
Java core
Zoom
CREATE
• The Subject dropdown list must load data from [Subjects] table and show [SubjectName]. (0.5point)
• The table "List of Students" must load data from [Students] table (1.0 point) and "Subject"column is taken in the [SubjectName] of the [Subjects] table that corresponds to the SubjectID in the [Students] table. (0.5 point)
When users input the whole student information in the Detail Information and click "CREATE"button:
Information of that student will be inserted into the database (Applicable to normal data, no need to check data). (1.0 point)
The inserted student information will be displayed on the table "List of Students" (0.5 point)
+ 115%
Close
