Hello,
I hope that everyone is okay
I need your help with this assignment?
Please help the librarian create a database called Gulf Library using Microsoft Access software, to help store data and ease data retrieval and inquire upon request, which contains the following entities:
Student table (Student number, name, college, phone number, city, profile picture, email).
Book table (book number, book name, author's name ,type, publish year, book picture).
Book borrowing table (borrowing number, book number, student number, Start Date,End date).
Enter values for 6 records after designing.
Required as follows:
Thanks a lot in advance for your help
I hope that everyone is okay
I need your help with this assignment?
Please help the librarian create a database called Gulf Library using Microsoft Access software, to help store data and ease data retrieval and inquire upon request, which contains the following entities:
Student table (Student number, name, college, phone number, city, profile picture, email).
Book table (book number, book name, author's name ,type, publish year, book picture).
Book borrowing table (borrowing number, book number, student number, Start Date,End date).
Enter values for 6 records after designing.
Required as follows:
- Create entities and specify the type of data their attributes.
- Define primary keys and foreign keys.
- Establish relationships between entities
- Create a query through the wizard to display the name of the student, the name of the book, and start date.
- Create a query through the wizard to display the book details , and the condition of the publish year should be less than one year
- Create a form for the main screen contains buttons to move all forms (entities).
- Design reports for Book table and Book borrowing table.
Thanks a lot in advance for your help