Question : 1NF rule says that we should not keep data of different types in one single column. Does it […]
Tag: relational-theory
How can I represent discrete ages in a relational database?
Question : I am using PostgreSQL to store data on a Person. I need to store whether each Person is […]
Best approach for Legal/Natural can have many Orders
Question : I’m working on this model: where as you may see one NaturalPerson can have many Order and the […]
Surrogate key resolution, or what am I missing in the Surrogate v Natural argument?
Question : I’ve read a lot from both camps in the surrogate vs. natural key debate. What I am struggling […]
Trying to map postal codes to their respective cities, but running into some issues
Question : The Problem I am creating a database of Countries, Regions, Cities and Postal Codes. Here’s an example to […]
How does normalization fix the three types of update anomalies?
Question : I have been reading ‘Database Systems: A practical approach to design, implementation and management’ by Connolly and Begg […]
Is saving disk space still considered an advantage of normalization?
Question : I have read a while back that one of the advantages of normalization is to save disk space […]
NEWB Getting to KNow New Database and Understand Where Relationships Are
Question : I’m teaching myself SQL using MYSQL and a textbook. While working through the textbook I’m using a database […]
How to add an additional table over two one to many relations tables?
Question : I have two tables TableA and TableB which have a relation of one to many Later I am […]
RDBMS: Proper way to store data – comma separated variables or in different fields or tables?
Question : Fundamental question that I cannot seem to find an answer on. I have a database that stores line […]