The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
284 views

Configuration options for relational algebra evaluator “ra.jar”

I am participating in the Stanford Database Class, and there are some problem sets to be solved in "mathy" relational algebra syntax. The course instructors demand from students to use this ...
1
vote
0answers
30 views

In terms of relational databases is a Relvar the equivalent to a Schema?

I've been reading up on relational databases and the term Relvar and schema keeps coming up. From my understanding: A relvar is a variable holding a relation. A schema is a logical definition of a ...
1
vote
0answers
33 views

Keys of a relation

I got relation: R = { (ABCDEF) , (A B F -> C, B C -> F, F -> A, F -> B, D E -> E, E -> D)} keys of this relation are: {BCE}, {EF} But i dont get it... why? Why not only {EF}.. it got less ...
1
vote
0answers
318 views

Closure of attributes definition clarification

A databases book I am using states [1]: The closure of {A1, A2, ..., An} under the FD's in S is the set of attributes B such that every relation that satisfies all the FD's in set S also satisfies ...
0
votes
0answers
10 views

Translating duplicated data entries into Domain Relational Calculus

Given a following table named BOOKING, which contains three columns, guest_name, room_number and booking_date, how do I find the all the guest_name that have the same room_number and booking_date? I ...
0
votes
0answers
12 views

Is there a standard direction to read cardinality relationships in?

I'm reading some documentation, and before getting egg on my face for questioning it, I'd like to check the standard way of reading UML cardinality relationships. The docs I have look like the image ...
0
votes
0answers
12 views

expressing constraints in relational algebra

I need to express this constrain in relational algebra: I have some table with one column with all possible values: ALL_VAL and table with some values from ALL_VAL that not mach some rule: ...
0
votes
0answers
90 views

MySQL Associative Weak Entity

I'm working on a project in MySQL that has a table of users who have favorite foods. Favorites is an associative entity between Users and Foods. I want the Favorites table to be a week entity of the ...