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.

What is canonical cover, closure and extraneous attribute?

I'm studying database concepts and there are 3 concepts that I don't understand: canonical cover, extraneous attribute and closure. I read …

database-design relational-database database-schema functional-dependencies canonical-form
disk I/O error with SQLite3 in Python 3 when writing to a database

i am a student just starting out with python, and i was tasked with creating a relational database management system. …

python sqlite relational-database disk-io
Natural join if no common attributes

What will natural join return in relational algebra if tables don't have attributes with same names? Will it be null …

relational-database relational-algebra
Database design - Multiple "Contact information" for different tables

I have a database with tables "person", "company", "shop", etc. Many of these tables must have "contact information". The possibility …

database database-design relational-database contacts
Is it OK to name a MySQL index the same as the column it indexes?

Is it considered bad form to give an index the same name as the column it is based on? Like …

mysql relational-database indexing
Pizza & Food - database design

I want to create a website that allow customer to order food from the website. There are two food type: …

mysql sql database database-design relational-database
Database Structure involving dynamic fields

Im working on a project. Its mostly for learning purposes, i find actually trying a complicated project is the best …

mysql database-design relational-database database-schema entity-attribute-value
Why would I want to use a non-relational database?

The latest craze in databases seems to be centered around non-relational databases. Why? It seems kind of counterproductive. For example, …

database relational-database non-relational-database
Searching by related fields in django admin

I've been looking at the docs for search_fields in django admin in the attempt to allow searching of related …

python django relational-database
Why are key value pair noSQL db's faster than traditional relational DBs

It has been recommended to me that I investigate Key/Value pair data systems to replace a relational database I …

nosql relational-database key-value-store