Wild Wood Apartments: database design

Wild Wood Apartments:

Instructions:-

You have completed the designs for the apartment management database. You reviewed it and all the business rules with the owners, and they are eager to proceed. Now you need to take your design and translate it into an actual database. Once you have done that, you know that you will need to enter data to test the database, to make sure it does, in fact, store all the required data.

 

To Do:

1. Review your diagram for the database, making sure that the design is complete and normalized.

2. Create the database in SQL Server.

3. Create the tables in the new database, selecting appropriate data types for the columns, setting a primary key for each table, and setting allow nulls as appropriate.

 

Now that the basic database is in place, the Wild Wood Apartments managers are eager to see the database in action and see if it meets all their needs and requirements. It is time to look at the business rules and test them with some SQL. Look at the business rules you developed previously, and design some SQL queries to test them. Documentation: Set up a test plan. List the rule, the SQL you wrote, and the results. Also note whether the database passes or fails the test. Your queries should include the following:

 

  • Two or three simple SELECTs with various WHERE criteria.
  • Two or three queries using aggregate functions.
  • At least two queries that use joins.
  • Two or three INSERT statements.
  • One or two UPDATEs and/or a DELETE
  •  
  • Do you want your assignment written by the best essay experts? Then look no further. Our team of experienced writers are on standby to deliver to you a quality written paper as per your specified instructions. Order Now, and enjoy an amazing discount!!

Solution

Wild Wood Apartments: database design

Is this question part of your Assignment?

We can help

Our aim is to help you get A+ grades on your Coursework.

We handle assignments in a multiplicity of subject areas including Admission Essays, General Essays, Case Studies, Coursework, Dissertations, Editing, Research Papers, and Research proposals

Header Button Label: Get Started NowGet Started Header Button Label: View writing samplesView writing samples