Description
Problem Converting ER diagram for transportation statistics to Relational Model.
Convert the ER Model you have designed in the previous assignment to Relational Model..
Populate the tables generated using BTS Transtats. For consistency among groups in further assignments, every group download the data Pertaining to all 12 months of year 2017.
Please use PostgreSQL for this assignment(https://www.postgresql.org/) You need to extract the relevant data for each table from these les.
The dataset does not contain all the data that is required.. If you crawl this unavailable data, you will get bonus marks. References to crawl: link1, link2, link3.
You are free to crawl any other websites (not restricted to the above references).
Please note: In your ER diagram, you might have included other attributes from the dataset or website. If required, you can make modi cations to the ER diagram designed as a part of the rst assignment but ensure that the new ER diagram designed satis es all the required constraints and inheritance properties given in rst assignment.
Submission: You should submit all the db les and a report pdf (preferably in latex). Please submit a zip le named as <groupID> assgn2.zip (without angle brackets ). Single submission per group is enough.
1
