Skip to Content
MDA Explained: The Model Driven Architecture™: Practice and Promise
book

MDA Explained: The Model Driven Architecture™: Practice and Promise

by Anneke Kleppe, Jos Warmer, Wim Bast
April 2003
Intermediate to advanced
192 pages
4h 8m
English
Addison-Wesley Professional
Content preview from MDA Explained: The Model Driven Architecture™: Practice and Promise

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, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

What Employees Want Most in Uncertain Times

What Employees Want Most in Uncertain Times

Kristine W. Powers, Jessica B.B. Diaz
What Successful Project Managers Do

What Successful Project Managers Do

W. Scott Cameron, Jeffrey S. Russell, Edward J. Hoffman, Alexander Laufer
MDA Distilled: Principles of Model-Driven Architecture

MDA Distilled: Principles of Model-Driven Architecture

Stephen J. Mellor, Kendall Scott, Axel Uhl, Dirk Weise

Publisher Resources

ISBN: 032119442XPurchase book