II. Identify the valid and invalid field names giving reasons: 1. Name 2. Father's name 3. Date of birth 4. Admission No. 5. Blood Group 6. Postal Address 7. Contact No. 8. E-mail ID
Answers
Answer:
Answer:1. Name — Invalid
Answer:1. Name — Invalid2. Father's name--Invalid
Answer:1. Name — Invalid2. Father's name--Invalid3. Date of birth — Valid
Answer:1. Name — Invalid2. Father's name--Invalid3. Date of birth — Valid3. Date of birth — Valid
Answer:1. Name — Invalid2. Father's name--Invalid3. Date of birth — Valid3. Date of birth — Valid4. Admission No. — Invalid
Answer:1. Name — Invalid2. Father's name--Invalid3. Date of birth — Valid3. Date of birth — Valid4. Admission No. — Invalid5. Blood Group — Valid
Answer:1. Name — Invalid2. Father's name--Invalid3. Date of birth — Valid3. Date of birth — Valid4. Admission No. — Invalid5. Blood Group — Valid6. Postal Address — Valid
Answer:1. Name — Invalid2. Father's name--Invalid3. Date of birth — Valid3. Date of birth — Valid4. Admission No. — Invalid5. Blood Group — Valid6. Postal Address — Valid7.Contact No. — Invalid
Answer:1. Name — Invalid2. Father's name--Invalid3. Date of birth — Valid3. Date of birth — Valid4. Admission No. — Invalid5. Blood Group — Valid6. Postal Address — Valid7.Contact No. — Invalid8. E-mail ID — Invalid
Explanation:
1. Name — Invalid because 'name' is a keyword in MS Access.
because 'name' is a keyword in MS Access.2. Father's name — Invalid because it has a special character in it.
because 'name' is a keyword in MS Access.2. Father's name — Invalid because it has a special character in it.3. Date of birth — Valid because it has no special character in it.
because 'name' is a keyword in MS Access.2. Father's name — Invalid because it has a special character in it.3. Date of birth — Valid because it has no special character in it.4. Admission No. — Invalid because it has a special character (.) in it.
5. Blood Group — Valid because it has no special character in it.
5. Blood Group — Valid because it has no special character in it.6. Postal Address — Valid because it has no special character in it.
5. Blood Group — Valid because it has no special character in it.6. Postal Address — Valid because it has no special character in it.7.Contact No. — Invalid because it has a special character (.) in it.
5. Blood Group — Valid because it has no special character in it.6. Postal Address — Valid because it has no special character in it.7.Contact No. — Invalid because it has a special character (.) in it.8. E-mail ID — Invalid because it has a special character (-) in it.