Summarize how database design principles differ with regards to the design of updateable databases and the design of read-only databases.
- Summarize how database design principles differ with regards to the design of updateable databases and the design of read-only databases.
Database design principles have different implications when it comes to designing updateable databases vs read-only databases due to their unique nature and functionality. In the case of designing and developing a database that will be updated later, database designers have to take into consideration the inconsistent data. For this reason they have to carefully apply the normalization principles. It means that tables will be generalized to a larger extant.
In case of designing a read-only databases, we might have to denormalized by mixing it together because we are interested in the combined results. Therefore normalization is not desired as it is in updateable database design.
