DATA MANAGEMENT & APPLICATIONS dateset https://www.kaggle.com/nhtsa/2015-traffic

DATA MANAGEMENT & APPLICATIONS
dateset
https://www.kaggle.com/nhtsa/2015-traffic-fatalities?select=nmprior.csv
We have modified the data
New tables are
Accident
Person
Vehicle
Distract
Cevent
1.Conceptual Model:
Provide a brief descriiption and the ERD (Lucidchart or any CASE tool of choice) of the Conceptual Model.
2.Logical Model:
Provide a Logical Model based on the Relational model (use Lucidchart or any CASE tool of choice) and a brief descriiption of the model.
1 Individual:
Propose to your team with an extension for 2 entities and the associated relations to improve on the richness and the scope of the data model proposed in your Group Project 1 deliverables (Section 2 of this hand out). Then submit the followings.
1.1 Rationale
Provide a descriiption on the rationale behind the proposed extension.
1.2 Comparison
1.2.1 Against the Original Model
Justify how your proposed extension is different from the proposed data model by your team.
1.2.2 Against Other Team Members Individual Extension
Justify how your proposed extension is different from the proposed extensions by the other team members.
1.3 Business Rules
Provide a list of the business rules of the proposed extension of the concepts.
1.4 Conceptual Model
Provide a brief descriiption and the ERD (Lucidchart or any CASE tool of choice) of the extended Conceptual Model.
1.5 Logical Model
Provide a brief descriiption of the extended Logical model based on the Relational model (use Lucidchart or any CASE tool of choice) optimized for the 3rd Normal Form unless necessary for which a full justification is required.
1.5.1 Normalized Model
Provided an optimized model for the 3rd Normal Form unless necessary for which a full justification is required.
1.6 Physical Model: PostgreSQL
Provide a brief descriiption of the extended physical model/internal schema using SQL as DDL supported by PostgreSQL database.
1.7 Data Population: PostgreSQL
Provide Script to populate the extended tables using sample data to PostgreSQL database.
1.8 Views
Provide a View as external schema with a structure which includes attributes form at least 3 entities and the extended one. Describe it.
1.9 Data Manipulation:
1.9.1 Data Manipulation: Internal Schema
Provide a brief descriiption and the purpose of samples of manipulating (using SQL as supported by PostgreSQL database) data with the list of the results applying insertion, deletion and update operations applied against the internal schema.
1.9.2 Data Manipulation: External Schema (View)
Provide a brief descriiption and the purpose of samples of manipulating (using SQL as supported by PostgreSQL database) data with the list of the results applying insertion, deletion and update operations applied against the external schema (view developed above).