Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-08 : 08:34:58
|
| Rocky D Souza writes "I am in the process of designing a database that used in web application. One of the requirement is the client has multiple forms like "Packaging Development Form, Commerical Expense Sheet, Marketing Expense Agreement, customer Profile , etc" I have designed to store each form data into a separate table. But when I presented this to a Design review team they come to idea that instead of having each table for each form , why can't have single table and create views. According to them create the common table and name column has A-Z , but to me it is totally wrong concept of designing database as there no common column with in forms.Would you able to suggest which is best way to do this ?, is it go for single table with A-Z column names and create views or with separate table with more meaning column names?Your inputs will be appreciated." |
|
|
|
|
|
Database Design