Question : While building a site I came across the following issue: I want to be able to have multiple […]
Category: Database Design
Database Design Table for forecasting
Question : I am designing a database to mainly share data regarding projects and their progress. Part of this is […]
Use a set database schema or EAV design? [duplicate]
Question : This question already has an answer here: To EAV or not to EAV? (1 answer) Closed 7 years […]
How to structure a database to show data for each USA State and Canada Territory on a Per user basis?
Question : I need to build a PHP/MySQL application. I am a bit confused on how to do the database […]
Insertion of data violates the foreign key constraint
Question : Consider I have two tables Employee and Department with the fields given below: Employee: Fname, Minit, Lname, Ssn […]
How to manage very large amount of data in mysql
Question : I have a table in MySQL in which I write logs of users in a specified format. It […]
Standard naming for a credential systems
Question : Is there a standard naming convention in regards to credential oriented systems? (Logins) The only one I could […]
Problem with compare value with its aggregate function within the same table
Question : I need to find the list of customer_id for customer who have spent more than the average customer. […]
Best db setup to accomplish yes/no list of clients for daily calls
Question : I will preface this by saying I am a relative novice to Access but I have managed to […]
How does one know when to stop normalizing?
Question : Alright, so basically I feel that I tend to over-normalize things, and maybe I am doing it at […]