0
List at list two reasons why database systems support data manupulation using a declarative querry language such as SQL instead of just using C or C functions to carry out data manupulations?
Wiki User
∙ 14y ago
Whichever UTECH person this is, Stop Being lazy and go research the questions.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How are relationship between tables expressed in a relational database?
Tables are the basic building blocks of a relational database.
Distinguish between a relation and a relationship in database?
Relation is one record in the database or a tuple. Relationship is that how tables are connected to each other.
What is the difference between data model and schema in database?
As I understand it, a database schema is a physical entity, it describes the structure of exactly how the data is stored and is itself stored by DBMS for reference. Data model, on the other hand, is an abstract representation of database.
How are tables linked in a relational database?
They just are
How do you build a relational database in excel?
You dont
Functions of database manager in Database management system. explain the functions with example.?
functions of DBA in DBMS
Functions of a typical database management system?
Functions of a typical database management system?
What category of excel functions retrieves and analyzes data?
Database Functions can and so can Statistical Functions. It depends on what it is you want to do.
What are the two main functions of database?
Functions of a Database Management System: - Database Definition - Database creation (storing data in a defined database) - Retrieval (query and reporting) - Update(Changing the contents of the database) - Programming User Facilities for system development) - Database revision and restructuring - Database integrity control - Performance Monitoring
What are the main functions of a database management system?
create the database
What software has the use of queries and reports as key functions?
database
Why database system support data manipulation using a declarative query languages?
Declarative query languages allow users to specify what data they want without specifying how to retrieve it. This abstraction simplifies the querying process and allows for optimization by the database system to determine the most efficient way to execute the query. It also enhances portability and adaptability by separating the query logic from the database structure.
Why is it better to use data manupulation using SQL than C or C functions?
Simple answer, because that is what the database is supposed to do, it is built for it and efficient at it. Extracting data, creating database overhead, much larger data set than what is needed, the resulting network traffic; all not a logical approach. The best approach is to call a procedure within SQL (Which is compiled) with parameters and allow SQL server to parse, and access the data in the most efficient manner, returning only the data that is required.
Excel functions are organized into?
They are organised into categories. Those categories are: Database functions Date and time functions Engineering functions Financial functions Information functions Logical functions Lookup and reference functions Math and trigonometry functions Statistical functions Text functions External functions Cube functions
Plsql procedures and functions?
Are really important in an Oracle Database.
What is the software that functions as an electronic version of a filing cabinet?
database
Advantages and disadvantages of foxpro?
discuss database and field functions
