Transcript PowerPoint
Final Exam CS 110 Fall 2005 Tables http://wp.netscape.com/assist/net_si tes/table_sample.html Review: databases terms from notes What do databases do well? What do they do poorly? spreadsheets vs. databases schema: multiple representations / matched to algorithms basic operations relational databases • • • • • • strengths / weaknesses MSFT Access: filters, forms, and queries relationships (joins): many-to-one, one-to-one, ... referential integrity normalization keys: primary, secondary, foreign http://www.sfubusiness.ca/motmba/courses/bus756/share d/pages/tutorials.html Review: security How data enters your computer through ports/packets Cookies: web bugs, anonymity, how do they work Viruses Email delivery of viruses Email spoofing Email phishing The Netsky virus adware / spyware: how do they work Review: cryptography Confidentiality, correctness, availability plain text, cypher text, key (symmetric vs. asymmetric) steganography permutation substitution DES, avalanche property, small keys are easily cracked public key man-in-the-middle public key attack who is trusted with key distribution and why is trust an issue? online shopping using HTTPS and RSA's keys Review: ethics slides missing from web page. Emphasize readings from plato.stanford.edu what can computers do? think, collect data, search quickly, communicate who owns what? what makes ethical questions unique to computers? examples Review: intellectual property Trademarks Copyrights Patents Review: women in computing women are underrepresented in CS and it’s dropping women use computers as much as men women have math skills women have science skills women are pursuing math, science, and engineering degrees CS lacks the social networking CS has stereotypes and lacks an appropriate cultural environment Remember readings Security • • • • • • • Ethics Basics • • • http://www.brook.edu/its/cei/overview/Ten_Commanments_of_Computer_Ethics.htm http://plato.stanford.edu/entries/ethics-computer/ http://www.cpsr.org/issues/ethics/cei Net Etiquette Readings • • • http://en.wikipedia.org/wiki/Encryption http://en.wikipedia.org/wiki/Malware http://en.wikipedia.org/wiki/Phishing http://en.wikipedia.org/wiki/Computer_virus http://en.wikipedia.org/wiki/Spam_%28electronic%29 http://en.wikipedia.org/wiki/Spyware http://en.wikipedia.org/wiki/Microsoft_Passport http://www.the-eggman.com/writings/etiquitte_1.html http://www.albion.com/netiquette/corerules.html http://www.atra-tr.org/netetiquette.htm Women in Computing • • http://en.wikipedia.org/wiki/Women_in_Computing http://www.cpsr.org/issues/womenintech/herring2