Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE WRITE A FUNCTION OR METHOD FOR FILTER! DO IT AS SOON AS POSSIBLE! iN JAVA LANGUAGE!! 5. Filter entities (30 points) a. Based on

image text in transcribed

PLEASE WRITE A FUNCTION OR METHOD FOR FILTER! DO IT AS SOON AS POSSIBLE! iN JAVA LANGUAGE!!

5. Filter entities (30 points) a. Based on any given field or set of fields and according to some rules: b. string fields i. starts with ii. ends with iii. contains iv. null c. date, time, and numeric fields i. equal (eq) ii. greater than (gt) iii. less than (lt) iv. greater and equal to (ge) v. less and equal to (le) vi. between (bt) vii. null d. date and time i. in a specific year (y) CSCI 1202 - Programming Principles II Fall / 2021-22 ii. in a specific month (m) iii. in a specific day (d) e. [IF you take clustld as a Boolean value (i.e., is high fatality] i. Equal (eq) [true or false) f. Examples: i. select all the crashes happened in 1962 which has death rate (opposite of survival Rate) greater than 50%. ii. select all the crashes happened any time in 20:00 - 00:00 by operator Aeroflot iii. select all the crashes happened in Cameroon iv. select all the crashes which caused more than 20 dead on the ground 5. Filter entities (30 points) a. Based on any given field or set of fields and according to some rules: b. string fields i. starts with ii. ends with iii. contains iv. null c. date, time, and numeric fields i. equal (eq) ii. greater than (gt) iii. less than (lt) iv. greater and equal to (ge) v. less and equal to (le) vi. between (bt) vii. null d. date and time i. in a specific year (y) CSCI 1202 - Programming Principles II Fall / 2021-22 ii. in a specific month (m) iii. in a specific day (d) e. [IF you take clustld as a Boolean value (i.e., is high fatality] i. Equal (eq) [true or false) f. Examples: i. select all the crashes happened in 1962 which has death rate (opposite of survival Rate) greater than 50%. ii. select all the crashes happened any time in 20:00 - 00:00 by operator Aeroflot iii. select all the crashes happened in Cameroon iv. select all the crashes which caused more than 20 dead on the ground

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases In Networked Information Systems 6th International Workshop Dnis 2010 Aizu Wakamatsu Japan March 2010 Proceedings Lncs 5999

Authors: Shinji Kikuchi ,Shelly Sachdeva ,Subhash Bhalla

2010th Edition

3642120377, 978-3642120374

More Books

Students also viewed these Databases questions

Question

5 The mechanics of the circular flow model.

Answered: 1 week ago

Question

1 The difference between a command system and a market system.

Answered: 1 week ago

Question

4 How the market system adjusts to change and promotes progress.

Answered: 1 week ago