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.

set null value in a foreign key column?

I have this table CREATE TABLE [dbo].[CityMaster]( [CityID] [int] NOT NULL, [City] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_…

sql-server foreign-keys relational-database constraints relationship
When shouldn't you use a relational database?

Apart from the google/bigtable scenario, when shouldn't you use a relational database? Why not, and what should you use? (…

sql database nosql relational-database
Insert multiple rows in one table based on number in another table

I am creating a database for the first time using Postgres 9.3 on MacOSX. Let's say I have table A and …

sql postgresql relational-database generate-series
(Database Design - products attributes): What is better option for product attribute database design?

I new in database design. What is better option for product attribute database design for cms?(Please suggest other options …

relational-database entity-attribute-value database-design
Left join in influx DB

I am new to influx DB. Now I need to migrate MySQL db into influxDB. I chose influx DB because …

database join relational-database left-join influxdb
Triple Stores vs Relational Databases

I was wondering what are the advantages of using Triple Stores over a relational database?

relational-database sparql semantic-web jena
Most elegant approach for writing JSON data to a relational database using Django Models?

I have a typical Relational Database model laid out in Django where a typical model contains some ForeignKeys, some ManyToManyFields, …

python django json django-models relational-database
designing database to hold different metadata information

So I am trying to design a database that will allow me to connect one product with multiple categories. This …

database-design database relational-database
Clear explanation of the "theta join" in relational algebra?

I'm looking for a clear, basic explanation of the concept of theta join in relational algebra and perhaps an example (…

sql relational-database cartesian-product relational-algebra
SQLite many-to-many relationship?

I'm trying to set up a SQLite3 database with foos and bars and a many-to-many relation between them. This is …

sqlite many-to-many relational-database