database database-design

In order to improve insert performance and load on server, I've decided to divide a large table into 2. A big table which will only be used for…

I have millions of songs, each song has its unique Song ID. Corresponding to each Song ID I have some attributes like song name, artist name, album…

I am trying to understand the concept of document storage and fail to see how it would apply to some situations. For example, in the case of a…

We are providing document upload on different things like tasks, feeds, comments etc.. And there are lots different permission on documents for…

I need to build something similar to a dating site. Each account can have 1 or more "profiles". Each profile might have certain attributes, like…

I have two databases: 1) accounts-management 2) games-management I want to make reports, which use data from both databases and i want to have third…

Just looking for what people see as the main differences when choosing between the two. Thanks.

I dont know what type of Audit logging system do I need for my tables design. Sometime staff change the name of the product, price, options or…

I am trying to come up with a database design to hold the "Top 10" results for some calculations that are being done. Basically, when all is said in…

An invoice can contain 1 or more orders, how to archive this? Example of Invoice: OrderID | Order Date | Amount 31 10/02/2011 £1.50 43 12/02/2011…

Which is better 100 tables with 10,000 rows or 1,000 tables with 1,000 rows? The above question is just a base.Its not completed without the…

If I have users, as well as user groups (like a local astronomy group/club), and I want both to have a one to many relationship with street…

I have a MySql table which consists of: ~25million rows (CURRENTLY) 3 indexes Each day, a crawler adds ~3million rows I'm currently not looking too…

if i have this table: users ----- id_users (pk) age name gender salary it is needed for each of these values an option to set visible or not in user…

I'm new in MySQL Workbench. I'm planning to create a new database called "Customers". But the problem is I don't know how to create it. I already…

User is assigned to a group ID. There are multiple login area, eg: frontend, backend and the control panel login. I am wondering should I keep…

Is it possible to do a query like the following? I would like to do this in place of a stored procedure if possible. for example, with two tables…

We are using the Class per Table model for making persistence of a heritage class model ( detailed information here ) in MySQL. Which of these…

Primary key in relational tables. Composite primary key or unique primary key in those pure relational tables? Which design would you recommend to…

We are at the begining of a new project, and we are really wondering if we should use stored procedures in MySQL or not. We would use the stored…