network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 10 months |
| seen | Nov 23 '12 at 1:53 | |
| stats | profile views | 6 |
|
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 |
|
Jul 2 |
revised |
creating a database scheme for storing information about an item, which option is better? added 103 characters in body |
|
Jul 2 |
awarded | Student |
