Ask a Question related to Dreamweaver AppDev, Design and Development.
-
darrel #1
DB design...multiple tables for ancillary data or just one?
I am working on a mini-DB app for people to upload documents and have the
information stored in a DB table. Many of the criteria they need to enter
for each form will be pulled from another table (so that the criteria,
themselves, can be edited as well).
For instance, for each document uploaded, they need to select a LANGUAGE and
a DISTRICT attribute.
I could build a separate table for both LANGUAGE and DISTRICT, or I could
just build one other table that would store all of these 'extra' variables
as such:
variableType variableID variableeName
language 1 english
language 2 spanish
district 3 first
district 4 second
Is there SOP for this? It makes sense to properly name each table and keep
them unique to the type of data, but the issue is we now have 20+ tables
floating around for the bigger app we have, and there's a bit of an argument
for reducing those tabls.
I'm guessing there is no right/wrong answer here but thought I'd get the
opinion of others on the subject.
-Darrel
darrel Guest
-
Multiple tables for same data - how to sort
Hi We are developing an application that stores logging data in a mysql database. Due to some facts, we decided to store the loggingdata in a... -
Advanced OOP: Best OO design for rendering multiple page types to multiple devices
Hoping to get some ideas from more experienced hands regarding the best way to use object-oriented design to assist my development of a content... -
update multiple records in multiple tables from one form
hello I have been trying to run multiple update queries based on the data entered by user. Brief background: I am fetching data from various... -
Can one <form> submit data to multiple tables?
Am I able to use a single form to write data to multiple tables in my database using php/mySQL? -
Creating tables and merging them for multiple data
Hi everyone, please i need your help in providing a quick and detailed code on how to create table using sql language. i also need to know how to...



Reply With Quote

