Scribd
Upload
4 views10 pages

Student Data Collection Guidelines

The document collects student data including name, age, state and date of birth. It also lists Indian states and validation rules for each data field, including acceptable age range and date of birth. Error messages are provided for invalid data.

Uploaded by

arushi dutt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4 views10 pages

Student Data Collection Guidelines

The document collects student data including name, age, state and date of birth. It also lists Indian states and validation rules for each data field, including acceptable age range and date of birth. Error messages are provided for invalid data.

Uploaded by

arushi dutt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Collecting the student data.

The
collection includes the following
attributes: Name, Age, State, Date
of Birth
First Name Last Name Age State Date of Birth
Ram C 23 BR 8/20/1989
ab 23 9/9/1990
States
Andhra Pradesh
Arunachal Pradesh
Assam
Bihar
Chhattisgarh
Goa
Gujarat
Haryana
Himachal Pradesh
Jharkhand
Karnataka
Kerala
Madhya Pradesh
Maharashtra
Manipur
Meghalaya
Mizoram
Nagaland
Odisha
Punjab
Rajasthan
Sikkim
Tamil Nadu
Telangana
Tripura
Uttar Pradesh
Uttarakhand
West Bengal
Andaman and Nicobar Islands
Chandigarh
Dadra and Nagar Haveli and Daman and Diu
Delhi
Jammu and Kashmir
Ladakh
Lakshadweep
Puducherry
Column Validation Rule
First Name Last Name Text Length greater than equal to 3
Age Minimum 19 to Maximum 40
State Enter the states from the list
Date of Birth Date between 01-01-1980 to now
Error Message
Please enter the first and last name of the student separated by a space.
Not valid age for MBA!
Enter the valid state !
Please enter valid date of birth of the student.
First Name Last Name Age State Date of Birth
e df 23 Jammu and Kashmir 1/1/2000
Goa
State1
Assam
Goa
Year Region Product Unit Sold Amount
70
7/2/2020
Product ID Product ID
rxyz gxyz
uixyz

You might also like