ER Diagram in 1NF - SQL Server Forums

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

ER Diagram in 1NF

Author

Topic

anishap
Yak Posting Veteran

61 Posts

Posted - 2008-06-30 : 11:12:47

Hello,

I want to create an ER diagram in INF for the below data:

Filename
Photographer name
File size
Date
Image width
Image height
Photographer e-mail
Photographer company
Location
Camera model used

Can anyone help me to create an ER diagram in First Normal Form?

Below is what I tried?

Photograher: Name, email,company, ID
|
|
|
M (Many)
Image: ID, width,height,date,location,filename
M
|
|
M
Camera: ID, Model

Kindly let me know

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources