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.

Comparison of Relational Databases and Graph Databases

Can someone explain to me the advantages and disadvantages for a relation database such as MySQL compared to a graph …

sql relational-database graph-databases
Composite Primary Keys : is it good or bad

I've been designing a database for an online store system. The question that I've come across by reading some posts …

sql database database-design relational-database
How to design a product table for many kinds of product where each product has many parameters

I do not have much experience in table design. My goal is to create one or more product tables that …

database-design relational-database database-schema
Pros/cons of document-based databases vs. relational databases

I've been trying to see if I can accomplish some requirements with a document based database, in this case CouchDB. …

database nosql couchdb relational-database document-database
Database design: 3 types of users, separate or one table?

I have 3 types of users: Admins Suppliers Employees Each user type will have different user interface and access different types …

mysql database database-design user-interface relational-database
Practical example for each type of database (real cases)

There are several types of database for different purposes, however normally MySQL is used to everything, because is the most …

database nosql relational-database
Query the contents of stored procedures on SQL Server

I am exploring a legacy database system and have very little knowledge of its internals. I would like to find …

sql-server sql-server-2005 tsql relational-database
Using a Single Row configuration table in SQL Server database. Bad idea?

In developing a shopping cart application I've found that I needed to save settings and configurations based on the administrator's …

sql database-design configuration relational-database
What are the known ways to store a tree structure in a relational DB?

There is the "put a FK to your parent" method, i.e. each records points to it's parent. Which is …

mysql design-patterns tree relational-database
When to use MongoDB

I'm writing an application that doesn't necessarily need scaling abilities as it won't be collecting large amounts data at the …

mysql mongodb database-design relational-database database