There are a few ways to interface with a database. These include using stored procedures and passing raw queries directly in the database. Stored procedure is often used to input data into a table whatever result you are looking for. Using templates of sorts. As we see in AWS the ability to manipulate the table using different data types which is called system stored designs. Now, passing raw queries is a way to take a more manual control of what the database is instructed to do, based on the coding language being used.
Both approaches can be used to create a screen to search for students depending on the criteria being used. Let’s break it down (please feel free to correct me if I am wrong).
Raw Queries has its advantages as well. The ability to access the data required without having to manipulate stored procedures to get what you want is a plus. You can also integrate data from several databases, and these allows access to more data and view records in a specified search or criteria. In the end the screen provides the options for the student’s data such as creating more tables, changing, and removing queries and being able to access all relevant data easily to be productive and orderly.
Respond To At Least 2 Of Your Fellow Classmates With At Least A 100-word Reply About Their Primary Task Response is rated 4.8/5 based on 287 customer reviews.
Are you in need of homework help?
Place your order and get 100% original work.
Data Manipulation Language (DML) allows users to use commands to query or search a database for information, and determine how the information should be displayed. The returned results is called a result set, and is presented in a table format. The content of each column and row in the table can be specified by refining the search. Result sets can be created using three query methods, Aggregation, Filtering, and Union. Aggregation combines rows from a table or result set in one or more subsections used to produce additional information. Filtering is an operation where information in a result set is selectively displayed. Union combines multiple result sets into one result set.
Aggregation allows the user to collect the values of multiple rows as input on certain criteria to return a single value. Aggregate functions include COUNT, SUM, MIN, MAX, and AVG. The COUNT function counts how many rows are in a particular column. The SUM function adds all the values in a particular column. The MIN function returns the lowest value in a particular column. The MAX function returns the highest value in a particular column. The AVG function calculates the average of a group of selected values.
Filtering allows the user to view only the selected information from a database query without changing the design of the database. The result set from a filter will only display content from the data that was selected, all other content is hidden from view. Several types of filters are available, each of which will perform different functions. Common filters allows users to filter information for specific values or a range of values. Filter by Selection allows users to filter all rows in a table that contain a value that matches a selected value in a row by filtering the datasheet view. Filter by form allows users to filter on several fields in a datasheet. Advanced filter allows users to customize the filter settings.
The Union method of query groups the result set of two or more SELECT statements, and does not duplicate any values in the set. The SELECT statement must have the same number of columns, must be in the same order, and must have similar data types. These three methods of query discussed allows the user to query data from multiple tables, and produces a result set in a temporary table rather than creating a whole new table in the database. It is a convenient method to gather information from existing tables in the database. The user can choose different methods to create a result set based on whatever is needed to be displayed in the result set.