Start Microsoft Access, Create a new database and give the database name as your first name and your Student IDand perform the following tasks in your database:

1. Create two tables from the given ER Diagram and set Primary Keys for both the tables. Create a relationshipbetween two tables using the suitable column. Then enter the data. (Enter at least 3 authors details and 3 books details) (3 Marks)
2. Create a form which will display the data from BOOK table and also create another form which will display the data from AUTHOR table. (3 Marks)
3. Create a report by taking data from BOOK table using Tabular layout and Portrait orientation. (2 Marks)
4. Create two Queries. One query will take data from BOOK table and display the data. Another query will take data from AUTHOR table and display the data.

AUTHOR BOOK Written by Author ID

Book No

Author Name Specialization Phone Number Write Book Title Publishing Year Price Author ID