1k likes | 1.21k Vues
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, …
E N D
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, … • Something help you to stand out!
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
No pain, no gain • Need to handle those things coming from pressure: frustration, upset, madness, etc. • Looking for solution, not excuse. • Deadline!
Class website (including ppt)+ google search • Hands-on experience • Group discussion • Happy ending!
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!
Where do you find data? • Share the experience of data processing: Word, Power point, Excel, IE, and etc.
Word • <Insert> • <Symbol> • ≥ • • <Copy> & <Paste> • <Ctrl> <c> <Ctrl> <v> • <PrtSc> & <Alt> <PrtSc> <Ctrl> <v> • <Ctrl><p> Summer Training on Computer Science, WCU
Power Point • <Insert> • <Date and Time> ! Summer Training on Computer Science, WCU
<Slide Show> • <Custom Animation>, <Add Effect>, <Motion Path> ! Summer Training on Computer Science, WCU
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
<Insert> • <Chart> ! Summer Training on Computer Science, WCU
<view> <freeze panes> • B2, $b$2
IE Summer Training on Computer Science, WCU
Information stored in word, Excel, Powerpoint, PDF, txt (plain text), etc • Share/exchange information • PrimoPDFhttp://www.primopdf.com/index.aspx
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
More efficient manner to store, search, and display the data! • Conditional search • Wildcard match
Database Systems & Access • Is PC more popular? • What is you laptop brand? • What OS is installed, Linux or Windows? • Access
Access • <Start> <All program> … <Microsoft Office Access 2007>
Input & Output • Page AC211
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
Show the name and age and salary of all employees who are younger than 25.