Database Answers Students at the University of Massachussets (Click for Web Site)

Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Student Registration
Email me if you would like an Access Database.

We have also created an Accumulating Snapshot and a Data Mart to help with Enquiries and Reports.

This page of my new Tutorial will help you understand the Data Model if you are new to Databases.

8) POC Student Registration Tables

9) Screenshot of POC
Here we see that a Student called Bobby Caldwell is registered for 4 Subjects.

KPI Student Registration Count

Accumulating Snapshot

A Data Mart for Student Registration

A Data Mart


A Simple Conceptual Data Model for Student Registration

Conceptual Data Model for Student Registration



A Logical Data Model for Student Registration

Data Model for Student Registration
Conceptual version of Our Canonical Data Model


Canonical Data Model
Our Participants ERwin Canonical Data Model
This is a little different from the Conceptual version

ERwin Canonical Data Model


Barry Williams
August 30th. 2014
Principal Consultant
Database Answers

 

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map