Using PostgreSQL, develop and execute an SQL script file of DDL SQL to create the database tables in the metadata document.

Using PostgreSQL, develop and execute an SQL script file of DML SQL INSERT statements to populate the tables using SQL INSERT statements for at least 5 rows of data per table.

Using PostgreSQL develop and execute an SQL script file to:

Show the contents of all tables

Retrieve all of the customers' names, account numbers, and addresses (street and zip code only), sorted by account number

Retrieve all of the DVDs rented in the last 30 days and sort in chronological rental date order

Update a customer name to change their maiden names to married names. You can choose which row to update. Make sure that you use the primary key column in your WHERE clause to affect only a specific row.

Delete a specific customer from the database. You can choose which row to delete. Make sure that you use the primary key column in your WHERE clause to affect only a specific row.

Video 2 Column1 3 Movie id 4 Column2 Column3 Column1 Column2 Column3 Video Stock Movie title Movie type Video id Movie title 190712 Great Time 975141 Movie Place 642181 Time Space 522335 Rain 81526 Sun DVD Video Video DVD Video 248720 Movie Place 263129 Time Space 408314 Sun 557433 Space Man 929325 Future 4 10 11 Column1 12 Charge_id 13 14 15 16 17 Charges Column2Column3 Customers Column1 Column2 Column3 Column4 Column5 Video_charge Dvd charge Customer id Customer fristname Customer lastname Customer address Customer_charges 893150 542690 702645 229495 674625 466359 Jack 763493 Dan 336911 Mark 933943 Sarah 387308 Julie 2.95 1.95 1.95 1.95 1.95 1.95 1.95 2.95 2.95 2.95 2.95 2.95 Boyer in Jointer Finn Tracer 238 Harrington 445 South 664 George 778 Main 889 Glenn 1.95 2.95 19 20 Column1 21 Dvd id DVD Distributor Column2Column3 Column1Column2 Column3 Column4 Column5 Column6 Movie title Dvd stock Distributor ic Distributor name Movie id Movie quanity Movie price Movie_type 23 24 25 26 885030 Great Time 650945 Rain 243318 Truck 539763 Great Movie Supply 801108 Fun Movie Supply 667581 All Movie Supply 442984 DVD Sale 861931 Video Sale 190712 975141 642181 522335 481526 5.5 DVD 4.5 Video 4.25 Video 5.75 DVD 84260 Hulk 423443 Soldier 4 Video 28 29 Column1 30 Actor_id Actors Column2 Column3 Movie id Column1 Column2 Column3 Column4 Actor_name Fee id Tax rate Late fee Damage fee 196132 648888 902446 106796 208325 190712 Jack Black 975141 Goroge Clooney 642181 Blake Lively 522335 Ryan Reynolds 481526 Brad Pitt 896772 363730 899517 416302 963310 0.6 0.6 0.6 0.6 0.6 Academy award Column2Column3 38 Column1 39 Academy_award id Movie_id | Column41 Year Category 813823 789498 31757 954465 981605 190712 975141 642181 522335 481526 2007 Drama 2008 Crime 2009 Romance 2010 Comedy 2011 Drama 41