Wednesday, May 31, 2017

Module 2: Physical Spatial Database Design

We learned how to  create and import data into PostgreSQL (PGSQL). This is the Entity Relationship Diagram (ERD) that I created for this project. It shows how the different datasets are related and the type of information involved. This is important for creating the tables especially when importing the .csv file used to populate the sales table. The tool used to create tables from the parcels and parks shapefiles automatically creates the tables and classifies the data. For this project, I decided to type most of the data with broader data types to make sure it came out well. This was my first time using PGSQL and I enjoy learning things with a hands-on approach

No comments:

Post a Comment