Top "Relational-database" questions

A relational database is a database consisting of relation variables (which are also called *relvars*, *R-tables* or just *tables*). The definition, manipulation and integrity rules of relational databases are based on relational operations equivalent to or similar to the Relational Algebra and Calculus.

Do stored procedures run in database transaction in Postgres?

If a stored procedure fails in middle, are changes at that point from the beginning of SP rolled back implicitly …

database postgresql stored-procedures transactions relational-database
Identifying Functional Dependencies II

I was getting a little confused with the last post so I found a nice example which should clear things …

database database-design relational-database functional-dependencies
Serializiation with Protocol Buffers in a Schemaless Database

We're using MySQL to store schemaless data (see: Using a Relational Database for Schemaless Data for the solution inspired by …

mysql nosql relational-database protocol-buffers schemaless
What's the point of a candidate key?

I'm fairly new to database management and this question never seems to be answered in more than one sentence. All …

database database-design entity-relationship relational-database
Database BCNF Violations

I am confused about a particular aspect of DB BCNF violation criteria. Here's an example: R(ABCDEF) The FDs are …

relational-database bcnf
how much data can a 5MB SQL database store?

I'm interested in using Heroku for my project. I'm not interested in paying for it at the moment but the …

database database-design hosting heroku relational-database
MySQL Double Entry Accounting System Database Design?

i am going to create a database for double-entry accounting system in MySQL. i recently read the article: http://homepages.…

mysql database-design relational-database accounting
Mapping a ternary relationship to the relational model (Employes, Customer, Project)

I would like to convert this segment of an ER-Diagram to a relational model. We have a ternary relationship and …

database database-design relational-database entity-relationship cardinality
Why Projection Operator in relational algebra eliminates duplicates?

What are the consequences of eliminating duplicates in Projection Operator?And yes, why there is no duplicate elimination in real …

sql select relational-database projection relation
Relational vs Non-Relational Data Modeling - what's the difference

I'm new to databases and I've never worked with any RDBMS. However I get the basic idea of relational databases. …

google-app-engine data-modeling relational-database non-relational-database