Common Education Data Standards Logo
 
Create an Account Forgot User Name  or Password

Normalized Data Schema

  • NDS factors the entities and attributes of the DES with standard technical syntax and 3rd normal form.
  • The NDS Logical Model provides a standard framework for integration of P-20 data systems through a well-normalized “operational data store”.
  • A “record” is generally added for each Person-Organization Relationship change event in the system. This CEDS logical model does not directly address the production aspects of log and change management.

Presentation

CEDS NDS Video

    CEDS NDS
This video describes how the CEDS NDS can help developers with new education software projects.

CEDS Integrated Data Store (IDS)

CEDS Integrated Data Store (IDS)

    CEDS IDS
The CEDS NDS has been rebranded CEDS Integrated Data Store (IDS). The CEDS IDS files reside on the CEDS Open Source Community (OSC) site on GitHub. Previous version scripts were modified to reflect this change. "NDS" changed to "IDS" with IDS versioning appended to the end of the database names, e.g., [CEDS-NDS-V7] became [CEDS-IDS-V7_0_0_0].

CEDS IDS GitHub

    To access the CEDS IDS on GitHub, click on the GitHub button then select the CEDS-IDS repository.

Data Model Documentation

Documents providing a printable representation of the CEDS Data Model, including entity relationship diagrams, case studies, and the normalized data schema tables and fields, can be found on the CEDStandards/CEDS-IDS GitHub repository in the /doc/ directory.

Database Model Downloads

SQL Script

A database script to generate a sample database is provided for those users who would like to take the entities shown on the entity relationship diagrams and work with them on a sample database representing the IDS model.


Scripts for creating a new instance of the latest CEDS IDS, upgrading existing instances of the IDS, load CEDS Element metadata, and load CEDS Option Set values to reference tables, can be found on the CEDStandards/CEDS-IDS GitHub repository in the /src/ directory.


Releases

Archive files for each release of CEDS IDS can be found on the CEDStandards/CEDS-IDS GitHub repository in the Releases tab.


Person to person relationships


Clicking on any of the buttons or links above, except the CEDS NDS presentation, will exit the CEDS website. We have provided access to these external sites because they have information that may be of interest to our users. CEDS does not necessarily endorse the views expressed or the data and facts presented on these external sites.



Common Education Data Standards