DataBase design used for Photo Gallary

  • We have used SQL Server 2008 as our Database.
  • We are using DBML (Database Markup Language) file and Linq to SQL as ORM (Object Relational Mapping).
  • We have created the database first, then created objects in DBML file from Database.

LoginDetails : This table holds the details of the user. The RegisterId primary key column is referenced in Album and Images tables.

Album : This table holds the album information. The table has UserId as foreign key which tracks album associated to particular user. The album's AlbumId is referenced in Images table.

Images : This table holds the images. The table has UserId and AlbumId as foreign key.

Thus we have seen a simple Database design for our Photo Gallary application.


Post a Comment