51 reputation
14
bio website
location
age
visits member for 2 years, 5 months
seen Nov 23 '12 at 1:53

Oct
11
awarded  Notable Question
Dec
5
awarded  Popular Question
Oct
22
accepted unenforced constraints/possible duplication in my database design?
Oct
22
comment unenforced constraints/possible duplication in my database design?
You're not going to like this Joel, but topics can belong to multiple subjects haha. Nevermind though, I understand your approach and I'm pretty sure I can make it work. Thank you very much for your help! :)
Oct
21
comment unenforced constraints/possible duplication in my database design?
Yes, although it may seem strange, there is a constraint a teacher can only teach one topic and subject for my particular model. I have a question about your suggestion if I may. What If I wanted to add a lecturer to the system and would like to note that they teach the topic 'fractions' in the subject 'math'. It seems like I would be powerless to do this until he was assigned to a lesson
Oct
21
revised unenforced constraints/possible duplication in my database design?
added 45 characters in body
Oct
21
asked unenforced constraints/possible duplication in my database design?
Sep
30
comment Database schema - performance v correctness information
Thank you for the great answer. To clarify, a question can have multiple topics and a user can answer the same question more than once. I do plan on checking if the user has answered the question previously before adding a new row to the table
Sep
30
accepted Database schema - performance v correctness information
Sep
30
asked Database schema - performance v correctness information
Sep
5
accepted database schema design for school system
Aug
6
revised database schema design for school system
added 313 characters in body
Aug
6
comment database schema design for school system
Thanks for the great answer. I'm wondering if I referenced department in, say, the classes table, wouldn't it make the following type of query more difficult: 'select all teachers who work in a particular department' or is it a trade off between database design and the length/difficulty of some of the queries
Aug
6
asked database schema design for school system
Jul
3
comment creating a database scheme for storing information about an item, which option is better?
Thanks for the help dezso, appreciated!
Jul
3
accepted creating a database scheme for storing information about an item, which option is better?
Jul
3
revised creating a database scheme for storing information about an item, which option is better?
added 76 characters in body
Jul
3
comment creating a database scheme for storing information about an item, which option is better?
What if I instead moved the color_name to the item_TypeColor_Assn table
Jul
3
comment creating a database scheme for storing information about an item, which option is better?
Thanks for the detailed answer. One question I have is what would happen in the following situation. Let's say two types have the same color, yellow. What If I later decided that I wanted to change the color of a type from yellow to dark yellow? It seems like it might be rather tricky
Jul
2
awarded  Editor