Saturday, August 7, 2010

Unit 9 Data Modeling & database design; ERD

I believe I understand this material from a big picture overview but when I actually try to apply the ERD diagram to a real world situation, such as one that is presenting certain challenges at my new job, I find I am having a lot of trouble understanding how to set things up. Probably I am trying to take too many attributes and elements into account. But when I try to simplify things seem to become too abstract and I can no longer picture what the boxes on the page relate to and so I cannot effectively map the relationships. I think probably this is a unit that I would have been better off talking to someone about in person. Even seeing other ERD diagrams from classmates in the discussion area has not really helped me move forward with my own map. At issue is how and whether to include grade level and teacher ID into my ERD.
Since I want it to be an open website accessible to all----maybe those entities are not really needed (except as attributes of the other two entities?) and my diagram need only have two entities ---KITS and e-resources linked by a KIT ID as primary key---? Maybe that is complex enough for me at this moment in time.... Something I noticed this week trying to sprint through the rest of the course material is how my emotional reaction to a steep learning curve for technical aspects (such as essentially learning a new programming language) is as much of a stumbling block to me as my lack of time. Lack of time is certainly my main problem, but a time consuming emotional crisis sure doesnt help!
I wish I could be taking this course at a slower pace over a semester rather than the crucible of this summer crunch--- but also I am noticing how I get overwhelmed and discouraged much of the time which is as time consuming or sometimes more time consuming to recover from than an actual interruption in my study time. If only I could gain some control over these episodes of massive teary frustration and self doubt! Mostly they come up at critical points when I am utterly exhausted from the schedule (I mean my personal schedule of full time job, parenting and grad school) but if I could just muster through, machine-like without the cyclical overwhelm I'd be much better off---well at least as far as coursework is concerned. As to the ERD I am going to turn in the simplest diagram I can conceive of and hope the relationships are somewhat accurate.
I do understand the concept of data modeling, normalization and the need to diagram out relationships between information elements that will populate the database. I am just having trouble transferring a conceptual overview to the specifics of a reality based problem...