0
What are some basic database functions that a spreadsheet cannot perform?
Wiki User
∙ 12y ago
A spreadsheet is a computer application that simulates a paper accounting worksheet. It displays data in a two-dimensional matrix or grid consisting of rows and columns. Each column is a field, which used to define and store data and each row is a record, which is a connected set of one or more fields that describes an object such as person. While a spreadsheet allows for the creation of multiple tables, it does not support even the most basic database functionality such as support for self-documentation through metadata, enforcement of data types or domains to ensure consistency of data within a column, defined relationships among tables, or constraints to ensure consistency of data across related tables.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What are some basic database functions that spreadsheet cannot perform?
ms office
What are the functions of a typewriter?
Answerthe function of a type writer is to get result along as we type.it is not strenuous and it also does not affect our eyes.it only has one disadvantage thatis once a mistake is made while typing cannot be corrected
Compare the use of embedded SQL with the use in SQL of functions defined in a general-purpose of Programming language Under what circumstances would you use each of these features?
SQL functions are primarily a mechanism for extending the power of SQL to handle attributes of complex data types (like images), or to perform complex and non-standard operations. Embedded SQL is useful when imperative actions like displaying results and interacting with the user are needed. These cannot be done conveniently in an SQL only environment. Embedded SQL can be used instead of SQL functions by retrieving data and then performing the function's operations on the SQL result. However a drawback is that a lot of query-evaluation functionality may end up getting repeated in the host language code Regards, Jose Deleep. S
Are the php functions overloading allowed?
You cannot overload PHP functions. Function signatures are based only on their names and do not include argument lists, so you cannot have two functions with the same name. Class method overloading is different in PHP than in many other languages. PHP uses the same word but it describes a different pattern.You can, however, declare a variadic function that takes in a variable number of arguments. You would use func_num_args() and func_get_arg() to get the arguments passed, and use them normally.For example:// *******************************************function myFunc() {for ($i = 0; $i < func_num_args(); $i++) {printf("Argument %d: %s\n", $i, func_get_arg($i));}}/*Argument 0: aArgument 1: 2Argument 2: 3.5*/myFunc('a', 2, 3.5);// ********************************************
How many type of SQL?
There are three types of SQL: 1. Cognos SQL 2. Native SQL 3. Pass-through SQL Cognos SQL Framework Manager generates Cognos SQL in a more efficient manner in order to keep its functionality. It is common for Cognos SQL to be translated into Native SQL before being transmitted to the database for processing. Some actions or functions may not be supported by the database in some instances. Only a portion of the Cognos SQL is transmitted to the database in these situations. As a result, the database handles part of the query and the Cognos server handles the rest. Advantages: Has the ability to include metadata from many sources. Reduce the number of database constraints Interact more effectively with Cognos applications. Disadvantages: You cannot use non standard SQL. Native SQL Databases such as Oracle, SQL Server, and DB2 all support SQL. Using Native SQL in a model query subject with many data sources is not possible. Advantages: All relevant query subjects are optimized for performance. You can utilize SQL that is specific to the database you are using. Disadvantages: You cannot use SQL that the data source does not support for sub queries. The query subject may not be compatible with different database types. Pass-through SQL Allows the usage of Native SQL without regard to the limitations imposed on subqueries by the data source. Subqueries are not processed in Pass-Through SQL query subjects. It is instead supplied directly to the data source that generates query results for each subject. It is important to keep in mind that pass-through SQL is delivered straight to the data source rather than being optimized by the Framework Manager, therefore performance will be lower than with the other query options. Using curly brackets around your SQL statement in a Tabular SQL object causes that SQL statement to be passed through to the database. Cognos has not validated this SQL, so take that into consideration. Step1: Create a Tabular SQL object. Write a statement surrounded with { }. Actual: SELECT * FROM ORDER HEADER Pass-Through: {SELECT * FROM ORDER HEADER} Advantages: You can use any SQL supported by the database. Disadvantages: Framework manager does not have the ability to automatically optimize performance. In some cases, the SQL won't function with another data source.
What are some basic database functions that spreadsheet cannot perform?
ms office
What functions does project management software provide that you cannot do easily using other tools such as a spreadsheet or database?
i would like to know the fuctions that the project management software provide that you cannot doeasily using other tools such as a spreadsheet or data base?
What type of operation can you perform in MS-EXCEL which you cannot do on a database?
d
How does Nitrous oxide function in the body?
it helps in biological functions when the body cannot perform these functions
Why do complex organisms need specialized cell?
Complex organisms need cells that perform many different functions. Complex organisms are capable of a lot of different things, and that variety needs to be supported on the cellular level. Without them, complex organisms cannot perform different functions.
What could happen if coronary blood vessels cannot perform their functions?
dthjftjh
If you cannot perform the essential functions of this job without reasonable accommodation?
yes or no
Why Databases might be better than word processor documents and Spreadsheet documents for the job that they do?
Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.
why are cell organelles important?
because without it cells cannot perform any functions and so there will be no life
Why are complex organisms made up of specialized cells?
Complex organisms need cells that perform many different functions. Complex organisms are capable of a lot of different things, and that variety needs to be supported on the cellular level. Without them, complex organisms cannot perform different functions.
What are the procedures in rdbms?
In an RDBMS (Relational Database Management System), the procedures are typically defined as a set of structured query language (SQL) statements that are stored and executed within the database. These procedures can include functions, triggers, and stored procedures. Functions are used to perform calculations or manipulate data, triggers are used to automatically execute actions when specific events occur, and stored procedures are pre-compiled routines that can be called to perform a specific set of operations on the database. These procedures help in maintaining data integrity, enforcing business rules, and improving performance.
What is difference between Excel and RDBMS?
Excel is a spreadsheet application. RDBMS is a Relational Database Management System. Excel has databasing capabilities, but does not have the capabilities of a relational database. There are many facilities in a RDBMS that Excel cannot do or can only do to a very limited amount. Excel is for numerical analysis and manipulation, which is what a spreadsheet is for. Databases are for managing lists of data. So while they both can manipulate data, they are for different kinds of jobs.
