The comic book store has a set of comic books which it sells. Each comic book comes from some series (Superman, Amazing Spiderman, etc.). Each series has a title and a publisher. Each comic book has a number (Superman #1, Superman #2, etc.) and a date on which it will be published. The store has customers. The store knows the name, address, and telephone number of each customer. Some customers have subscriptions which comic book titles they wish to receive each issue of. We want to keep track of who is subscribing to which series so that we will know how many of each issue to order.

Goals

A1) Create an E-R Diagram which represents the information you wish to store.

B2) Create a set of database tables which represent the data you wish to store.

B3) Create a set of sample SQL queries for inserting data into the database.

B4) Create a set of sample SQL queries for searching for data in the database. Create either one program or two programs which accomplish the following tasks:

C1) Reads data from an input file and uses it to fill the database tables.

D1) Allow the user to search the database, add new data to the database, and change existing data