Discuss which views might be beneficial for these base table

Discuss which views might be beneficial for these base tables.

Name: Business Datatype Column NT(10) StartDate VARCHAR (255) CouncilDistrict NT(11) Zipoode VARCHAR(255) Business Type VARCHAR(255) ck to edit Name: Crimes Datatype Column INT 1) VARCHAR(255) CrmDes VARCHAR (255) Status Zipcode

Solution

Creating a view that joins all the three tables with four columns as follows:

ZipCode - zipcode from population table

TotalPopulation - from population table that holds the TotalPopulation field value

TotalCrimes - this counts the number of crimes in the particular zipcode and stores it against it.

TotalBusiness - this counts the number of business in thr particular zipcode and stores it against it.

This view will help to have a quick look on the area through the zipcodes.