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.
0 comments:
Post a Comment