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 

Leave a Reply

Your email address will not be published. Required fields are marked *