Discussion Post 1
In the programming environment, a function is a named chunk of code that executes a certain action on some specified entities or parameters. There are indeed built-in and user-defined methods. The syntax of the examples given may distinguish among programming languages. To demonstrate the instances, I have been using the Python programming language. Instances of built-in functions include sum (), which computes the total of values, and len(), which computes the size of a string. To show, use print (). Here are some examples of user-defined functions (Kaur, 2017).
reverse string(string1) def:
string1[::-1] = s
print(s)
In this case, a parameter string1 is used as an argument, which would be flipped inside of the method and printed to the screens and used the print function.
SQL functions are frequently used modules that help with database handling, deception, and preservation. SQL functions include basically sub-programs and are often used and re-used in Sql query systems for data handling or manipulation. All SQL database management systems provide DDL (data definition language) and DML (data manipulation language) capabilities to facilitate the development and management of databases. To convert character codes, we can have either UPPER or LOWER. The CONCAT function connects two words. It is an abbreviation for concatenation, which is the process of applying two parameters. You normally pass the SUBSTR function two values the beginning and end positions of the string you’re looking for. If you do not really indicate an ending point, the string will be filled in from the beginning (Fekete, 2005).
If you are concerned about unnecessary spaces or padding within your parameters, this is just another highly handy method. Like the one in Excel, the TRIM function eliminates this from the very fields we pick. In some cases, you may simply wish to get a portion of the string. Most of the time, we utilise the LEFT function for this. Occasionally all you really need to know is the very first few letters of a string, or simply should really get a list of all product descriptions that begin with Ford. The LEFT function takes a global variable or variable as well as a character width to output. Therefore if you really want just left 4 of something like the product. Name parameter, it would have been LEFT. The RIGHT function works on the same principle, only it pulls the characters upon that right side of the screen (Fekete, 2005).
References
Fekete, A. (2005). Teaching transaction management with SQL examples. ACM SIGCSE Bulletin, 37(3), 163-167. doi: 10.1145/1151954.1067492
Kaur, K. (2017). An Illustrative Approach to Use SQL Functions: A Review. International Journal Of Engineering And Applied Computer Science, 02(03), 114-122. doi: 10.24032/ijeacs/0203/05
Functions are simply sub-programs, which are commonly used and re-used throughout SQL database applications for processing or manipulating data. All SQL database systems have DDL (data definition language) and DML (data manipulation language) tools to support the creation and maintenance of databases.
DDL is responsible for tasks related to database creation, modification, and maintenance, while DML is responsible for tasks related to the manipulation of data, which essentially means DML is the programming interface of the database (Norman W. Paton, 1999). The DML, like other programming languages, consists of instructions which are used to process or compute data within the database. The DML also supports functions, and these are referred to as SQL functions. SQL functions are small programs that may have zero or more input parameters but can return only one value. These built-in functions can be divided further into aggregate functions or scalar functions. Meanwhile, user-defined functions are functions which are created by the user for a specific purpose. The user-defined functions can either return a single value or a set of values.There are many ways to classify SQL functions. The easiest is to divide them into built-in functions and user-defined functions. The built-in functions are standard functions which are already provided by the SQL database system, and most of these functions are defined clearly in the ANSI (American National Standards Institute) SQL standards (Vaswani, 2009).
The key point to note here is that every function acts on each row of data, and a function can contain another function. The trim function removes trailing blanks from any field. The concat function then concatenates the firstName and lastName fields, inserting a comma in between to produce the complete name. The len function gives the length of the full name, including the comma and blank space in between firstName and lastName. Here the concat, trim, and len functions act on each row of data in the table and return new values and fields as shown. .
References
Norman W. Paton, O. D. (1999). Active database systems. ACM Computing SurveysVolume 31. Retrieved from https://dl-acm-org.eu1.proxy.openathens.net/doi/10.1145/311531.311623
Vaswani, V. (2009). MySQL Database Usage & Administration. McGraw Hill Professional.
Function can be expressed as the relation between two elements in which every input parameter have an outcome variable. It really is utilised for designing better guidance system. There in field of automation, functions have been used. Functions are used in the construction of buildings and bridges. Functions are quantitative approximations of numerous input-output combinations in the actual world. A beverage, snack, or stamp dispenser, for instance. The user inserts money, presses a certain button, and an object falls into the payout slot. The area of a circle is proportional to its diameter. Arm length varies with height. The efficiency of an automobile in measures of miles per gallon of fuel seems to be a function. The efficiency of an automobile may be affected by its design, performance, and other variables (D’Argembeau et al, 2011).
In actual situations, functions may be found everywhere. That’s why they’re so vital in arithmetic. You have quite a function whenever one action effects another. The description of a function is more broad. The inputs and outputs are both open to interpretation. The method for computing compounded interest is the very first applications and web that springs immediately to mind. Loan repayments are determined using a similar formula. In both cases, the inputs are the principal amount, that rate of interest, and indeed the loan term. You may wish to pick among two different routes, one with higher tolls and one with greater kilometres. You might compare different routes using functions (Lux, & Wolf, 2006).
Ownership is a frequent example. Just about everything that you came in contact with is owned by someone. This indicates that items serve a purpose for their owners. Numerical functions can be found everywhere. They are just a means of defining specific types of relationships between objects. Fundamentally function is a chunk of script that operates after invoking it. In a real-life example, assume you purchased a new gadget for the home. However, so rather than opening a box, you place it in the storage closet for future use. The appliance seems to be the function there, as well as the label is the brand. You’ll have to utilise it at some time. So, they open the package, and read the handbook. Afterwards we plug it in and it begins to work (Lux, & Wolf, 2006).
References
D’Argembeau, A., Renaud, O., & Van der Linden, M. (2011). Frequency, characteristics and functions of future-oriented thoughts in daily life. Applied Cognitive Psychology, 25(1), 96-103. doi: 10.1002/acp.1647
Lux, S., & Wolf, K. (2006). Daily Life of the Vikings. Daily Life through History. The Sixteenth Century Journal, 37(3), 837. doi: 10.2307/20478042
Sample Solution
