How do relational databases work mathematically?

Mathematics

2 answers:

Ivanshal [37]3 years ago

7 0

Answer:

Well, I guess in a formal sense you could call relational algebra a type of logic, which puts it into the realm of ‘math’, though I don’t think most mathematicians would look at it as being a very significant area, more ‘applied logic’ than anything else.

That being said, relational algebra DOES present some formalisms in the shape of relations, tuples, normalizations, and denormalization, etc. There is also a model of sequential operations and thus the underpinnings of the ACID database concept.

Since the overwhelming primary use of RA has been as a way to structure our ideas about SQL RDBMSes there isn’t really a lot of deep theory there. I don’t think anyone has really built any other models of RA beyond an RDBMS. There have been limited non-SQL RDBMS implementations, but AFAIK none of them are really actively maintained today.

Dmitrij [34]3 years ago

3 0

Answer:

A relational database stores data in a series of tables so that the data models a mathematical theory of relations. The model allows for queries based on projection, selection, and join, among other operations, and connects the data in the tables by way of keys.

You might be interested in

An alligator population in a naturer preserve in the Everglades increased by 60 alligators or five years what is the mean yearly

adelina 88 [10]

I'm not sure what you meant after alligators, if it was or or for, but I think it was for so I'm going with that. If 60 increase every 5 years, it would be 60 over 5 (in fractions). So I would do 60 divided by 5, which would be 12. So that means 12 increase every year. I'm not sure what mean meant either, if you're talking about the mathematical mean, but you can't solve the mean in this problem. The Answer: The yearly change in the alligator population would be 12.

7 0

3 years ago

Suppose that a survey was taken of 320 people and each person was asked if they approved or disapproved of the president's actio

wolverine [178]

Answer: I believe it’s C

Step-by-step explanation: I hope i’m right

6 0

3 years ago

In science class, the girl to boy ratio is 3 to 7. If there are 50 students in the class, how many are boys

Julli [10]

Answer:

there are 35 boys in the class

Step-by-step explanation:

love the anime character!

3 0

3 years ago

Read 2 more answers

A student is asked to find the length of the hypotenuse of a right triangle. The length of one leg is 36 centimeters, and the l

DochEvi [55]

Answer:

45.6 cm

Step-by-step explanation:

Let X be the hypotenuse.

(36)^2 + (28)^2 = X^2

X = 45.6 cm

3 0

2 years ago

A house is 46.0 ft long and 50 ft wide, and has 8.0-ft-high ceilings. what is the volume of the interior of the house in cubic m

I am Lyosha [343]

Volume of house = 46*50*8=18400 ft^3
Each foot equals 0.3048 m. (exactly).
Therefore 1 ft^3 = 0.3048^3 m^3
Therefore volume of the interior of the house
= 18400 ft^3 * .3048^3 m^3/ft^3
=18400*.3048^3 m^3
=521.0299772928 m^3
=521 m^3 (nearest m^3) ................(a)
or, in cubic centimeters
=521 m^3 * (100cm/m)^3
=521.0299772928 * 100^3 cm^3
=521029977.2928 cm^3
=521029977 cm^3 (nearest cm^3) .........(b)

Answer: see (a) and (b).

4 0

3 years ago