?

Log in

No account? Create an account
current entries friends' entries archives about me Previous Previous Next Next
School, Class 2 - cellophane
the story of an invisible girl
renniekins
renniekins
School, Class 2
Database architecture... home stretch. Sunday I got my assignment in on time -- all 4500 words of it! If I'd double-spaced it (which I don't), I think it'd be 25 pages or so. Ick. But the guy essentially wanted us to write five (5!) papers, all pretending to be one assignment.

I wasn't fooled. But there wasn't anything I could do about it... other than grumpily keep writing. Mean grad school professors.

I keep hoping he'll grade it and send it back, but nothing yet. Tonight, however, I turned in my Course Project! Yay, and it's not even due until sunday!!

This earliness would be more impressive if I didn't still have a (monstrous and scary-looking) take-home final exam to finish this week and turn in on sunday, midnight, mountain standard time. Eek!

Anyway up there I said "tonight I turned in my course project", but it was only for loose definitions of the word "tonight". Because it was 4am. and now I'm exhausted, but also all riled up on adrenaline. I got on a good roll earlier this evening, and I decided to simply not stop. If I could just get the project out of the way, I could focus my attentions for the whole rest o the week on the final exam. So I just pushed on through, and everything put together, and emailed it off. It's done! Hopefully soon I'll relax down enough that I can sleep, at least for a couple of hours before work.

It was a interesting if big project. I had to start by picking an imaginary business problem to solve. Write up a problem statement, how software could help. and then identify 6 reports that were required to make the project a success.

Once I had a problem, I had to model it. Starting with an un-normalized DB, then take it through steps of normalization to 3NF. Dependency diagrams the whole way, then finally finish with a nice pretty Entity Relationship Diagram in crow's foot notation. Mine looked quite lovely.

After all that, I had to write a data dictionary. Then I had to write SQL DDL code to create the database I'd just modeled. Then of course the DML code to insert test data (at least 10 recs) into all the tables.

Then I got to write the reports, the ones I'd made up in my specs, against the test data. That was challenging, and it was fun seeing it work finally.

I thought I'd be done, but nooooo. He wanted some GUI specs too! Crazy. I wasn't clear on what that was for, and we didn't really do any front-end work in this database architecture class. I mocked up a couple of nice screens, so I did something... but I'm not sure if it was anything like he wanted.

Oh well, I put a ton of work into it, and I think most of it is excellent. I'm sure he'll like it as a whole. I hope!

Now I really have to try to sleep....

Tags:

read 9 comments | talk to me!
Comments
From: writerwench Date: June 28th, 2007 09:28 am (UTC) (Link)
Wow. That is all so totally alien to my knowledge base.
I'm awed that you can do all that stuff!
encorecrazay From: encorecrazay Date: June 28th, 2007 10:39 am (UTC) (Link)
Gee, just what I've been doing for the past 24 or so years.
renniekins From: renniekins Date: June 29th, 2007 03:41 pm (UTC) (Link)
I believe it. Although I imagine you don't have to be as precise in all your steps, since it's not for a "learning process" and a grade.
thatguychuck From: thatguychuck Date: June 28th, 2007 08:39 pm (UTC) (Link)
I turned in my Course Project! Yay, and it's not even due until sunday!!

AWESOME! Congratulations, Rennie. Not only are you a student, you're a dogonne SUCCESSFUL student! :)
renniekins From: renniekins Date: July 2nd, 2007 01:10 am (UTC) (Link)
(: Thanks! I was initially going to say "don't be impressed until I get my final exam turned in", but I just sent it in and it's only sunday at 9pm. That's 3 hours before midnight, and 5 hours before midnight MST! Wow, that's like forever in dog years. Not to mention abnormal for my procrastinating self.

Now I just hope he likes it. I'm frustrated because I haven't gotten my last two assignments graded yet, so I'm not even sure if what I've been doing is what he wants.

hopefully it is -- either way I'm done with this class!
jeffreyab From: jeffreyab Date: June 28th, 2007 10:24 pm (UTC) (Link)
U r smrt

I r dumb cuz that all went over my head.

Sounds like good work though.

I remember those early mornings finishing grad school papers.

Good times!
pstscrpt From: pstscrpt Date: June 29th, 2007 06:57 am (UTC) (Link)
Then I had to write SQL DDL code to create the database I'd just modeled.
See, I start with the DDL and then tell Visio to go connect to the database and make a picture of it for me.
renniekins From: renniekins Date: June 29th, 2007 03:39 pm (UTC) (Link)
that's handy. (: I wonder if that would work through my proxy here at work?

Although it would feel vaguely cheatingish, at least for school. Perhaps not, the important thing is getting the relationship working, not the pictures.

Actually I was really hoping to do it the opposite way, get visio to give me the SQL for all the nice diagrams I'd made. but i couldn't convince it.
pstscrpt From: pstscrpt Date: June 29th, 2007 11:22 pm (UTC) (Link)
I'm curious, are they saying anything about the use of identity columns (sequences in Oracle) vs. meaningful keys?
read 9 comments | talk to me!