Q3. Answer the following Application Based Questions:
2x3 = 6
i)
Shobhit has created a library database as shown below:
LIBRARY DATABASE
TABLE-1 BOOK DETAILS
TABLE-2 MEMBER DETAILS
BOOK ID
BOOK NAME
CATEGORY
ATUHOR_NAME
PRICE
ISSUE STATUS
MEMBER_ID
MEMBER_NAME
CONTACT_NO
ID PROOF_SUBMITTED
BOOK_ID
ISSUE_DATE
RETURN_DATE
a) Which field will be used to relate the two tables? Write the steps to create relationship between the two
tables.
b) Which data type would you prefer for the fields ISSUE_STATUS and ID_PROOF_SUBMITTED → Text or
Yes/No? Justify your answer.
Answers
Answered by
3
Answer:
????????-_8&877_337963735+_27_3
Similar questions