network profile
| bio | website | google.com |
|---|---|---|
| location | Littleton, CO | |
| age | 23 | |
| visits | member for | 9 months |
| seen | May 1 at 0:07 | |
| stats | profile views | 3 |
I'm a derp who derps with herps in hopes that the herp does all the derping I want it to.
|
Oct 17 |
awarded | Custodian |
|
Oct 17 |
reviewed | Approve suggested edit on How can I make my database more concise? |
|
Jul 24 |
revised |
How can I make my database more concise? added 160 characters in body |
|
Jul 24 |
awarded | Scholar |
|
Jul 24 |
accepted | How can I make my database more concise? |
|
Jul 24 |
comment |
How can I make my database more concise? I have considered moving Barcode to publication. The more I think about it, the more it makes sense to be in there. A Barcode is not guaranteed to be unique. Someone could have multiple instances of an asset. Where would we be if (s/h/it) wanted to keep track of each? Then again, I could have a field in the Asset table for quantity. Thanks again. |
|
Jul 24 |
awarded | Supporter |
|
Jul 24 |
comment |
How can I make my database more concise? Thank you for the lengthy and complete answer. I acutally had just done most of that right before your answer posted. After the comments and consulting the hierarchical wiki again, it seemed like the best and most logical idea. I, however, did not think of adding the asset_type. That also makes an abundant amount of sense. |
|
Jul 24 |
comment |
How can I make my database more concise? @JonSeigel I just read the wiki on Hierarchical Databases. Is my design not following that idea? |
|
Jul 24 |
comment |
How can I make my database more concise? @JNK Yes? Forgive my ignorance, but I'm not sure on the terminology for databases. To me Asset, Barcode and Publication would be property object to a parent object (book, music etc...) If you are asking why they are separated as they are, that is for situations just like Vehicle. I separated them for extensibility of the database. I won't know what asset type needs which tables until I get to that asset type. For instance, suppose someone wanted a furniture table. Furniture isn't a publication or a barcode. |
|
Jul 24 |
awarded | Editor |
|
Jul 24 |
comment |
How can I make my database more concise? @JNK, Ok. So this much fragmentation is a good thing. What would be an extraordinary situation? |
|
Jul 24 |
revised |
How can I make my database more concise? Added new design |
|
Jul 24 |
awarded | Autobiographer |
|
Jul 24 |
awarded | Student |
|
Jul 24 |
asked | How can I make my database more concise? |
