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