Posts

Showing posts from April, 2014

data modeling example

http://www.hostitwise.com/software_design/nenios_care_center_srs_data_model.html
Lab 8-2   1. Refer to the SQLInserts folder for SQL insert statements for all relations in the ProAudio database.  

OrderLinesInsert.sql

#Order_Lines INSERT INTO Order_Lines (o_num, i_num, ol_quantity, o_price, o_cost, shipped) VALUES (1, 1, 1, 9.99, 4.99, 'false'); INSERT INTO Order_Lines (o_num, i_num, ol_quantity, o_price, o_cost, shipped) VALUES (1, 7, 1, 10.99, 5.99, 'false'); INSERT INTO Order_Lines (o_num, i_num, ol_quantity, o_price, o_cost, shipped) VALUES (1, 18, 1, 11.99, 6.99, 'false'); INSERT INTO Order_Lines (o_num, i_num, ol_quantity, o_price, o_cost, shipped) VALUES (2, 3, 1, 11.99, 6.99, 'false'); INSERT INTO Order_Lines (o_num, i_num, ol_quantity, o_price, o_cost, shipped) VALUES (2, 4, 1, 12.99, 7.99, 'false'); INSERT INTO Order_Lines (o_num, i_num, ol_quantity, o_price, o_cost, shipped) VALUES (2, 8, 1, 12.99, 7.99, 'false'); INSERT INTO Order_Lines (o_num, i_num, ol_quantity, o_price, o_cost, shipped) VALUES (3, 11, 1, 11.99, 6.99, 'false'); INSERT INTO Order_Lines (o_num, i_num, ol_quantity, o_price, o_cost, shipped) VA...

microsoftSQLserver2012