Focusing on only the Event and Facility tables, define a revised database schema using SQL DDL source code. Note that you can assume that Contact and Location are existing tables. You should all SQL needed to fully implement the tables including:
their columns with appropriate data types, lengths, and constraints (if any)
their integrity constraints (domain, entity, and referential)
their appropriate indexes
Use MySql SQL syntax for the purposes of this exercise. In the Related Course Materials section, you will find a quick reference guide to earlier version of MySql that is sufficient to accomplish the work.
But these factors do not compensate for the overwhelmingly destructive impacts criminal acts can bring to society. The emphasis of this paper is on “a small degree” of crime, anything exceeding this quoted spectrum can still be a potential problem that will hinder the stabiliy of a community. Many of the societal crisis that countries suffer from nowadays root not only from the actively booming crime rates, but also from the ways people choose to cope with the situation. This is clearly reflected in the ongoing refugee crisis in between the borders of Venezuela and Colombia. Ever since 2010 when the Venezuelan economy started to crumble, millions of their citizens began to flee the country. Many of these people ended up migrating to the neighboring country of Colombia, where the borders are relatively easy to cross since they do not require any passports or documents. Unlike any other neighboring countries who constantly try to control the migrant population with new policies, such as increasing border security or requiring stamped visas, Colombia leaders and politicians continue to open their door to the floods of Venezuelans. Yet, this sense of solidarity did not last long when a slew of crimes that were allegedly committed by Venezuelan migrants emerged. According to the local police department, Q’pasa Cúcuta, there is a positive correlation between the constant growth of crime rates and the influx of migrants (Selle, 2017). But despite of this expanding skepticism toward Venezuelans, Colombia’s borders are still widely accessible. The failure of the Colombian government in reviewing this prevailing dilemma is only a perpetuation of the problems in Venezuela. The positive ideals of crime discussed above can hardly take place in this scenario since the trend is proven to be worsening progressively. To add on, an increase in crime rates can easily inflict a series of humanitarian and economic losses. The constant unrest in local communities could mean that more money needs to be put into security and prison management, and this money comes directly out of the pockets of local taxpayers. A peaking crime rate could also mean that the common code of moral values is no longer respected, people are prioritizing their own needs other than playing by the rules of society. This adds grist to the debate of how crime can eventually be prevented with an optimal outcome that can drive our society to advance in the long run.>GET ANSWER