Marksheet-Methodology

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.

Database Table:

Name of the table: StudentDetails

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

Name of the table: CEComponent

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

Following functionalities in app:

1. 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.
   
2. 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.

Images of Output