Create a database named “Bookstore” and tables, using the following E-R diagram.
1
You 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