What is Relational Algebra?

What is Relational Algebra?
by

1 Answer

Answer :

It is procedural query language. It consists of a set of operations that take one or two relations  as input and produce a new relation.
by

Related questions

What are the unary operations in Relational Algebra?

Description : What are the unary operations in Relational Algebra?

Last Answer : PROJECTION and SELECTION.

How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?

Description : How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?

Last Answer : The tuple-oriented calculus uses a tuple variables i.e., variable whose only permitted values are tuples of that relation. E.g. QUEL The domain-oriented calculus has domain variables i.e., variables that range over the underlying domains instead of over relation. E.g. ILL, DEDUCE.

What is Relational Calculus?

Description : What is Relational Calculus?

Last Answer : It is an applied predicate calculus specifically tailored for relational databases proposed by E.F. Codd. E.g. of languages based on it are DSL ALPHA, QUEL.

How is the data structure of System R different from the relational structure? Unlike Relational systems in System R

Description : How is the data structure of System R different from the relational structure? Unlike Relational systems in System R

Last Answer : ∙ Domains are not supported ∙ Enforcement of candidate key uniqueness is optional ∙ Enforcement of entity integrity is optional ∙ Referential integrity is not enforced

The Relational Model Database:

Description : The Relational Model Database:

Last Answer : The relational model is the most popular type of database and an extremely powerful tool, not only to store information, but to access it as well. Relational databases are organized as tables. The ... reorganizing the tables. A table can have many records and each record can have many fields.

Which of the following is not a binary operator in relational algebra? A) Join B) Semi-Join C) Assignment D) Project

Description : Which of the following is not a binary operator in relational algebra? A) Join B) Semi-Join C) Assignment D) Project

Last Answer : D) Project

Cartesian product in relational algebra is (A) a Unary operator. (B) a Binary operator. (C) a Ternary operator. (D) not defined.

Description : Cartesian product in relational algebra is (A) a Unary operator. (B) a Binary operator. (C) a Ternary operator. (D) not defined.

Last Answer : (B) a Binary operator.

The “PROJECT” operator of a relational algebra creates a new table that has always (A) More columns than columns in original table (B) More rows than original table (C) Same number of rows as the original table (D) Same number of columns as the original table

Description : The “PROJECT” operator of a relational algebra creates a new table that has always (A) More columns than columns in original table (B) More rows than original table (C) Same number of rows as the original table (D) Same number of columns as the original table

Last Answer : (C) Same number of rows as the original table

Consider the following schemas: Branch = (Branch-name, Assets, Branch-city) Customer = (Customer-name, Bank-name, Customer-city) Borrow = (Branch-name, loan-number, customer account-number) Deposit = (Branch-name, Account-number, Customer-name, Balance) Using relational Algebra, the query that finds customers who have balance more than 10,000 is ................. (A) πcustomer-name(σbalance> 10000(Deposit)) (B) σcustomer-name(σbalance> 10000(Deposit)) (C) πcustomer-name(σbalance> 10000(Borrow)) (D) σcustomer-name(σbalance> 10000(Borrow))

Description : Consider the following schemas: Branch = (Branch-name, Assets, Branch-city) Customer = (Customer-name, Bank-name, Customer-city) Borrow = (Branch-name, loan-number, customer account-number) Deposit = ... )) (C) πcustomer-name(σbalance> 10000(Borrow)) (D) σcustomer-name(σbalance> 10000(Borrow))

Last Answer : (A) πcustomer-name(σbalance> 10000(Deposit)) 

Which of the following is true ? I. Implementation of self-join is possible in SQL with table alias. II. Outer-join operation is basic operation in relational algebra. III. Natural join and outer join operations are equivalent. (A) I and II are correct. (B) II and III are correct. (C) Only III is correct. (D) Only I is correct.

Description : Which of the following is true ? I. Implementation of self-join is possible in SQL with table alias. II. Outer-join operation is basic operation in relational algebra. III. Natural join and outer join operations are ... (B) II and III are correct. (C) Only III is correct. (D) Only I is correct.

Last Answer : (D) Only I is correct.

Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to the column B in table R. One can determine that: (A) I, III and IV are the same query. (B) II, III and IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

Description : Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to ... IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

Last Answer : (D) I, III and III are the same query.

a relational table must not contain a(n) ____. -General Knowledge

Description : a relational table must not contain a(n) ____. -General Knowledge

Last Answer : Relational table must not contain repeating groups.

RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Description : RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Last Answer : (b) RDBMS stands for Relational Database Management System, which provides the operator to manipulate the data stored in the database table.

How are relationship between tables expressed in a relational database?

Description : How are relationship between tables expressed in a relational database?

Last Answer : Tables are the basic building blocks of a relationaldatabase.

What is Relational Database Management System ?

Description : What is Relational Database Management System ?

Last Answer : Database databases are organized in different rows, that is, files are considered only in records, but also in tables with list rows and columns. This type of database is called relational database management system.

In relational table two row are identical is true or false?

Description : In relational table two row are identical is true or false?

Last Answer : False.

How does relational-centred planning differ from traditional models of case planning please help im working as a cyc worker for child and youth care and need help?

Description : How does relational-centred planning differ from traditional models of case planning please help im working as a cyc worker for child and youth care and need help?

Last Answer : Need answer

Is it true or false that a relational database typically consists of related two dimensional tables?

Description : Is it true or false that a relational database typically consists of related two dimensional tables?

Last Answer : Need answer

Effective therapy is an ongoing process of building relational bridges that engender __________ and confidence.?

Description : Effective therapy is an ongoing process of building relational bridges that engender __________ and confidence.?

Last Answer : Cultural sensitivity

The zeroth law of thermodynamics pertains to what relational condition that may exist between two systems?

Description : The zeroth law of thermodynamics pertains to what relational condition that may exist between two systems?

Last Answer : Thermal equilibrium

In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Description : In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Last Answer : Answer :4

What is special about the declaration of relational operators?

Description : What is special about the declaration of relational operators?

Last Answer : Relational operators must be declared in pairs. 

Which method can’t be used for expressing relational knowledge? a) Literal system b) Variable-based system c) Attribute-based system d) None of the mentioned

Description : Which method can’t be used for expressing relational knowledge? a) Literal system b) Variable-based system c) Attribute-based system d) None of the mentioned

Last Answer : c) Attribute-based system

____________ are algorithms that learn from their more complex environments (hence eco) to generalize, approximate and simplify solution logic. a) Fuzzy Relational DB b) Ecorithms c) Fuzzy Set d) None of the mentioned

Description : ____________ are algorithms that learn from their more complex environments (hence eco) to generalize, approximate and simplify solution logic. a) Fuzzy Relational DB b) Ecorithms c) Fuzzy Set d) None of the mentioned

Last Answer : c) Fuzzy Set

Like relational databases there does exists fuzzy relational databases. a) True b) False

Description : Like relational databases there does exists fuzzy relational databases. a) True b) False

Last Answer : a) True

Which agent enables the deliberation about the computational entities and actions? a) Hybrid b) Reflective c) Relational d) None of the mentioned

Description : Which agent enables the deliberation about the computational entities and actions? a) Hybrid b) Reflective c) Relational d) None of the mentioned

Last Answer : b) Reflective

Specify the agent architecture name that is used to capture all kinds of actions. a) Complex b) Relational c) Hybrid d) None of the mentioned

Description : Specify the agent architecture name that is used to capture all kinds of actions. a) Complex b) Relational c) Hybrid d) None of the mentioned

Last Answer : c) Hybrid

Which kind of agent architecture should an agent an use? a) Relaxed b) Logic c) Relational d) All of the mentioned

Description : Which kind of agent architecture should an agent an use? a) Relaxed b) Logic c) Relational d) All of the mentioned

Last Answer : d) All of the mentioned

Topological Maps referred as A : Relational maps B : Geomatric Maps C : Perceptul maps D : Sensorial maps

Description : Topological Maps referred as A : Relational maps B : Geomatric Maps C : Perceptul maps D : Sensorial maps

Last Answer : A : Relational maps

The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Description : The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Last Answer : D : Geomatric Maps

A clearly different group of maps showing particular application to robots is called as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Description : A clearly different group of maps showing particular application to robots is called as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Last Answer : C : Perceptul maps

The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Description : The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Last Answer : D : Geomatric Maps

A clearly different group of maps showing particular application to robots is called as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Description : A clearly different group of maps showing particular application to robots is called as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Last Answer : C : Perceptul maps

The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Description : The Signals which represent 2D & 3D odjects gathered from sensor data are referred as A : Relational maps B : Sensorial maps C : Perceptul maps D : Geomatric Maps

Last Answer : D : Geomatric Maps

<Condition>isa__ expression which will have value true or false. a. Relational b. Logical ce. Botha&b d. None of these

Description : isa__ expression which will have value true or false. a. Relational b. Logical ce. Botha&b d. None of these

Last Answer : ce. Botha&b

A relational database management (RDBM) package manages datain morethan one file at once. How does itorganizethese file? As A. tables B. relations C. tuple D. both (a)and (b) E. None of the above

Description : A relational database management (RDBM) package manages datain morethan one file at once. How does itorganizethese file? As A. tables B. relations C. tuple D. both (a)and (b) E. None of the above

Last Answer : both (a)and (b)

. A _____ DBMS distributesdata processing tasks between the workstation anda network server. A. Network B. Relational C. Client Server D. Hierarchical E. None of the above

Description : . A _____ DBMS distributesdata processing tasks between the workstation anda network server. A. Network B. Relational C. Client Server D. Hierarchical E. None of the above

Last Answer : Client Server

What advantage comes from trust between alliance partners? a) Trust enables partners to enter into detailed formal contracts. b) Trust makes partners more willing to share information. c) Trust increases relational risks. d) Trust causes partners to cheat on each other

Description : What advantage comes from trust between alliance partners? a) Trust enables partners to enter into detailed formal contracts. b) Trust makes partners more willing to share information. c) Trust increases relational risks. d) Trust causes partners to cheat on each other

Last Answer : Trust makes partners more willing to share information.

RDBMS means: a) Relational Data Base Management System b) Reliable Data Base Management System c) Relational Document Base Management System d) None of These

Description : RDBMS means: a) Relational Data Base Management System b) Reliable Data Base Management System c) Relational Document Base Management System d) None of These

Last Answer : a) Relational Data Base Management System

RDBMS means: a) Relational Data Base Management System b) Reliable Data Base Management System c) Relational Document Base Management System d) None of These

Description : RDBMS means: a) Relational Data Base Management System b) Reliable Data Base Management System c) Relational Document Base Management System d) None of These

Last Answer : a) Relational Data Base Management System

Which of the following describes a relational database? 1) It provides a relationship between integers 2) It consists of separate tables or related data 3) It retrieves data related to its queries 4) It provides a relationship between floats

Description : Which of the following describes a relational database? 1) It provides a relationship between integers 2) It consists of separate tables or related data 3) It retrieves data related to its queries 4) It provides a relationship between floats

Last Answer : 2) It consists of separate tables or related data

Which of the following genres does Hadoop produce? a) Distributed file system b) JAX-RS c) Java Message Service d) Relational Database Management System

Description : Which of the following genres does Hadoop produce? a) Distributed file system b) JAX-RS c) Java Message Service d) Relational Database Management System

Last Answer : Distributed file system

Which of the following allows you to create instances of the MySQL database to support your Web sites? a) Amazon Elastic Compute Cloud b) Amazon Simple Queue Service c) Amazon Relational Database Service d) Amazon Simple Storage System

Description : Which of the following allows you to create instances of the MySQL database to support your Web sites? a) Amazon Elastic Compute Cloud b) Amazon Simple Queue Service c) Amazon Relational Database Service d) Amazon Simple Storage System

Last Answer : Amazon Relational Database Service

Which of the following is an edge-storage or content-delivery system that caches data in different physical locations? a) Amazon Relational Database Service b) Amazon SimpleDBc) Amazon Cloudfront d) Amazon Associates Web Services

Description : Which of the following is an edge-storage or content-delivery system that caches data in different physical locations? a) Amazon Relational Database Service b) Amazon SimpleDB c) Amazon Cloudfront d) Amazon Associates Web Services

Last Answer : Amazon Cloudfront

Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud c) Enables support for outbound sockets using the language – specific, built in libraries. d) Lets developers factor large applications into logical components that can be share stateful services and communicate in secure fashion.

Description : Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully -managed web service that allows you to create , ... large applications into logical components that can be share stateful services and communicate in secure fashion.

Last Answer : A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud

n(log n) is referred to A. A measure of the desired maximal complexity of data mining algorithms B. A database containing volatile data used for the daily operation of an organization C. Relational database management system D. None of these

Description : n(log n) is referred to A. A measure of the desired maximal complexity of data mining algorithms B. A database containing volatile data used for the daily operation of an organization C. Relational database management system D. None of these

Last Answer : A. A measure of the desired maximal complexity of data mining algorithms

______ are algorithms that learn from their more complex environments (hence eco) to generalize, approximate and simplify solution logic. a) Fuzzy Relational DB b) Ecorithms c) Fuzzy Set d) None of the mentioned

Description : ______ are algorithms that learn from their more complex environments (hence eco) to generalize, approximate and simplify solution logic. a) Fuzzy Relational DB b) Ecorithms c) Fuzzy Set d) None of the mentioned

Last Answer : c) Fuzzy Set

Like relational databases there does exists fuzzy relational databases. a) True b) False

Description : Like relational databases there does exists fuzzy relational databases. a) True b) False

Last Answer : a) True

The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………A) Fields B) Records C) Relations D) Keys

Description : The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………A) Fields B) Records C) Relations D) Keys

Last Answer : C) Relations