1 / 59

Why do I care what a database is?

Why do I care what a database is?. A Choose Your Own Adventure Lecture By Mr. Matzen. Once upon a time, Mr. Matzen had a part time job working at…. A Bank. A Music Store. At that music store Mr. Matzen…. Worked diligently everyday Had a lot of free time to think

sinead
Download Presentation

Why do I care what a database is?

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. Why do I care what a database is? A Choose Your Own Adventure Lecture By Mr. Matzen

  2. Once upon a time, Mr. Matzen had a part time job working at… A Bank A Music Store

  3. At that music store Mr. Matzen… • Worked diligently everyday • Had a lot of free time to think • Played FreeCell and listened to music

  4. As the employee of the year competition approached Mr. Matzen… • Began looking for a way to win • Gave up immediately and quit • Starting sabotaging the work of other employees

  5. The first thing Mr. Matzen tried… Was forging timecards to overstate the hours of other employees Was drawing silly pictures of the boss on the counter and blaming others

  6. Without a job Mr. Matzen was hired as a bank teller. On his first day of work he wore… Appropriate business attire A warrior outfit

  7. Mr. Matzen spent his time thinking about… Whether Cheetos were snacks or chips How to make his job easier

  8. The customers kept interrupting FreeCell so Mr. Matzen… Put out the closed sign an hour early Decided to work on making his job easier, so he could play

  9. After several long windeddebates Mr. Matzen started… Writing a letter to Frito Lay Yelling at customers to get their opinions

  10. Unfortunately the boss showed up unexpectedly and Mr. Matzen was fired on the spot. Let’s try a different career.

  11. Mr. Matzen decided that the best way to win the competition was… Working lots of overtime Creating a better way to sort the merchandise PLAN A PLAN B

  12. The hours of overtime took a toll on Mr. Matzen’s grades so he had to reconsider his decision. PLAN B

  13. At that time the store did not use a computer to monitor inventory. The store paid $3 for each CD and $5 for each DVD. The sales price was decided by the clerk. All CDs and DVDs were placed alphabetically in the store.

  14. What were some of the problems with this system? • Don’t know what was in inventory. • Don’t know the quantity in inventory. • Paid the same for Eminem and Paula Abdul • Inconsistent pricing of identical items. • All styles of music are mixed together, making it more difficult to sort and more difficult to find items.

  15. What could Mr. Matzendo to fix these problems? • Create a table with Microsoft Word • Create a table with Excel • Create a table with Access

  16. There is a better answer.

  17. A database is correct but why? • A table in a database appears similar to a table in spreadsheet, but the function is different. • A spreadsheet is used to do mathematic calculations on the data assembled. • A database is used to do easy searches (queries) of the data assembled.

  18. Knowing he needed to use a database Mr. Matzen… Researched databases carefully Dove in head first to Access

  19. During the research he read about 4 database components. • Table – a collection of related information organized in columns and rows • Query – an instruction to do a job, such as locating records with certain characteristics • Form – a database object you can use to enter, edit, view, and print database info. • Report – a database object that presents database information in an accessible way

  20. Mr. Matzen opened Access and became frustrated so he… Sang Karaoke to let off steam Decided to research databases

  21. Boo him off stage. Applaud loudly.

  22. Fine. You don’t like my singing? Then take some notes over… Databases

  23. The fame quickly went to Mr. Matzen’s head and he… Tried a comedy routine Tried his hand at acting

  24. Quit your job. A star is born. Get back to databases.

  25. Quit your job. A star is born. Get back to databases.

  26. After quitting his job Mr. Matzen realized he had no talent and… Looked for another job Began the database research

  27. Record Field Creating a table was the first step. • The rows are Records (all the data for an individual item) • The columns are Fields (the different types of data we want to know)

  28. Artist Album Price Buy Used Price Buy New Price Sell Used Price Sell New Number of Copies Number of Copies Desired Trade Value CD or DVD Style What fields need to be included in the CD/DVD database?

  29. Mr. Matzen entered all of this information into a database and Everything worked perfectly He forgot one little thing

  30. Mr. Matzen started bragging about this system to everyone. Soon he ate his words. He even held a press conference.

  31. At this press conference, a reporter asked Mr. Matzen… What about special editions? Why are you so tall?

  32. Now tell us about the Special Editions. I’m so confused. Give us more notes please.

  33. What about Special Editions or Remakes? How do you differentiate between two items with the same name? Give us a hint. No idea. Give us the answer.

  34. Should we add a field or change a field we already have? Change Add

  35. Should we add a word or a number? Word Number

  36. What number should we add? Create a number Barcode

  37. The barcode is the key. An item is specifically identified by that number. It is unique to each version or edition of an item. So why do we care? What is a barcode?

  38. Here is a barcode. Please lecture about Wal-Mart and barcodes Let’s get back to databases

  39. The story of Wal-Mart Now on to database

  40. Why do you care about barcodes? So we can understand… Primary Keys Wal-Mart’s Success

  41. A primary key is the part of a database unique to one item. When connecting two databases the primary key is needed as a reference to match items. Enough talk. Let’s get on the computers. How about another example.

  42. At that time the bank tracked accounts by social security number. Last name, first name, social security number, and address were the only information stored on the computer.

  43. What were some of the problems with this system? • No room for multiple account owners. • Does not differentiate between account types. • Does not specify the account.

  44. What could Mr. Matzendo to fix these problems? • Alter a table with Microsoft Word • Alter a table with Excel • Alter a table with Access

  45. There is a better answer.

  46. A database is correct but why? • A table in a database appears similar to a table in spreadsheet, but the function is different. • A spreadsheet is used to do mathematic calculations on the data assembled. • A database is used to do easy searches (queries) of the data assembled.

  47. Knowing he needed to use a database Mr. Matzen… Researched databases carefully Dove in head first to Access

  48. During the research he read about 4 database components. • Table – a collection of related information organized in columns and rows • Query – an instruction to do a job, such as locating records with certain characteristics • Form – a database object you can use to enter, edit, view, and print database info. • Report – a database object that presents database information in an accessible way

  49. Mr. Matzen opened Access and became frustrated so he… Took a trip to Graceland Decided to research databases

  50. All Shook Up At The King’s Grave. Heartbreak Hotel With Joshua Jackson.

More Related