1 / 98

CSC 545: Database Systems

CSC 545: Database Systems. Dr. Zhen Jiang Computer Science Department West Chester University. Class information . Website www.cs.wcupa.edu/~zjiang/csc545index.htm. Why this class? Job hunting WCU graduated, Database, Software Engineering, … vs. Undergraduates UPenn , Temple, Drexel, …

varian
Download Presentation

CSC 545: Database Systems

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. CSC 545: Database Systems Dr. Zhen Jiang Computer Science Department West Chester University

  2. Class information • Website www.cs.wcupa.edu/~zjiang/csc545index.htm

  3. Why this class? • Job hunting • WCU graduated, Database, Software Engineering, … vs. • Undergraduates • UPenn, Temple, Drexel, … • Something help you to stand out!

  4. Research project • Critical thinking, communication, well-plan, etc. • Real competition, deadline, pressure • More realistic system, complex programming, for instance, http://www.cis.temple.edu/~jiang/RSU_van.pptx. • Student opportunities: http://www.cs.wcupa.edu/~zjiang/student_info.htm • Sponsorship • NSF, NSA, etc • Industry interns

  5. No pain, no gain • Need to handle those things coming from pressure: frustration, upset, madness, etc. • Looking for solution, not excuse. • Deadline!

  6. Class website (including ppt)+ google search • Hands-on experience • Group discussion • Happy ending!

  7. How do you like to be introduced? • No pain, no gain • Happy ending • Need to handle those things coming from pressure: frustration, upset, madness, etc. • Looking for solution, not excuse. • Deadline!

  8. Where do you find data? • Share the experience of data processing: Word, Power point, Excel, IE, and etc.

  9. Word • <Insert> • <Symbol> • ≥ •  • <Copy> & <Paste> • <Ctrl> <c>  <Ctrl> <v> • <PrtSc> & <Alt> <PrtSc>  <Ctrl> <v> • <Ctrl><p> Summer Training on Computer Science, WCU

  10. Power Point • <Insert> • <Date and Time> ! Summer Training on Computer Science, WCU

  11. <Slide Show> • <Custom Animation>, <Add Effect>, <Motion Path> ! Summer Training on Computer Science, WCU

  12. Excel Document resource: www.cs.wcupa.edu/~zjiang/summer07_student_grade_sample.xls. =average(c6:c28) Another well used function: SUM ! Summer Training on Computer Science, WCU

  13. <Insert> • <Chart> ! Summer Training on Computer Science, WCU

  14. <view> <freeze panes> • B2, $b$2

  15. Data preparation

  16. IE Summer Training on Computer Science, WCU

  17. Summer Training on Computer Science, WCU

  18. Summer Training on Computer Science, WCU

  19. Information stored in word, Excel, Powerpoint, PDF, txt (plain text), etc • Share/exchange information • PrimoPDFhttp://www.primopdf.com/index.aspx

  20. What do we do with data? • Exercise 1 • http://www.cs.wcupa.edu/~zjiang/545_data.pdf • Data curving • 2D • 3D surface • Data extraction and recreation • Data search

  21. More efficient manner to store, search, and display the data! • Conditional search • Wildcard match

  22. Database Systems & Access • Is PC more popular? • What is you laptop brand? • What OS is installed, Linux or Windows? • Access

  23. Exercise 1: http://www.cs.wcupa.edu/~zjiang/csc545_lab1.doc

  24. Access • <Start>  <All program>  … <Microsoft Office Access 2007>

  25. √

  26. Input & Output • Page AC211

  27. Plain text file

  28. Excel file (xls or xlsx)

  29. Wildcard (*, ?), page AC87 • Use criteria for a field not included in the result list, page AC88 • Parameter Query, page AC89 • Join table, page AC103 • Comparison Operator, page AC94 • Compound criterion (AND, OR), page AC 95 • Sorting, page AC97 • Omitting duplicates, page AC 100 • Multiple keys (high priority from left to right), page AC101 • Top-value query, page AC 102 • Calculated field, page AC 113 • Calculating Statistics (built-in statistics, group), page AC 117

  30. Show the name and age and salary of all employees who are younger than 25.

  31. Double click the items to include in the list

  32. Add criteria to meet the certain requirement

More Related