A database management system sits between the user and the stored data. This topic covers the features it provides: the data dictionary, the developer interface, the query processor and the tools for enforcing security and access rights. You will study how a DBMS reduces data redundancy and inconsistency, how it separates the logical schema from physical storage, and why this separation matters. Data definition and data manipulation languages are introduced as the means of working with it.
🔒 Sign in to view this topic's basics.