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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Normalize table

Author  Topic 

roshana
Starting Member

31 Posts

Posted - 2009-10-21 : 04:04:59
Hi All
I have one program which store data in the folder structure
just like windows folder structure

Folder name, folder description

I have file structure with the following details
Filename, file description, file size and file type
Could you please help me to create table in the normalized form so that I can retrieve all the data if I give a file name form the folder to the root node with all (1-M)(M-1) (M-M) Relation

Thanks
Roshana
   

- Advertisement -