Relative Content

Tag Archive for normalization

What happens to database design process when ORM tools are used?

I have learned about database design, including normalization during my undergraduate course. When we have to model a database for a system, we can start with an ER model and then convert it to the relational model and then we could normalize the design, to come up with the final schema of the database.

Database Normalization vs dependencies

I am developing 3-4 interdependent programs. Call them foo bar baz and auth. I want them to be independent of each other. Imagine if I were to license out each program to other companies. Some companies may want foo and bar, others may just want baz, etc. It also seems like good practice to keep auth independent as well.

Normalization_Schema Refinment

Consider a relation R (A, 8, C, D, E, F, G) with the following set of functional dependencies over
R:
F = {A->BC, B->D, C->EF, AC->G}