Database schema: Difference between revisions
Jump to navigation
Jump to search
Amwelladmin (talk | contribs) (Created page with "A full database schema is a physical schema and a logical schema. The physical schema displays the hardware, servers, and connections that need to be set up to install...") |
(No difference)
|
Latest revision as of 17:18, 15 November 2018
A full database schema is a physical schema and a logical schema. The physical schema displays the hardware, servers, and connections that need to be set up to install the database.
Logical schema
The structure of the data itself:
- optimise fields versus items
- normalise - reduce redundancy among data tables
- primary keys per table versus secondary keys