Database Practice: SQLite and PostgreSQL
Database Design Database is a system to manage data, which is built on file system offered by OS. Broadly speaking, there are two cases in which database is utilized: OLTP, OnLine Transaction Process, for supporting daily business OLAP, OnLine Analysis Process, for supporting data analysis in Data Warehouse Database design is actually the design of data tables (entities) and their relationships. The design purposes are: store information without unnecessary redundancy retrieve information easily and fast Normal Form (NF) NFs are used to eliminate information redundancy. The higher NF, the less redundancy. ...