Mynotes for 06.522 Data

• Session 1:
• Session 2:
  • OHT: Memory dump
  • Notes on Addition & subtraction in other bases. (Do you cover subtraction using complementary addition?)
• Session 3:
  • OHT2: Sign magnitude 10000001 = -1 (actually -128 - 1 = -127)
  • Handout 7-bit ASCII representation, EBCDIC and ASCII Codes
• Session 4:
• • References:
    Bar Codes (design, printing and quality control) William H Erdei
    Computers and Information Processing. Fouri & Giouri
  • OHTs Barcodes/UPC
  • Handouts: UPC
  • Exercise: Scanners are good for business.??
• Session 5: Boolean logic
  • Truth tables reordered to match the binary number system 00,01,10,11 (FF,FT,TF,TT)
• Session 6:
  • Reference: Modern Database Management 4th edition pg 255-263
    updated to Modern Database Management 5th edition pp 274-276)
• Session 7: Data structures.
  • Sales figures OHT
  • Linked list paint shop
  • Arrays are often used to store stacks and queues.
• Session 8:
• Session 9:
  • Modern Database Management 5th Ed pg 594-598  (4th Ed pg 260-262)
  • OHT2: B+tree does not match data records (what happened to 100 & 975, and where did 1300 come from!) Can I assume a series of deletion occurred. Believe it will confuse students until they see deletions.
  • Should Bkrfr be Bktfr? (Also in Exercise = Bkfr).
• Session 10:
• Session 11: Intro to DBMS: change 4th to 5th Ed. Page references don't match text.
• Session 12:
• Session 13:
• Session 14:
• Session 15: (Unitec # 13) Basic SQL
  • SQL Principles - needed to rework some of the examples.
    • Changed early examples to correct some table/statement inconsistencies
    • #6 included "AND" in the example "Balance >100000 and Balance < 3000000;
    • # 7. Included COUNT. Select wrong (can't * and fields)
    • Exercise # 5. Example can't include fields
• Session 16 (U#14)
  • Moved Position of group by after aggregate functions.
  •  

Unitec/EIT Bachelor of Computing Systems   [Rev: 24/11/99] 13/1/99