Creating a database and website

CSCI 340 - Introduction to Database - Project 1

Instructor: Song Huang; Email: [email protected] Due on: 03/31/2021 11:55 PM (Tuesday)

Requirement: What you need to do for Project 1:

• Zip all of your source code and submit the Zipped file

• Attach a PDF file which should include your design of the project, some paragraphs to describe the functions

• Prepare a 3-minute presentation for this project, you can submit the presentation record- ing or attend a live session and present your project. In the presentation, you will need show the instructor how you run your program, and show different functions of your project, your tables in your database.

Grading:

• A functional project and source code: 80%

• Documentation (the PDF file): 10%

• Presentation: 10%

Late Policy: No late submission will be accepted, except some important things happened. Student are required to email instructor and provide proofs.

Questions

1. 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

2