csc 545 database systems n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
CSC 545: Database Systems PowerPoint Presentation
Download Presentation
CSC 545: Database Systems

Loading in 2 Seconds...

play fullscreen
1 / 98

CSC 545: Database Systems - PowerPoint PPT Presentation


  • 150 Views
  • Uploaded on

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, …

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'CSC 545: Database Systems' - varian


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
csc 545 database systems

CSC 545: Database Systems

Dr. Zhen Jiang

Computer Science Department

West Chester University

class information
Class information
  • Website www.cs.wcupa.edu/~zjiang/csc545index.htm
slide3
Why this class?
    • Job hunting
      • WCU graduated, Database, Software Engineering, …

vs.

      • Undergraduates
      • UPenn, Temple, Drexel, …
    • Something help you to stand out!
slide4
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
slide5

No pain, no gain

    • Need to handle those things coming from pressure: frustration, upset, madness, etc.
    • Looking for solution, not excuse.
    • Deadline!
slide6
Class website (including ppt)+ google search
  • Hands-on experience
  • Group discussion
  • Happy ending!
slide7
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
Where do you find data?
  • Share the experience of data processing: Word, Power point, Excel, IE, and etc.
slide9
Word
  • <Insert>
    • <Symbol>
  • <Copy> & <Paste>
    • <Ctrl> <c>  <Ctrl> <v>
    • <PrtSc> & <Alt> <PrtSc>  <Ctrl> <v>
  • <Ctrl><p>

Summer Training on Computer Science, WCU

power point
Power Point
  • <Insert>
    • <Date and Time>

!

Summer Training on Computer Science, WCU

slide11
<Slide Show>
    • <Custom Animation>, <Add Effect>, <Motion Path>

!

Summer Training on Computer Science, WCU

excel
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

slide13
<Insert>
    • <Chart>

!

Summer Training on Computer Science, WCU

slide18
IE

Summer Training on Computer Science, WCU

slide21

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
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
slide23

More efficient manner to store, search, and display the data!

    • Conditional search
    • Wildcard match
database systems access
Database Systems & Access
  • Is PC more popular?
  • What is you laptop brand?
  • What OS is installed, Linux or Windows?
  • Access
access
Access
  • <Start>  <All program>  … <Microsoft Office Access 2007>
slide31

Input & Output

    • Page AC211
slide42

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
slide52

Datasheet view

  • Design view
slide85

List the LName of all employees with a new column labeled “hiring age”, which has a value by subtracting the years of working (wYears) from the current age (age).

slide98

Wildcard (*, ?), such as “Ber*” in City field

  • Use criteria for a field not included in the result list, disabled show property
  • One table, decide it early and add all fields at the beginning
  • Comparison Operator, such as >10000 in amount paid field
  • Compound criterion (AND => 1 row, OR => another row)
  • Sorting
  • Omitting duplicates, “unique record” in property sheet
  • Multiple keys (high priority from left to right)
  • Top-value query, “return” in top design view (very early stage)
  • Calculated field, “zoom” in shortcut menu (e.g., type “Total Amount:[Amount Paid]+[Current Due]”)
  • Calculating Statistics (built-in statistics, “group by”)