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, ...
Get MDA Explained: The Model Driven Architecture™: Practice and Promise now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
