How to work with views

$1.$ Locate a raw data source of buss stations or generate random data of buss stations.$|$

$2.$ Your data set should contain raw data of some sort $-$ perhaps with $\backslash (10+\backslash )$ columns and $10,000$ rows or less $($this is just a guideline but keep the dataset manageable when you make your selection of a data set$).$

$3.$ Design an entity relationship diagram using $3+$ entities using your data set. You can make up relational data for joining purposes to your data set. Keep the ERD simple.

$4.$ Create a database with tables, views, and any other construct to represent your ERD and preload your database with data from your dataset and any other related data. Create and execute SQL statements show mastery of your learning from chapter $\backslash (13-15\backslash )$ of your textbooks. Specifically define $1$ or more views, variables, temp tables, scripts, dynamic SQL$,$ Stored Procedure, User defined function, and at least one trigger. Show all SQL Code with executed results.

$5.$ Comment $/$ document your code and explain what each piece of SQL code is designed to do$.$