3 ms·
Data and Reality, by William Kent. Earliest edition you can find. For general database design, Stephane Faroult is good. Although he comes from an Oracle backg
by tuatoru 4y ago
Data and Reality, by William Kent. Earliest edition you can find.
For general database design, Stephane Faroult is good. Although he comes from an Oracle background, and underuses domains as a result.
Rules of thumb: use up to 30 indexes per table, use views extensively, use schemas to manage access permissions. Use stored procedures for updates.
Don't let applications see tables: they should see views only.