David Beroff (d4b) wrote,
David Beroff
d4b

Starting the Entity-Relationship Diagram

I'm starting to play with http://LucidChart.com to create an entity-relationship diagram for AboutTh.is. I also figured it was time to learn a bit of formalism as far as how to use Crow's Foot notation. (My hazy memory of the one undergrad Database class that was available at Rutgers somewhere around '82 or '83 is that there was far more focus on how data was physically stored on disks, {yawn}, and a lot less high-level theory; I'm not even sure that SQL was anything more than science-fiction at that time.)

I'm a very visual type of person; it really helps me to nail down ideas when I can see them in front of me.

I also know that a lot of key decisions made at this point will affect future events. For example, one (minor) frustration I have with YouTube is that, other than with the annotations, you can't edit your videos. So, you might develop lots of inbound links and embeds to a particular video, and if you need to make a change in the future, you're pretty much out of luck. Sure, you can delete and re-upload, but then you lose your view count, search engine position, inbound traffic, and so on. So, even though an Opinion will only have one Audio at any given time, I'll allow them to be replaced (and possibly restored?).

I'm not going to post the whole thing publicly, but let me know if you want to get a private copy as it develops.
Tags: marketing, mtat, video creation, webdev
Subscribe
  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 0 comments