1 / 27

BSYS 2060 Lecture 4, April 12 th

BSYS 2060 Lecture 4, April 12 th. Midterm overview Normalization. Agenda. External events Announcements Midterm format Course questions Normalization Bank database exercise Team project. http://www.vef.org/. http://www.newventuresbc.com/the-competition/about-the-competition/.

lowell
Download Presentation

BSYS 2060 Lecture 4, April 12 th

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. BSYS 2060Lecture 4, April 12th Midterm overview Normalization

  2. Agenda • External events • Announcements • Midterm format • Course questions • Normalization • Bank database exercise • Team project

  3. http://www.vef.org/

  4. http://www.newventuresbc.com/the-competition/about-the-competition/http://www.newventuresbc.com/the-competition/about-the-competition/

  5. Announcements • If you miss labs because of Easter stat holidays, you need to do the lab exercise outside of regular lab time • If you miss your Friday lab because of Open House, you can go to one of the other lab slots

  6. Midterm Format: Free range – open book, open Internet… the only un-natural part is you can’t collaborate. Image source: “truly free range chickens” by Brookford Farm, CC BY 2.0

  7. Held during your Week 5 lab 50% - Multiple Choice, 25 questions worth 2 each 50% - Data Modeling question, 1 page

  8. You are writing the questions… * * At least some of them • Each student in their Week 4 lab needs to come up with a multiple choice question • Question topics assigned by set • Use local context where applicable in your questions • Use images where applicable • Sample question process

  9. https://zenportfolios.ca/groups/bsys-2060-2012/forum/

  10. https://zenportfolios.ca/bcit-bsys-2060-2012/midterm-question-submission/https://zenportfolios.ca/bcit-bsys-2060-2012/midterm-question-submission/

  11. Normalization… Source: http://www.flickr.com/photos/caius/2300154566/

  12. Normalization defined: In relational database design, the process of organizing data to minimize redundancy. Source: http://www.webopedia.com/TERM/N/normalization.html

  13. Why bother? Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. Source: http://www.webopedia.com/TERM/N/normalization.html

  14. Why bother? The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships. Source: http://www.webopedia.com/TERM/N/normalization.html

  15. First normal form 1. Atomicity & uniqueness… No repeating elements or groups of elements and each row of data must have a unique identifier (i.e. primary key)

  16. Second normal form 2. No partial dependencies on a concatenated key

  17. Third normal form 3. No dependencies on non-key attributes

  18. An example… orders

  19. First normal form 1. Atomicity & uniqueness… No repeating elements or groups of elements and each row of data must have a unique identifier (i.e. primary key)

  20. So far, it doesn’t meet criteria for 1NF

  21. Second normal form 2. No partial dependencies on a concatenated key

  22. Summary

More Related