Hello,
I am working on a web site which will use SQL 2005.
I am planing my first SQL database and I am looking for advice.
1. There will be two types of users: students and professors.
2. Both users types will have login information.
(Username, Password, AccessLevel)
3. The remaining information on students and professores is different.
Student (Name, Email, Phone, ...) / Professor (Name, Email, Phone,
Subjects, ...)
4. Professors can publish documents.
Each document has some info (Type, Title, Description, ...)
My plan in this moment is to:
A. Create the tables Students, Professors, Login and Documents.
B. Students table would be connected to Login table.
Professors table would be connected to Login table and Documents
table.
C. The field [Type] in documents table should include the type or
should I create a table DocumentsTypes where I add codes for each
type.
I have seen this. What is the advantage?
Can someone give me some advice?
Thank you Very Much,
MiguelYou should be using ASP.NET 2.0 as it now supports SQL providers for
Membership, Roles, and Profiles. Most of it is all automated and you won't
have to worry about the design in the context you are discussing at the
moment.
<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/
"Miguel Dias Moura" <md*REMOVE*moura@.gmail*NOSPAM*.com> wrote in message
news:ODVd5NmAGHA.204@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I am working on a web site which will use SQL 2005.
> I am planing my first SQL database and I am looking for advice.
> 1. There will be two types of users: students and professors.
> 2. Both users types will have login information.
> (Username, Password, AccessLevel)
> 3. The remaining information on students and professores is different.
> Student (Name, Email, Phone, ...) / Professor (Name, Email, Phone,
> Subjects, ...)
> 4. Professors can publish documents.
> Each document has some info (Type, Title, Description, ...)
>
> My plan in this moment is to:
> A. Create the tables Students, Professors, Login and Documents.
> B. Students table would be connected to Login table.
> Professors table would be connected to Login table and Documents table.
> C. The field [Type] in documents table should include the type or
> should I create a table DocumentsTypes where I add codes for each type.
> I have seen this. What is the advantage?
> Can someone give me some advice?
> Thank you Very Much,
> Miguel
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment