Posted: February 10th, 2022

DB Sys WK 6 Peer Res

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 ================================================================================================================================================================================================================================================================================================== Discussion Post 2 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 Vaswani, V. (2009). MySQL Database Usage & Administration. McGraw Hill Professional. ================================================================================================================================================================================================================================================================================================== Discussion Post 3 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


1st Discussion Post A function in a programming environment is a named block of code that performs a certain operation on some defined entities or parameters. There are both built-in and user-defined techniques available. The syntax of the examples provided may be used to differentiate across programming languages. I used the Python programming language to present the examples. Built-in functions include sum (, which computes the sum of values, and len(), which computes the length of a string. To demonstrate, use print (). The following are some examples of user-defined functions (Kaur, 2017). string reversal (string1) string1[::-1] = s print def (s) In this scenario, a parameter string1 is used as an argument, which is flipped inside the method and written to the screens via the print function.

Check Price Discount

More Assignment Samples: »

Order for this Paper or Similar Assignment Help

Fill a form in 3 easy steps - less than 5 mins.

Why choose us

You Want Quality and That’s What We Deliver

Top Essay Writers

We select the finest writers to join our team. They each have expertise in specific topic fields and background in academic writing.

Affordable Prices

We offer the lowest possible pricing while still providing the best writers. Our costs are fair and reasonable compared to other writing services.

100% Plagiarism-Free

You will never receive a product that contains any plagiarism. We scan every final draft before releasing it to be delivered to a customer.

How it works

When you decide to place an order with Study Pro Essay, here is what happens:

Complete the Order Form

You will complete our order form, filling in all of the fields and giving us as much detail as possible.

Assignment of Writer

We analyze your order and match it with a writer who has the unique qualifications to complete it, and he begins from scratch.

Order in Production and Delivered

You and your writer communicate directly during the process, and, once you receive the final draft, you either approve it or ask for revisions.

Giving us Feedback (and other options)

We want to know how your experience went. You can read other clients’ testimonials too. And among many options, you can choose a favorite writer.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: