Cst221 database systems ii
Download
1 / 116

CST221: Database Systems (II) - PowerPoint PPT Presentation


  • 74 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


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






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


  • Show the Enum, name, salary of all employees whose names have 5 letters.


  • Show the name, Enum ,salary, and age of all employees with a salary > $40,000ANDyounger than 25


  • Show the Enumof all employees sorted by salary in the ascending order




  • List top 5 high paid employees.


  • List the LName of all employees in the department (Dnum) entered by the user.


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


  • List the max, min, and average of salary for all employees.












What will be the result? a count of these employees, their average age, and maximum salary


  • For each department list a count of these employees, their average age, and maximum salary avg, max and min age, along with a count of employees in each department.







Maintenance
Maintenance average age and number of employees.

  • Record addition, page AC 144

  • Search, page AC 145

  • Record update, page AC 147

  • Record deletion, page AC 148

  • Filter, page AC 149


ad