Class X
Chapter – 3
Introduction to Databases
Application Based questions
1.
|
Field Name
|
Data Type
|
|
Roll_No.
|
Auto Number
|
|
St_Name
|
Text
|
|
Father’s_Name
|
Text
|
|
Contact_No.
|
Number
|
|
E-mail_Id
|
Text
|
|
Activities_involvedIn
|
Memo
|
2.
|
Field Name
|
Data Type
|
|
VoterId
|
Auto Number
|
|
VoterName
|
Text
|
|
VoterAddress
|
Memo
|
|
VoterDOB
|
Date/ Time
|
3.
|
Field Name
|
Data Type
|
|
BookID
|
Text
|
|
BookName
|
Text
|
|
Author
|
Text
|
|
NoOfCopies
|
Number
|
|
IssuedNoOfCopies
|
Number
|
|
AvailableCopies
|
Number
|
4.
|
Field Name
|
Key
|
|
Account No.
|
Primary Key
|
|
Name
|
Alternate Key
|
|
Mobile
|
Alternate Key
|
|
PAN
|
Candidate Key
|
|
Account Type
|
Alternate Key
|
|
Address
|
Alternate Key
|
|
E-mail
|
Alternate Key
|
5.
a. Four
b. Six
c. PlayerId
No comments:
Post a Comment