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.
| Author |
Topic |
|
jrockfl
Posting Yak Master
223 Posts |
 Posted - 2005-03-11 : 23:52:00
|
| I have started to work on a "mock" intranet application with SQL Server and ASP.NETCan you look at my design and tell me if this looks good or needs work? Also, am I breaking this up into too many tables?[url]http://rockenbach.net/database.gif[/url] |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-12 : 00:27:45
|
| Two tables have no PKI don't think OI_Users -> OU_UserProperties should be one:many, it should be one:one shouldn't it?I presume that users have multiple Roles?What does the OI_Roles.Role do? I'd expect to see a WebPages table that had a Role in it, or somesuch.What is OI_Users.ActiveWebPage? Is that going to be updated every page view? If so I'd move that to a table separate from the User's LoginID/Password - possibly even a Log table that recorded ALL the pages they viewed (then you will need a purging routine to clear the old log entries)Don't mix CamelCaps ("FirstName") and underscores ("Slspn_No")Style is a personal preference thing, and generally my only requirement is "Be consistent", but one thing I would object to is using plurals in table names.I don't "get" what OI_UserWebPage is going to be used forKristen |
 |
|
|
|
|
|
Review my design