Browse By

Category Archives: NEU MSCS

No Thumbnail

How SQL Index Affects Query Speed Performance

Ok, so maybe I’m done with the Database Management course, but that doesn’t mean that I’m done playing around with the database. This is just some easy to follow guide how to see the difference that an index made in a real database system using

No Thumbnail

How to Find Candidate Key(s)

As my final exam on Database Management Course closely approaching, I think I’m a bit forced (in a good way) to write some notes on the topics I’ve learned so far. This time it’s the notes on how to find candidate key of a given

No Thumbnail

Getting Started using Apache OpenJPA

Few weeks ago we were required to learn an Object Relational Mapping (ORM) concept in our Introduction to Database Management System course. The ORM our professor wanted us to use is Apache OpenJPA. Not really sure what was the reason he chose Apache OpenJPA over

No Thumbnail

How To Check if a Relation is in BCNF, 3NF, or Both

Another note of my database lecture class regarding Normalization and checking whether a relation is in BCNF, 3NF, or both. The textbook that I use is “Database Management System” by Ramakrishnan and Gehrke and though it is a very comprehensive textbook, it is not that

No Thumbnail

djitz Java Developer Resume

Hi all, for the whole fall semester I attended a Cooperative Education Seminars classes in my university and I’ve received a lot of useful lessons about writing a good resume. The Professor always says that your resume is the your first representation so you want