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”.
  • In a P-20 data system, the NDS models the most current view of data available to the enterprise including some historical data (such as prior assessment data and enrollment records).
  • 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.

Data Model User Guide

These documents are a printable representation of the CEDS (version 7.1) Data Model, and include entity relationship diagrams, case studies, and the normalized data schema tables and fields.


What's new in Version 7.1 What's new in Version 7.1 (1,689 KB)


What's new in Version 7 What's new in Version 7 (698 KB)


CEDS Data Model User Guide Download CEDS Data Model User Guide PDF (15 MB)


CEDS Version 7.1 Data Model User Guide Addendum Download CEDS Data Model User Guide PDF (1.853 MB)


Table and Column Listing Download Table and Column Listing Excel File (280 KB)


Database Model Downloads

SQL Script

While CEDS does not provide a physical model, 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 NDS model.


Version 7.1 - January, 2018

SQL Server 2008 Script:Download  Download zip file (436 KB)


A script is available update a version 7 model database to version 7.1: Download Update Script  Download zip file (71 KB)


A script is available to populate the NDS reference tables with the CEDS version 7.1 option set values.

Download Reference Data Population Script  Download zip file (326 KB)


A script is available to populate the NDS "_CEDS" tables with CEDS version 7.1 element details and CEDS to NDS mapping.

Download CEDS Element Data Population Script  Download zip file (150 KB)


Version 7 - July, 2017

SQL Server 2008 Script:Download  Download zip file (421 KB)


A script is available update a version 6 model database to version 7: Download Update Script  Download zip file (274 KB)


A script is available to populate the NDS reference tables with the CEDS version 7 option set values.

Download Reference Data Population Script  Download zip file (294 KB)


A script is available to populate the NDS "_CEDS" tables with CEDS version 7 element details and CEDS to NDS mapping.

Download CEDS Element Data Population Script  Download zip file (143 KB)


Version 6 - July, 2016

SQL Server 2008 Script:Download  Download zip file (265 KB)


A script is available update a version 5 model database to version 6: Download Update Script  Download zip file (10 KB)


A script is available to populate the NDS reference tables with the CEDS version 6 option set values.

Download Reference Data Population Script  Download zip file (257 KB)


Version 5 - January, 2015

SQL Server 2008 Script:Download  Download zip file (288 KB)


A script is available update a version 4 model database to version 5: Download Update Script  Download zip file (26 KB)


A script is available to populate the NDS reference tables with the CEDS version 5 option set values.

Download Reference Data Population Script  Download zip file (126 KB)


Person to person relationships


Common Education Data Standards