1 Consider the following tables to find information using SQL and MySQL Workbench. Draw the schema...

   

Transcribed Image Text:

1 Consider the following tables to find information using SQL and MySQL Workbench. Draw the schema diagram based on the entities. DEMOGRAPHIC ID PERSON 1 2 3 4 5 6 7 8 9 POLICY ID POLICY 1 2 3 4 5 6 7 8 9 10 01234 11 12 13 14 CARS ID POLICY 1 2 3 3 4 FIRST NAME Jeff Derek Allen Eric ID_PERSON 1 2 2 5 6 7 Derek Speedy Arron Larry Pat 7 8 9 9 9 MAKE AUDI PORSCHE DRA LAST NAME Salvage Jeter Iverson Snow McKee POLICY_NUMBER III Brown Croche Coleman Claxton AAA BBB CCC DDD EEE FFF GGG HHH JJJ KKK LLL MMM NNN MODEL S4 911 18C CITY Medford Brooklyn Philadelphia Philadelphia Medford Philadelphia Lower Merion Evesham Princeton START DATE 1/20/2002 2/20/2002 1/24/2002 4/04/2002 12/19/2001 1/10/2002 1/15/2002 1/21/2002 2/18/2002 2/17/2002 3/10/2002 3/01/2002 4/21/2002 3/04/2002 STATE NJ NY PA PA NJ PA PA NJ NJ END DATE 1/19/2003 2/19/2003 1/23/2003 4/03/2003 12/18/2002 1/09/2003 1/14/2003 1/20/2003 2/17/2003 2/16/2003 3/09/2003 2/28/2003 4/20/2003 3/03/2003 1 Consider the following tables to find information using SQL and MySQL Workbench. Draw the schema diagram based on the entities. DEMOGRAPHIC ID PERSON 1 2 3 4 5 6 7 8 9 POLICY ID POLICY 1 2 3 4 5 6 7 8 9 10 01234 11 12 13 14 CARS ID POLICY 1 2 3 3 4 FIRST NAME Jeff Derek Allen Eric ID_PERSON 1 2 2 5 6 7 Derek Speedy Arron Larry Pat 7 8 9 9 9 MAKE AUDI PORSCHE DRA LAST NAME Salvage Jeter Iverson Snow McKee POLICY_NUMBER III Brown Croche Coleman Claxton AAA BBB CCC DDD EEE FFF GGG HHH JJJ KKK LLL MMM NNN MODEL S4 911 18C CITY Medford Brooklyn Philadelphia Philadelphia Medford Philadelphia Lower Merion Evesham Princeton START DATE 1/20/2002 2/20/2002 1/24/2002 4/04/2002 12/19/2001 1/10/2002 1/15/2002 1/21/2002 2/18/2002 2/17/2002 3/10/2002 3/01/2002 4/21/2002 3/04/2002 STATE NJ NY PA PA NJ PA PA NJ NJ END DATE 1/19/2003 2/19/2003 1/23/2003 4/03/2003 12/18/2002 1/09/2003 1/14/2003 1/20/2003 2/17/2003 2/16/2003 3/09/2003 2/28/2003 4/20/2003 3/03/2003

Answer rating: 100% (QA)

1 Select Count From DEMOGRAPHIC WHERE STATENY 2 SELECT COUNT FROM CARS WH... View the full answer