RECORD QUESTION FOR CLASS 10

Download (10 Questions )

11. Write the steps to create the tables in 

Library

TABLE NAME: LIBRARY_BOOKS
COLUMN_NAME	DATA TYPE
S.NO
BOOK_CODE
BOOK_NAME
BOOK_SUBJECT
BOOK_AUTHOR
BOOK_PAGES

TABLE NAME : LIBRARY_ISSUE
COLUMN_NAME	DATA TYPE
S.NO
ADM_NO
STU_NAME
STU_CLS
BOOK_CODE
ISSUE_DATE

School

TABLE NAME: STUDENT_DETAILS

TABLE NAME: STUDENT_PERSONAL_DETAILS

Add the columns as we written in the class work.

12. Create the Forms for the above databases.

13. Create the Reports for the above databases.

14. Write the Steps for usage of DDL and DML commands with examples. 

15. Create 10 Queries for the Library Database. (use INSERT, SELECT, UPDATE commands)

16. Create 10 Queries for the School Database. (use INSERT, SELECT, UPDATE commands)