This week we learned about some principles behind database design and we saw how to set up a postgreSQL database with the help of pgAdmin. We also learned how to bring data into a database and do some simple manipulations with it. Your assignment this week is to review the material from February 3rd and 5th, and demonstrate that you can repeat the steps outlined there. If you would like to restart from scratch, please see the information here about starting over.
Review the information on creating a new user in postgreSQL with the help of pgAdmin, and verify that you can create the lake_wa user from the postgres super user account.
Review the information on creating a new database in postgreSQL with the help of pgAdmin, and verify that you can create the lake_wa database from the lake_wa user account.
Review the information on adding data to a new database in postgreSQL with the help of pgAdmin, and verify that you can create the public.pdo and staging.limno tables.
Review the information on creating a new field and concatenating fields, and then verify that you can do so with the Year and Month fields in the staging.limno table.
Review the information on changing NA to NULL and do so in your staging.limno table.
Create your final public.limno table and move it from staging to public,
Join your limno and pdo tables into a view. When you are finished, take a screen shot of your new view as shown in the pgAdmin object browser similar to one at the end of the document here.
Open a new issue called Assignment 4 in your fish497 repo that you created as part of Assignment 1 and include the screen shot from Task 7. To do so, you can simply drag and drop the image into the issue editing window.