relational-database

I have a bunch of products with a bunch of different possible attributes for each product. E.g. Product A has a name, size, color, shape. Product B…

I work in the promotional products industry. We sell pretty much anything that you can print, embroider, engrave, or any other method to customize.…

I have created this database schema and with help from several users on here, I have a database which takes user submitted business entries stored…

I am considering designing a relational DB schema for a DB that never actually deletes anything (sets a deleted flag or something). 1) What metadata…

I know i'll get flamed for this as the topic is covered numerous times in other questions but I just cannot get my head around it or really…

Suppose that we have 3 related table in this manner in MySQL: Table 1: Table 2: Table 3: ------------- ------------- ------------- UserID |…

Consider these two tables stored in a MySQL database. The first stores a list of movies and the second stores metadata about each movie. Rather than…

We are overhauling our product by completely moving from Microsoft-.Net family to open source (well one of the reasons is cost cutting and…

I have an app that will allow an admin to upload an article and share it with many users to edit it. The article is then broken down into sentences…

I have a DB structured like this: CATEGORIES > SUBCATEGORIES > PRODUCTS In just want show the categories which have an number of products…

A google search has not revealed a lot of info on the subject (At least nothing DB-newbie friendly/Not too cryptic); just want to know how O:M…

I have 2 tables. 1st,cardb ID,car,engine,gear 2nd,labels ID,label,value what i need to do is, say for this record cardb:1,punto,3500cc,auto if i…

-Goal- I would like to fetch users who do not have an entry within the 'bar' table. These users will also belong to a certain 'usergroup' and have…

Hopefully the purpose of these tables will be apparent, but just in case here's a simple explanation: I basically wish to store the results of…

I'm trying to write query to a MYSQL database that queries for products that have a relationship with all selected categories Products table…

I have a very small MySQL Database where the main table is about 300 records and I do add more occasionally. The table stores locations to files and…

Not sure if this is possible (or worthwhile to do) in pure SQL, but I'll ask anyway. Let's say I have a bunch of numbered records in my database…

Hi all, I am trying to grasp some performance differences between Cassandra and relational databases. From what I have read, Cassandra's write…

Say, at the beginning of a project, I want to store a collection of Companies, and within each company, a collection of Employees. Since I'm using a…

I have a mysql database containing tables like User, playlist, videos, tags . Based on this I would like to collect the user activity on the…