This is a Student CE component marksheet.
Don't Forget to Subscribe My Channel , like video and share to your friends. If you want to learn any new things then comment over that. We will make new video on that As soon As Possible.
## Task: Consider the following database tables for the application.
| Column Names | ||
|---|---|---|
| Roll no. | Name | Samester |
| Data type with constrains | ||
| Text, Not Null | Text, Not Null | Integer, Not Null |
| 17BIT021 | Yagnik | 6 |
| 17BCE035 | Krish | 6 |
| Column Names | |||
|---|---|---|---|
| Roll no. | Class Test Marks | Sessional Marks | Assignment Marks |
| Data type with Constraints | |||
| Text, Not Null | Integer,Not Null | Integer,Not Null | Integer,Not Null |
| Sample Data | |||
| 17BIT021 | 20 | 25 | 30 |
| 17BCE035 | 25 | 30 | 35 |
- First activity is asked student details according to table StudentDetails. As soon as student clicks
the submit button, update information in StudentDetails table. Validate the fields for appropriate
data type i.e Roll no. is Text type, Semester is Integer type, etc.
- Second activity is asked student's marks according to table CEComponent. As soon as student clicks the submit button, it first check that student is registred or not. If register then it allowed to update information in StudentDetails table.
