database relational-database

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…

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 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…

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. Still working on a web application as a school project, and it just seems to keep expanding. I have to add a layer for teachers so they can…

Hi everyone! Following is my database with 4 tables(Student, Course, Module, Instructor). And I wan to know whether this database is correct or not…

hi if i have a relation like that: 1 - 0..1 , it is considered a one-to-many? the only options that i have in mysql workbench are: 1:1, 1:n, n:n...…

I'm trying to understand if there are any standard best practice approaches for modelling number ranges in a Relational Database (In this case…

Hi, I am designing a database in Postgresql. I would like to know what are the pros and cons of using inheritance. I would also like to know the…

I have 3 MySQL tables for storing user details for a membership system. The tables are not directly related to each other, but are strictly related…

hi. 1-in mysql there is another way to relate tables without the foreign key?the relation parent-child or generalization only can be made by foreign…

When the staff change the information of product name, option name or prices. It should insert the data into history log and who done it. items…

I just want to know if it's safe to have two databases that are relational to one another, rather then the tables inside the database being…

Hi folks, Daft SQL question. I have a table like so ('pid' is auto-increment primary col) pid | cost | timestamp | rid…

Hi, I had a question about whether or not my implementation idea is easy to work with/write queries for. I currently have a database with multiple…

I know ruby (on rails) uses lots of "magic", but I use PHP, is there not a way of implementing the rails-like: class Player < ActiveRecord::Base…

Ok MySQL is the only option...I know there are better ways of accomplishing what I am asking with other DB platforms but that is not the nature of…

I am just learning how to implement the Nested Set Model but still have confusion with a certain aspect of it involving items that may be part of…

I've seen some of GUI tools for database query needs like aquadata studio(the old free version), pgadmin, squirelsql. Correct me if im wrong, but…

A lot of guys on this site state that: "Optimizing something for performance is the root of all evil". My problem now is that I have a lot of…