Question : Each order has a unique SalesOrderNumber. An order is made up of various PartID numbers, each with an […]
Tag: normalization
Normalization of the this relation just want to know what are the functional dependencies
Question : Consider the Customer account database of the ABC big bank, which keeps data for customers and their orders. […]
For BCNF decomposition, is it okay to have a relation with none of the original functional dependencies?
Question : Given the relation R[c, f, g, h, e, j, a, b, d, i] with the below functional dependencies […]
Database Table Design
Question : I would like to ask couple of questions regarding my schema table design. I have the following data […]
Users vs. People – where to keep the email address?
Question : I’m designing an app similar to Facebook, called Headtome. I want to have users that create public profiles, […]
Good learning source for learning normalization [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Shopping list question – questions about which […]
Should I normalise this database?
Question : I have two database designs thought of for storing messages(instant messages) between users. It will be a group […]
Checking for BCNF in a relational database through FDs?
Question : Okay so I know that for BCNF, when listing all non-trivial FD’s that everything to the left has […]
MySQL – Store date as a value with an ID?
Question : I’ve got a database with the following structure: Elements table +————+—————+—————+—–+ | element_id | user_id | element_data2 | […]
How to normalize a database which uses tables as references to other tables?
Question : I’m trying to create the database for my application, but I cannot manage to normalize my data on […]