1. Create a database named Bookstore and tables, using the following E-R diagram.
E-R diagram is given in attached file.
1You could create the database on AWS using RDS, or you could create your database on your local machine.
2. Create a website for access your database, and include some functionalities, like:
insert records to each table, you may need to update other tables when you need to insert a record to a table.
query records from each table using different columns
delete records from each table, you might need to update other tables when you delete a record from a table.
3. You could use any framework to develop your website, for example:
if you are familiar with Python, you could use Flask or Django
if you are familiar with javascript, you could use Node.js
