Create a SQL Server database that contains one table named Homes. The table should contain 10 records,
Question:
Create a SQL Server database that contains one table named Homes. The table should contain 10 records, each having five fields. The ID field should be an auto-numbered field. The ZIP code field should contain text. Be sure to use at least three different ZIP codes. The number of bedrooms, number of bathrooms, and price fields should be numeric. Create an application that displays the contents of the database in a DataGridView control. The user should not be allowed to add, edit, delete, or save records. The application should allow the user to display the records for a specific number of bedrooms, a specific number of bathrooms, or a specific ZIP code. When the interface appears, it should display the average home price for the entire database.
Step by Step Answer: