- 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