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 - 2002-11-13 : 08:55:11
|
| Bart writes "Hi,I'm new to database design and I have a problem.I'm trying to create a database where an customer can create a dossier. This dossier can be of two types, a Education or a Counseling dossier. The customer can only create one dossier at a time and can only create one dossier of each type.The data that the customer has to fill in for each dossier-type is different.How do I create the database structure to do this?" |
|
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2002-11-13 : 16:03:11
|
| This is very high level but you should start by identifying what data will be the same between both types, create a table to hold this data. This record will be the parent record. Next, create two seperate tables, one for each dossier which will store the appropriate data. Have these child tables reference back to the parent table.You can use database constraints and business logic code to handle limiting only one child record per table per user/customer.Hope this gets you started. Good luck!Kyle HeonPixelMEDIA, Inc.Senior Application Programmer, MCPkheon@pixelmedia.com |
 |
|
|
|
|
|
Generalization Hierarchy