Fifth Normal Form (5NF) If a relation is in 4NF as well as does not contain any join dependency as well as joining is lossless then the relation is in 5th normal form. When the tables are broken into as many tables as possible in order to avoid redundancy then it can be said that 5NF is satisfied. 5th Normal...

The yearly evaluations at my company are being held next week, should I confront my manager and tell him that I think he’s unprofessional and quite lazy at work or should I shove it in to avoid damaging my career and role at work? It may be prudent to remember who this evaluation is about. Your evaluation is all about...

First Normal Form (1NF) – A relation is 1NF if it contains an atomic value. It indicates that an attribute of a table cannot contain multiple values. It can only contain one attribute with a single value. The first normal form does not allow the multivalued attribute, the compound attribute as well as its combinations. Example: The EMPLOYEE relationship is...

My boss wants me to reword my accomplishments on my LinkedIn profile to share credit with the rest of the team, should I? Without knowing the workplace background, my first reaction is that your LinkedIn profile is your individual professional page.  As long as it’s not a company LinkedIn page, you have 100% control over what you elect to publish...

DBMS Anomalies There are three types of anomalies that occur when the database is not standardized. These are anomalies when inserting, updating as well as deleting. Let’s take an example to understand this. Example: Suppose a manufacturing company stores the employee details in a table called employees with four attributes: emp_id to save the employee ID, emp_name to save the...

How do Product managers break down requirements into user stories? A good product manager doesn’t “break down” requirements into user stories, they start with good user stories and work from there. The whole point of using user stories is that they are how you communicate “requirements” to your development teams. If you’ve already got a list of “requirements” then you’re...