Property & Property Damage Database Management Database Queries/Reports

By Anonymous -
After each question, construct the SQL statement that answers the question.  When specific attributes are not asked for, you may choose which attributes you wish to display.

  1. List all the information about the properties. 
  2. List information about damages including the street address.
  3. What were the different sources of damage (no duplicate reporting)?
  4. What was the total amount of damages assessed?
  5. What were the total damages for each property?
  6. List the damages sorted by location (where the damage was located not where the property was located).
  7. How many damages were reported?
  8. List the information about the properties whose zip codes start with 301.
  9. List the properties in Woodstock that were damaged.
  10. What properties were damaged (street address), what were the damages (description) and what was the amount of the damage?
  11. List the report information for inspectors Jones, Smith, White [use the IN keyword]. 
  12. Which inspector(s) reported total damage amounts >$30,000 for all properties they inspected?
  13. Which property (by address) had damages from flooding on the first floor?
  14. List all property street addresses and show the description of the damage for those that had damage.
  15. Create a View to show street address and city of properties that had damage to their floors (wet carpet or buckled floor).  Call the view FloorDamage.

Get Project Solution by contacting us

- via WhatsApp: +92-324-7042178

Comments

Post a Comment

Popular posts from this blog

[SOLVED] Branch Coverage, Statement Coverage and Path Coverage | Java Unit Testing

By Anonymous -
Create a directory called “TestClassValue” Hereafter, we call this directory <dir>. Create a Java class com.work.sample.FlawedClass in directory <dir>/src. (The actual path will obviously reflect the package structure.) 100% Branch Coverage & 100% Statement Coverage Add to the class a method called flawedMethodl that contains a division by zero fault such that it is possible to create a test suite that achieves 100% branch coverage and does not reveal the fault every test suite that achieves 100% statement coverage reveals the fault. Conversely, if you were able to create the method, then create two JUnit test classes com.work.sample.FlawedClassTestBCl and com.work.sample.FlawedClassTestSCl for class FlawedClass as follows: FlawedClassTestBCl should achieve 100% branch coverage of flawedMethodl and not reveal the fault therein. FlawedClassTestSCl should achieve 100% statement coverage of flawedMethodl and reveal the fault therein. Both classes should be...
Read more

HTML, PHP URL registration and lising program Internet Programming Spring 2016 Assignment #5

By Hassnain Jamil -
Image
Buy now Introduction Create and run a SQL script with a database named URL and a table named Urltable. The first field of the table should contain an actual URL, and the second, which is named Description, should contain a description of the URL. Write a PHP script that obtains a URL and its description from a user and stores the information into a database using MySQL. After each new URL is submitted, print the contents of the database in a table. Requirements: Store the structure of the tables in a txt file for submission. Output Screenshots: Order now! Buy now CONTACT DETAILS For any other questions or other tasks please feel free to contact me via email: mhassnainjamil@gmail.com via WhatsApp: +92-324-7042178 via skype: hassnainjamil1
Read more