the one and only truly amazing katster (katster) wrote,
the one and only truly amazing katster


First of all, I’m on swine flu watch, as one of my groupmates was pretty seriously ill yesterday, and my teacher forced her to stay in class until the midway point while he lectured (when he had first told us we had a quiz and the presentations and then she could go) and then we all shared a mic in giving our presentation. I’m hoping that she didn’t have the flu and thus, I won’t get it, but…this year, you can’t be too careful.

Anyway, if you didn’t catch my edit yesterday, this is what you missed:

So the quiz got postponed. However, our presentation didn’t go overly well today. The Star1/Star2 problem we were having I pointed out in discussions, but our main programmer couldn’t talk Access into doing what we wanted. We were fairly dinged on that one, but it was an Access toy database problem. But here’s a big hint to professors: when you require 3-5 tables in the assignment, it’s not fair to chew us out for including 3-5 tables when we could have done it in one.

To explain, here’s our Entity Relationship diagram in our presentation:
Our project ER diagram

(You can click on that to make it bigger.)

Here’s how the prof said we could (and should!) have done it.

id name married to?
1 John 3
2 Jeff 5
3 Jill 1
4 Jim 6
5 Jacob 2
6 Jean 4

Besides the fact that this table assumes poly relationships aren’t acceptable (which, of course, in the US is true, but not in other places in the world), I’m not sure how you’d handle marriage dates, as obviously John and Jill would share a marriage date. And since our assignment said not to track divorces, I guess if John and Jill got a divorce, then we remove both their entries from the table. But what happens if Jill meets Johann and he sweeps her off her feet and they get married? Would I need to re-enter Jill at that time? Wouldn’t it be easier if her record already exists?

And that’s still not excluding the fact that the prof told us to use 3-5 tables in the assignment. I was pretty sure we could do marriage in two tables, but that still didn’t meet the three to five requirement. And as for the poly thing, he said we could make our own assumptions when I went up there and asked about things like gay marriage. So we made an assumption that poly was okay. Grr. And interrupting the flow of our presentation by asking us questions in the middle of it? *sigh* I dunno, I guess it’s a teaching style, but it seemed a little rude.

Grr. yeah. This is still eating me today, but i’ll try to drop it.

Originally published at You can comment here or there.

Tags: uncategorized

  • you don't need to say a word

    “Preach the Gospel at all times. When necessary, use words." --attributed to St. Francis of Assisi The other day, Fred Clark of slacktivist put…

  • (no subject)

    It's my birthday. I was going to write something, but it doesn't want to come out. Maybe tomorrow. This entry was originally posted at…

  • very picky vampires

    For those who weren't aware, my mother has leukemia. Again. She went through two bouts of leukemia in 2001 and 2004, the latter ending in a stem cell…

  • Post a new comment


    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.