O'Reilly logo

MDA Explained: The Model Driven Architecture™: Practice and Promise by Anneke Kleppe, Jos Warmer, Wim Bast

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix B. The Code for Rosa's System

The SQL Code for Rosa's System

The following code snippet is the SQL script to create the tables for Rosa's Breakfast Service:

 CREATE TABLE Comestible ( comestibleID INTEGER NOT NULL, name VARCHAR (40) NULL, price REAL NULL, minimalQuantity INTEGER NULL, transportForm VARCHAR (40) NULL, PRIMARY KEY (comestibleID) ); CREATE TABLE StandardBreakfast ( standardBreakfastID INTEGER NOT NULL, name VARCHAR (40) NULL, price REAL NULL, style INTEGER NULL, PRIMARY KEY (tabelID) ); CREATE TABLE Part ( standardBreakfastID INTEGER NOT NULL, comestibleID INTEGER NOT NULL, quantity INTEGER NULL, PRIMARY KEY (standardBreakfastID, comestibleID) ); CREATE TABLE Customer ( customerID INTEGER NOT NULL, accountNumber DECIMAL NULL, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required