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(40) references class,
student_classes char(40) references student
);