Unit 7 Research Assignment 1

Unit 7 Research Assignment 1 Procedural language is a type of computer programming language that specifies a series of well-structured steps and procedures within its programming context to compose a program. It contains a systematic order of statements, functions and commands to complete a computational task or program. It is also known as imperative language. Advantages of procedural language is easy to read program code, easy maintainable program code as various procedures can be debugged in isolation, and code is more flexible as you can change a specific procedure that gets implemented across the program. A declarative language describes what it wants to accomplish rather than focusing on how to achieve its goal. Writing a declarative program is not about specifying a sequence of statements to run one after another to create an application, but to write declarative statements that show a relationship between each other. The advantage of declarative programming languages is mainly two-fold. The programs are concise; this makes it easy even for non-programmers to obtain solutions. The second advantage of the declarative programming model is that repetitive imperative code that indicates how to solve things is provided in the computer system behind the scenes. Such code can be made highly efficient and can incorporate the best ideas from computing. A cross join produces a cartesian product between the two tables, returning all possible combinations of all rows. It has no on clause because you're just joining everything to everything.