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 |
|
milan2003
Starting Member
1 Post |
 Posted - 2005-12-06 : 23:00:33
|
| Please help me on how to create the DB schema for this scenario,A customer may upload one or two files to the server.And I need to process all files(one or two) in one order.How to design the table so I know that there is one or two files that in one order.Help me please, I am not good in DB. |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2005-12-07 : 00:52:39
|
| well.. process means.. you need to read the data from that file and input into the database is this what are u talking about???then well depending upon the file format .. means and what data you are capturing from the file you can design you table.. format acordingly and see to it that you have primary key so that it will be easy to fetch the records...Read this link for the normalisation ..http://www.datamodel.org/NormalizationRules.htmlHope this helps.. Sucess Comes to those who Believe in Beauty of their Dream.. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-07 : 01:51:03
|
| You can create a varchar column to store the Physical path of the File and using File system object in Front End application you can show the data from itMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
need advice on DB schema