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 |
|
Reinder Jan
Starting Member
2 Posts |
 Posted - 2007-12-12 : 07:36:13
|
I am making a PhotoAlbum Using a Sql server 2005 Database.With multiple Albums and Photo's can be in multiple Albums.Every Photo has its own description.And there have to be a table fore Photographer Information.So the same Photo can be in more then 1 Album and there can be more then 1 Photographer in 1 Album!Can someone help me whit the database tables your help would be well appreciated! (A sample fore this issue would ben nice)My email is reinderjan15@hotmail.com |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-12 : 07:44:43
|
http://www.datamodel.org/NormalizationRules.html
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Reinder Jan
Starting Member
2 Posts |
Posted - 2007-12-12 : 08:23:08
|
| I just started using sql! I used filesystem oject in vb to store the Photo's!I want a database so i am trying to build a sql database i know how to querie but have no idea fore a logical table structure!Can u make a Sample fore this PhotoAlbum? I Would realy appreciate! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-12 : 08:53:45
|
Then this is the perfect opportunity to learn the correct way to build a database application!
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Tables fore a PhotoAlbum