********************** MS ACCESS QUESTION ***************************

Database Systems LAB TASK.2 Date: 6" March 2021 QI. Design a database for a LIBRARY MANAGEMENT SYSTEM, using given database schema in ms.access. 15 TI ADMINISTRATOR T2 READERS DETAILS FIELD NAME DATA TYPE FIELD NAME DATA TYPE admin_id Numeric Reader id Text admin name Text Name Text admin passwd Text Password Text admin_rights Text Address Number lib_rights Text Contact Text Readerrights Text Email Number Issue tag Text Tags used Text T3 FEEDBACK Text FIELD NAME DATA TYPE Issue no Number Books details (stock) S No Number FIELD NAME DATA TYPE ISDN Text Name Text S.No. Number Code Number ISDN Number Type Number Name Text Borrow.name Text Code Number Author Text Type Number Issue date Number Author name Text Retum date Number Publish date Text Edition Number Status Number a. Set admin_id, Reader id, Issue no and S.No as primary keys for administrator, reader details, feedback and book details relations respectively. b. Define each field's possible data types, e.g. Email: hyperlink c. Add an input mask to the password and ISDN number, where ISDN input mask allows numbers like (403) 789-1234. d. Create forms for each of the table and use the arrow buttons to navigate between your records. make sure you save your form. e. Allow user to create, read, delete, and update records in Books details form. Note: Forms should be user friendly. Database Systems LAB TASK.2 Date: 6" March 2021 QI. Design a database for a LIBRARY MANAGEMENT SYSTEM, using given database schema in ms.access. 15 TI ADMINISTRATOR T2 READERS DETAILS FIELD NAME DATA TYPE FIELD NAME DATA TYPE admin_id Numeric Reader id Text admin name Text Name Text admin passwd Text Password Text admin_rights Text Address Number lib_rights Text Contact Text Readerrights Text Email Number Issue tag Text Tags used Text T3 FEEDBACK Text FIELD NAME DATA TYPE Issue no Number Books details (stock) S No Number FIELD NAME DATA TYPE ISDN Text Name Text S.No. Number Code Number ISDN Number Type Number Name Text Borrow.name Text Code Number Author Text Type Number Issue date Number Author name Text Retum date Number Publish date Text Edition Number Status Number a. Set admin_id, Reader id, Issue no and S.No as primary keys for administrator, reader details, feedback and book details relations respectively. b. Define each field's possible data types, e.g. Email: hyperlink c. Add an input mask to the password and ISDN number, where ISDN input mask allows numbers like (403) 789-1234. d. Create forms for each of the table and use the arrow buttons to navigate between your records. make sure you save your form. e. Allow user to create, read, delete, and update records in Books details form. Note: Forms should be user friendly