Sir, I am BCA final year student and I am developing a mini project i.e., church website so I need some help as listed below.
I want to create data base Tables for MemberDetails, Department and Designation.
MemberDetails fields:
ID
Name
Gender
DOB
Qualification
Phone Number
Address
Photo
Date of Joining
Date of Expiry
Department(Name of Dept. s/he is working)
DesignationID (as foreign key).
Designation
ID
DName
Type: Full/Part Time
Department
ID
Name
I am using VS Ultimate 2010
C# MVC 3 Razor.
Please help me to create these tables' database and link.