Iteration 4: DBMS Physical ERD, normalization, tables, indexes.


This assignment is a little different from the last as it is a project that I have been working on but that I need a little help with getting over the hump. I am trying to build an auditing database. Think of it as a way that a program like splunk would take in data and utilize its database to send out alerts to the proper admins. I have attached my other iterations to show what my spirit and intent is with this assignment. If you have any questions please let me know.

My ERD is pretty messed up and I am not sure where to go from here, hopefully you can help once you understand what it is I am trying to do. the Account Events table is supposed to be rounded edges to show that its a associative entity. I used visio but it wouldn’t load so I just took a screen shot. LMK if you just want me to email you the visio.

I also attached the iteration 4 instructions in the full version that I got from class and a boiled down version of my own to try and simply it.