cst221 database systems ii
Download
Skip this Video
Download Presentation
CST221: Database Systems (II)

Loading in 2 Seconds...

play fullscreen
1 / 116

CST221: Database Systems (II) - PowerPoint PPT Presentation


  • 75 Views
  • Uploaded on

CST221: Database Systems (II). Dr. Zhen Jiang Computer Science Department West Chester University West Chester, PA 19383. Querying. Creation (Query wizzard ) Save Use. Wildcard (*, ?), page AC87 Use criteria for a field not included in the result list, page AC88

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 ' CST221: Database Systems (II)' - meira


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
cst221 database systems ii

CST221: Database Systems (II)

Dr. Zhen Jiang

Computer Science Department

West Chester University

West Chester, PA 19383

querying
Querying
  • Creation (Query wizzard)
  • Save
  • Use
slide3

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
slide16

Datasheet view

  • Design view
slide19

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”)
slide50

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).

slide73

Show the average age (label as “average age”) and average salary (label as “average salary”) for all employees

slide89

For all employees in department “D22” or “D28”, show a count of these employees, their average age, and maximum salary

slide106

For each department with an average salary of >40000 list the dnums, employee count for these departments.

slide112

For each department with more than 2 people over 40 list deptNum, and a count of these people.

maintenance
Maintenance
  • Record addition, page AC 144
  • Search, page AC 145
  • Record update, page AC 147
  • Record deletion, page AC 148
  • Filter, page AC 149
ad