1 / 15

Ft. Kent Weather Database

Ft. Kent Weather Database. Student: David Southern Instructor: Tony Gauvin 27 April 2009. Proposal. My Initial Proposal was for a weather database for the Month of April for Fort Kent, However, I was having so much fun creating it, I also added the month of March to my database.

erasmus-ewing
Download Presentation

Ft. Kent Weather Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ft. Kent Weather Database Student: David Southern Instructor: Tony Gauvin 27 April 2009

  2. Proposal • My Initial Proposal was for a weather database for the Month of April for Fort Kent, However, I was having so much fun creating it, I also added the month of March to my database.

  3. Database Layout • My database is comprise of three tables, • With the names of: location, march, and april. The structure of which, should become obvious in the following slides. • After sketching the database design out, I created the database using the following steps. My database can be found on my littleblack server.

  4. Creating the Database

  5. Creating Tables

  6. Populate the Tables

  7. Creating View for Users • After testing my database, I then created a series of views for my users, using the following steps. These are just two, out of • the four that I created for my users.

  8. Creating Views (cont)

  9. Create Views (cont)

  10. Actual Views

  11. Actual Views (cont)

  12. Things I learned • I found out I really like databases! There is a tremendous amount of skill involved to be able to build and manipulated databases correctly.

  13. Problem Areas • The biggest problem that I had concerns using Datetime data types. Under SQL Server 2005, Datetime produces the date and time, along with minutes and seconds. To get around this, I ended up in my views converting the dates to CHAR. • This nagging problem has been corrected in SQL Server 2007, with the DATE data type

  14. References • The following I used to collect and verify my data in my database. • http://www.weather.com • http;//http://www.wunderground.com • My own home weather station

  15. Additional Inclusions in my Capstone • Script I created to create my tables, and populate the tables. • Four scripts to create my views that I provided for my users.

More Related