[Solved]Write Create Table Statements Create Tables Funky Biz Operations Database Depicted Relatio Q37203291

Write CREATE TABLE statements to create the tables for the FunkyBiz Operations Database depicted by the relational schema

Name your database FUNKY_BIZ.

Also, create a view of all of the tables. Uploadone file containing the following:

1. The SQL CREATE and INSERT statements
2. A snip of the output from running the following command to showthat you created the tables correctly: SELECT table_name,TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA =’FUNKY_BIZ’;
3. The SQL to create a view of all of the tables
4. The result of a select * from the view.

I just dont understand how to even begin creating the Tables formySql

BAND BandID BandName BandPhone BandID 5551234567 5551112222 22 5552221111 22 5553334444 33 5554443333 33 The Flags Blood Dogs lan and the Threats 612 Morris St Greg Rolins 739 Belmont Bvd Jimmy Boon 123 Dischord Ave 22 lan Fugazi MUSICSHOW ShowVenue Charle’s Charle’s ShowDate BandID 2012-05-26 11 2012-06-15 11 INSTRUMENT InsSerialNo InsModel InsYearMade BandID Townes Center 2012-07-01 11 1985 1978 4321ThrasherSpeedy Axes 2003 Gilly Park Pza 2012-06-01 22 The Mill Club 2012-06-12 22 Townes Center 2012-06-01 22 3456 Melowcaster Bender 5432 Jazz cub Pro Atantic Drums 1987 2012-05-26 33 Fok Cassi Vartin Gultars 1993 Gilly Park Pza 2012-06-01 33 Townes Center 2012-05-05 33 Townes Center 2012-07-01 33 REPAIRS REPAIRTECHNICIAN InsSeralNo RTSSN RTSSN RTName RTAddress ShowVenue ShowDate ShowType 2012-05-26 Multi-Band Event ShowName Aaron 59 Leo St 200 Dove Rd 2012-06-15 Multi-Band Event 988898888 Ryan Charie’s Gily Park Plaz 2012-06-01 Festval The Mil Cub 2012-06-12 Open Mic Townes Center 2012-05-05 Charty Event Rockin’ For Education Townes Center 2012-06-01 Chanity Event School Aid Townes Center 2012-07-01 Charity Event Townes Center Food Drive 5432 Gly Park Fest RTPHONE 5678 3456 4321 883888888 5559991111 888888888 Show transcribed image text BAND BandID BandName BandPhone BandID 5551234567 5551112222 22 5552221111 22 5553334444 33 5554443333 33 The Flags Blood Dogs lan and the Threats 612 Morris St Greg Rolins 739 Belmont Bvd Jimmy Boon 123 Dischord Ave 22 lan Fugazi MUSICSHOW ShowVenue Charle’s Charle’s ShowDate BandID 2012-05-26 11 2012-06-15 11 INSTRUMENT InsSerialNo InsModel InsYearMade BandID Townes Center 2012-07-01 11 1985 1978 4321ThrasherSpeedy Axes 2003 Gilly Park Pza 2012-06-01 22 The Mill Club 2012-06-12 22 Townes Center 2012-06-01 22 3456 Melowcaster Bender 5432 Jazz cub Pro Atantic Drums 1987 2012-05-26 33 Fok Cassi Vartin Gultars 1993 Gilly Park Pza 2012-06-01 33 Townes Center 2012-05-05 33 Townes Center 2012-07-01 33 REPAIRS REPAIRTECHNICIAN InsSeralNo RTSSN RTSSN RTName RTAddress ShowVenue ShowDate ShowType 2012-05-26 Multi-Band Event ShowName Aaron 59 Leo St 200 Dove Rd 2012-06-15 Multi-Band Event 988898888 Ryan Charie’s Gily Park Plaz 2012-06-01 Festval The Mil Cub 2012-06-12 Open Mic Townes Center 2012-05-05 Charty Event Rockin’ For Education Townes Center 2012-06-01 Chanity Event School Aid Townes Center 2012-07-01 Charity Event Townes Center Food Drive 5432 Gly Park Fest RTPHONE 5678 3456 4321 883888888 5559991111 888888888

Expert Answer

---

Answer to Write CREATE TABLE statements to create the tables for the Funky Biz Operations Database depicted by the relational sche… . . .