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

Users of the program should be able to search for:

1) Subscriptions by customer name

2) Customers by telephone number

3) Comic books by series name

4) Comic books by date when they will come out.

5) Comic books by publisher

6) Customers by the comic book series they subscribe to

7) What comic books they will need to order on a given date and how many

DATA

The Vainglorious Masked Masker AC 24 06/07/17 25 07/05/17 26 08/02/17 27 08/30/17 28 09/27/17 29 10/25/17 Spectacular Stupendousman Parvell 21 05/10/17 22 05/24/17 23 06/07/17 24 06/21/17 25 07/05/17 26 07/19/17 27 08/02/17 28 08/16/17 29 08/30/17 30 09/13/17 31 09/27/17 32 10/11/17 The Uncanny Stockboy Parvell 41 06/28/17 42 08/23/17 43 10/18/17 The Vainglorious Angry Parson Parvell 58 06/14/17 59 08/09/17 60 10/04/17 True Stories of Abraham Lincoln AC 53 07/05/17 54 08/30/17 55 10/25/17 The Amazing Beige Panther AC 73 06/14/17 74 08/09/17 75 10/04/17 Spectacular Slacker Girl Picture 29 06/07/17 30 07/05/17 31 08/02/17 32 08/30/17 33 09/27/17 34 10/25/17 The Amazing Guile Lass AC 2 05/10/17 3 05/24/17 4 06/07/17 5 06/21/17 6 07/05/17 7 07/19/17 8 08/02/17 9 08/16/17 10 08/30/17 11 09/13/17 12 09/27/17 13 10/11/17 The Teenage Adventures of Restuaranteer AC 22 06/21/17 23 08/16/17 24 10/11/17 Scorpion Woman Parvell 96 07/26/17 97 09/20/17 98 11/15/17 True Stories of Disappointed Parent Parvell 18 07/12/17 19 09/06/17 20 11/01/17 The Astounding Silver Wakeboarder Picture 24 05/31/17 25 06/28/17 26 07/26/17 27 08/23/17 28 09/20/17 29 10/18/17 Tales of Incognito Lad Marchie 67 05/10/17 68 05/24/17 69 06/07/17 70 06/21/17 71 07/05/17 72 07/19/17 73 08/02/17 74 08/16/17 75 08/30/17 76 09/13/17 77 09/27/17 78 10/11/17 The Astounding Freelance Police Parvell 28 06/07/17 29 07/05/17 30 08/02/17 31 08/30/17 32 09/27/17 33 10/25/17 Tales of Superham Picture 3 06/21/17 4 08/16/17 5 10/11/17 True Stories of Kid Downlow Parvell 9 05/24/17 10 06/21/17 11 07/19/17 12 08/16/17 13 09/13/17 14 10/11/17 Thrilling Pummeler Parvell 94 05/31/17 95 06/28/17 96 07/26/17 97 08/23/17 98 09/20/17 99 10/18/17 Fireman AC 96 07/19/17 97 09/13/17 98 11/08/17 Spectacular Destiny Dude Parvell 39 08/02/17 40 10/25/17 The Uncanny Kid Sasquatch Picture 93 05/24/17 94 06/21/17 95 07/19/17 96 08/16/17 97 09/13/17 98 10/11/17 The Uncanny Human Flashlight Marchie 28 07/19/17 29 09/13/17 30 11/08/17 Thrilling Lazy Lad AC 30 08/02/17 31 09/27/17 32 11/22/17 The Uncanny Disco Inferno Picture 100 05/31/17 101 06/28/17 102 07/26/17 103 08/23/17 104 09/20/17 105 10/18/17 Astonishing Z-Men Picture 76 08/23/17 77 11/15/17 West Coast Human Flashlight Marchie 9 07/05/17 10 08/30/17 11 10/25/17 The Uncanny Kid Downlow Marchie 70 08/30/17 71 11/22/17 Spectacular Powerless Lad AC 36 05/17/17 37 06/14/17 38 07/12/17 39 08/09/17 40 09/06/17 41 10/04/17 Tales of Invisible Horse Picture 88 06/21/17 89 08/16/17 90 10/11/17 The Amazing Powerless Lad Parvell 5 06/21/17 6 08/16/17 7 10/11/17 The Vainglorious Destiny Dude Parvell 29 05/03/17 30 05/17/17 31 05/31/17 32 06/14/17 33 06/28/17 34 07/12/17 35 07/26/17 36 08/09/17 37 08/23/17 38 09/06/17 39 09/20/17 40 10/04/17 West Coast Angry Parson AC 26 05/10/17 27 05/24/17 28 06/07/17 29 06/21/17 30 07/05/17 31 07/19/17 32 08/02/17 33 08/16/17 34 08/30/17 35 09/13/17 36 09/27/17 37 10/11/17 The Amazing Prevengers Marchie 62 06/07/17 63 07/05/17 64 08/02/17 65 08/30/17 66 09/27/17 67 10/25/17 Gnatman Marchie 58 07/19/17 59 09/13/17 60 11/08/17 The Uncanny Superham Parvell 14 07/26/17 15 09/20/17 16 11/15/17 Spectacular Invisible Horse Marchie 85 06/07/17 86 07/05/17 87 08/02/17 88 08/30/17 89 09/27/17 90 10/25/17 The Vainglorious NFL Superpro AC 11 05/03/17 12 05/17/17 13 05/31/17 14 06/14/17 15 06/28/17 16 07/12/17 17 07/26/17 18 08/09/17 19 08/23/17 20 09/06/17 21 09/20/17 22 10/04/17 Thrilling Silver Wakeboarder Picture 61 08/09/17 62 11/01/17 Spectacular Lefty Picture 72 06/28/17 73 08/23/17 74 10/18/17 The Vainglorious Kid Downlow Parvell 39 05/17/17 40 06/14/17 41 07/12/17 42 08/09/17 43 09/06/17 44 10/04/17 West Coast Beige Panther Marchie 99 06/28/17 100 08/23/17 101 10/18/17 West Coast Pig Detective AC 49 05/17/17 50 06/14/17 51 07/12/17 52 08/09/17 53 09/06/17 54 10/04/17 The Amazing Badgerette AC 33 09/27/17 34 12/20/17 Blue Diamond AC 88 07/19/17 89 09/13/17 90 11/08/17 Slacker Girl Marchie 73 05/10/17 74 05/24/17 75 06/07/17 76 06/21/17 77 07/05/17 78 07/19/17 79 08/02/17 80 08/16/17 81 08/30/17 82 09/13/17 83 09/27/17 84 10/11/17 Tales of Stretchy Dude Parvell 8 05/24/17 9 06/21/17 10 07/19/17 11 08/16/17 12 09/13/17 13 10/11/17 The Uncanny Scorpion Woman AC 74 06/07/17 75 07/05/17 76 08/02/17 77 08/30/17 78 09/27/17 79 10/25/17 The Uncanny Abraham Lincoln Picture 13 06/07/17 14 07/05/17 15 08/02/17 16 08/30/17 17 09/27/17 18 10/25/17 The Astounding Angry Parson Picture 63 05/03/17 64 05/17/17 65 05/31/17 66 06/14/17 67 06/28/17 68 07/12/17 69 07/26/17 70 08/09/17 71 08/23/17 72 09/06/17 73 09/20/17 74 10/04/17 Kid Plucky AC 83 09/06/17 84 11/29/17 The Amazing Wonderboy Marchie 28 06/07/17 29 07/05/17 30 08/02/17 31 08/30/17 32 09/27/17 33 10/25/17 The Astounding Stretchy Dude Picture 76 05/24/17 77 06/21/17 78 07/19/17 79 08/16/17 80 09/13/17 81 10/11/17