core07.sdl

Schema for the core07Example_main.c example. Compile this schema using rdm-compile as follows:

rdm-compile --c-structs --lc-struct-members --catalog core07.sdl

and include the generated header file(s) as follows:

#include "core07_structs.h"
#include "core07_cat.h"

and compile the following generated source file(s):

core07_cat.c

Here follows the actual schema:

/*
 * EXAMPLE - Core07 for C
 *
 * This is the DDL (Database Definition Language) for a database implementing
 * a many-to-many relationship using network model sets.  The database shows
 * how to implement a course registration list with Students that attend
 * multiple Classes and Classes that are attended by multiple Students.
 * 
 * The student record has a single Name field
 * The course record has an ID and Title field
 * There is an intersection (registrations) record that does not contain any 
 * user fields
 */
 
create table class (
   id char(10) primary key,
   title char(40) not null
);
 
create table student (
   name char(40) primary key
);
 
create table enrollment (
   begin_date date,
   end_date date,
   status char(9),
   current_grade integer, 
   class_students char(10) references class,
   student_classes char(40) references student
);