API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 9th, 2019
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.50 KB | None | 0 0
raw download clone embed print report
  1. create database IDONT;
  2. use IDONT;
  3. CREATE TABLE Companies(
  4.     ID_company integer identity(1,1),
  5.     name_company varchar(100),
  6.     country varchar(50),
  7.     address_companies varchar(100),
  8.     value_company float,
  9.     PRIMARY KEY (ID_company)
  10. );
  11. CREATE TABLE Fees (
  12.     fee_class integer identity(1,1),
  13.     fee_value float CHECK (fee_value >= 0 AND fee_value <= 1),
  14.     PRIMARY KEY (fee_class)
  15. );
  16. CREATE TABLE Person (
  17.     ID_person integer identity(1,1),
  18.     name_person varchar(50),
  19.     surname_person varchar(50),
  20.     country varchar(60),
  21.     address_person varchar(100),
  22.     phone_person varchar(9) CHECK (phone_person LIKE '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
  23.     PRIMARY KEY (ID_person)
  24. );
  25. CREATE TABLE Personal_Account (
  26.     ID_person integer,
  27.     ammount integer,
  28.     currency varchar(3) CHECK (currency IN ('PLN','EUR','USD')),
  29.     PRIMARY KEY (ID_person, currency),
  30.     FOREIGN KEY (ID_person) REFERENCES Person ON DELETE CASCADE ON UPDATE CASCADE
  31. );
  32. CREATE TABLE Stocks(
  33.     ID_stock integer identity(1,1),
  34.     ID_company integer,
  35.     prince_open float,
  36.     prince_close float,
  37.     lastest_trade float,
  38.     quantity integer,
  39.     PRIMARY KEY (ID_stock),
  40.     FOREIGN KEY (ID_company) REFERENCES Companies ON DELETE CASCADE ON UPDATE CASCADE
  41. );
  42. CREATE TABLE Asks (
  43.     ID_ask integer identity(1,1),
  44.     ID_person integer,
  45.     ID_stock integer,
  46.     date_ask DATETIME,
  47.     price_ask float,
  48.     quantity_ask integer,
  49.     PRIMARY KEY (ID_ask),
  50.     FOREIGN KEY (ID_stock) REFERENCES Stocks ON DELETE CASCADE ON UPDATE CASCADE,
  51.     FOREIGN KEY (ID_person) REFERENCES Person ON DELETE CASCADE ON UPDATE CASCADE
  52. );
  53. CREATE TABLE Bids (
  54.     ID_bid integer identity(1,1),
  55.     ID_person integer,
  56.     ID_stock integer,
  57.     date_bid DATETIME,
  58.     price_bid float,
  59.     quantity_bid integer,
  60.     PRIMARY KEY (ID_bid),
  61.     FOREIGN KEY (ID_stock) REFERENCES Stocks ON DELETE CASCADE ON UPDATE CASCADE,
  62.     FOREIGN KEY (ID_person) REFERENCES Person ON DELETE CASCADE ON UPDATE CASCADE
  63. );
  64. CREATE TABLE Personal_Stocks (
  65.     ID_person integer,
  66.     ID_stock integer,
  67.     date_of_buy DATETIME,
  68.     quantity integer,
  69.     price_per_one integer,
  70.     PRIMARY KEY (ID_stock, date_of_buy),
  71.     FOREIGN KEY (ID_person) REFERENCES Person ON DELETE CASCADE ON UPDATE CASCADE
  72. );
  73. CREATE TABLE Quotes (
  74.     ID_quote integer identity(1,1),
  75.     ID_ask integer,
  76.     ID_bid integer,
  77.     ID_stock integer,
  78.     date_creation DATETIME,
  79.     quantity integer,
  80.     ask_price float,
  81.     bid_price float,
  82.     last_price float,
  83.     PRIMARY KEY (ID_quote),
  84.     FOREIGN KEY (ID_stock) REFERENCES Stocks ON DELETE CASCADE ON UPDATE CASCADE,
  85.     FOREIGN KEY (ID_ask) REFERENCES Asks,
  86.     FOREIGN KEY (ID_bid) REFERENCES Bids
  87. );
  88.  
  89. CREATE TABLE Transactions (
  90.     ID_transaction integer identity(1,1),
  91.     ID_quote integer,
  92.     ID_stock integer,
  93.     quantity integer,
  94.     date_transaction DATETIME,
  95.     fee_value float,
  96.     value_transaction float,
  97.     PRIMARY KEY (ID_transaction),
  98.     FOREIGN KEY (ID_quote) REFERENCES Quotes ON DELETE CASCADE ON UPDATE CASCADE,
  99.     FOREIGN KEY (ID_stock) REFERENCES Stocks
  100. );
  101. CREATE TABLE Operation (
  102.     ID_operation integer identity(1,1),
  103.     ID_person integer,
  104.     currency varchar(3) CHECK (currency IN ('PLN','EUR','USD')),
  105.     type_operation varchar(50),
  106.     date_operation DATETIME,
  107.     balance integer,
  108.     PRIMARY KEY (ID_operation),
  109.     FOREIGN KEY (ID_person, currency) REFERENCES Personal_Account ON DELETE CASCADE ON UPDATE CASCADE
  110. );
  111. CREATE TABLE Dividends(
  112.     ID_stock integer,
  113.     ID_company integer,
  114.     announcment_date DATETIME,
  115.     exdividend_date DATETIME,
  116.     record_date DATETIME,
  117.     payment_date DATETIME,
  118.     PRIMARY KEY (ID_stock, announcment_date),
  119.     FOREIGN KEY (ID_company) REFERENCES Companies,
  120.     FOREIGN KEY (ID_stock) REFERENCES Stocks ON DELETE CASCADE ON UPDATE CASCADE
  121. );
  122. CREATE TABLE Turnovers(
  123.     date_turnovers DATETIME,
  124.     ID_stock integer,
  125.     quantity integer,
  126.     value_tunover float,
  127.     highest_value float,
  128.     lowest_value float,
  129.     last_trade float,
  130.     PRIMARY KEY (ID_stock, date_turnovers),
  131.     FOREIGN KEY (ID_stock) REFERENCES Stocks ON DELETE CASCADE ON UPDATE CASCADE
  132. );
  133.  
  134.  
  135. /*
  136. SELECT  'DROP TABLE [' + name + '];'
  137. FROM    sys.tables;
  138. DROP TABLE [Turnovers];
  139. DROP TABLE [Dividends];
  140. DROP TABLE [Operation];
  141. DROP TABLE [Transactions];
  142. DROP TABLE [Quotes];
  143. DROP TABLE [Personal_Stocks];
  144. DROP TABLE [Bids];
  145. DROP TABLE [Asks];
  146. DROP TABLE [Personal_Account];
  147. DROP TABLE [Person];
  148. DROP TABLE [Stocks];
  149. DROP TABLE [Fees];
  150. DROP TABLE [Companies];
  151. */
  152.  
  153. SELECT * FROM Companies;
  154. SELECT * FROM Fees;
  155. SELECT * FROM Stocks;
  156. SELECT * FROM Person;
  157. SELECT * FROM Personal_Account;
  158. SELECT * FROM Asks;
  159. SELECT * FROM Bids;
  160. SELECT * FROM Personal_Stocks;
  161. SELECT * FROM Quotes;
  162. SELECT * FROM Transactions;
  163. SELECT * FROM Operation;
  164. SELECT * FROM Dividends;
  165. SELECT * FROM Turnovers;
  166.  
  167.  
  168. -- COMPANIES FULLFILMENT
  169. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('LAB DOCU', 'Germany', 'Berlin, Haub Strasse 38', 549002);
  170. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('PETRO BEN', 'Norway', 'Oslo, Haluub 10', 48289902);
  171. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('SHARKIO', 'USA', 'NewYork, Kowalsky 22', 234221);
  172. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('JUPYTERIA', 'Poland', 'Gdansk, Grunwaldzka 19', 20321232);
  173. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('LAPORAD', 'Iceland', 'Reyjkavik, Viking Strasse 99', 1929103);
  174. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('KUKURUMBU', 'Mexico', 'Mexico, Salsa 55', 104322);
  175. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('JP RANGERS', 'Ukraine', 'Lvov, Herlanga 12', 3440981);
  176. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('SPEAKAX', 'France', 'Lyon, Parlasse 4', 325921);
  177. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('RANDA PANDA', 'China', 'Bejing, Suanga 0990', 312629001);
  178. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('LAKKU', 'Spain', 'Barcelona, Larrata 68', 102223);
  179. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('NUVE LABE', 'France', 'Paris, Lallo 1', 1002307);
  180. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('RUBIBI', 'Poland', 'Warsaw, Poznanska 23', 564203);
  181. INSERT INTO Companies (name_company, country, address_companies, value_company) VALUES ('LANDOX', 'Poland', 'Sopot, Koronna 11', 12223023);
  182.  
  183.  
  184.  
  185. -- FEES FULLFILMENT
  186. INSERT INTO Fees (fee_value) VALUES (0.08);
  187. INSERT INTO Fees (fee_value) VALUES (0.1);
  188. INSERT INTO Fees (fee_value) VALUES (0.14);
  189. INSERT INTO Fees (fee_value) VALUES (0.15);
  190. INSERT INTO Fees (fee_value) VALUES (0.19);
  191. INSERT INTO Fees (fee_value) VALUES (0.24);
  192.  
  193.  
  194.  
  195. -- PERSON FULLFILMENT
  196. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Tomasz','Jakowy','Poland','Gdansk, Kamienna 21','292322118');
  197. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Adam','Lapar','Poland','Wroclaw, Lotnikow 1','852048201');
  198. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Leon','Podloga','Poland','Warsaw, Jagiellonska 82','829290403');
  199. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Dawid','Robota','Poland','Leszon, Opolna 13','990823312');
  200. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Bartek','Podrak','Poland','Sopot, Walna 91','526237872');
  201. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Waldemar','Rabat','Poland','Bydgoszcz, Polna 4','627389442');
  202. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Aleksander','Nowak','Poland','Gdansk, Cicha 82','526482930');
  203. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Daniel','Mak','Poland','Poznan, Rabiego 11','551662838');
  204. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Marek','Walka','Poland','Jackowo, Robocza 9','515672773');
  205. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Andrzej','Barszcz','Poland','Kolonia, Czarna 16','413223434');
  206. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Wojtek','Polak','Poland','Cracow, Waleczna 41','549929030');
  207. INSERT INTO Person (name_person, surname_person, country, address_person, phone_person) VALUES ('Natan','Warek','Poland','Gdansk, Wietrzna 84','334989221');
  208.  
  209.  
  210.  
  211. -- PERSONAL ACCOUNTS FULLFILMENT
  212. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (1, 1920, 'PLN');
  213. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (1, 5465446, 'EUR');
  214. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (2, 4536, 'PLN');
  215. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (2, 4532, 'USD');
  216. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (1, 1945320, 'USD');
  217. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (2, 197720, 'EUR');
  218. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (3, 78, 'PLN');
  219. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (4, 1454, 'PLN');
  220. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (3, 78675, 'EUR');
  221. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (5, 7733, 'PLN');
  222. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (3, 7373, 'EUR');
  223. INSERT INTO Personal_Account (ID_person, ammount, currency) VALUES (4, 98981, 'USD');
  224.  
  225.  
  226. -- STOCKS FULLFILMENT
  227. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES (1, 41.32, 43.21, 43.21, 500);
  228. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES (2, 103.21, 102.23, 102.23, 10000);
  229. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES (3, 12.10, 14.08, 14.08, 1000);
  230. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES  (4, 43.32, 47.51, 47.51, 8000);
  231. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES  (5, 33.01, 35.15, 35.15, 3000);
  232. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES  (6, 7.33, 8.20, 8.20, 100);
  233. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES  (7, 55.65, 55.84, 55.84, 2700);
  234. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES  (8, 84.21, 79.34, 79.34, 400);
  235. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES  (9, 121.34, 126.45, 126.45, 40000);
  236. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES  (10, 28.22, 29.10, 29.10, 100);
  237. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES  (11, 18.22, 18.19, 18.19, 500);
  238. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES  (12, 74.01, 78.22, 78.22, 500);
  239. INSERT INTO Stocks (ID_company, prince_open, prince_close, lastest_trade, quantity) VALUES  (13, 102.04, 113.48, 113.48, 1000);
  240.  
  241.  
  242. -- ASKS FULLFILMENT
  243. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (1,2, 2019-12-08, 102.25, 5);
  244. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (1,4, 2019-12-08, 44.11, 10);
  245. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (2,3, 2019-12-08, 12.25, 10);
  246. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (4,1, 2019-12-08, 42.65, 3);
  247. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (5,6, 2019-12-08, 7.66, 100);
  248. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (4,4, 2019-12-08, 44.36, 8);
  249. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (3,6, 2019-12-08, 6.59, 100);
  250. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (1,12, 2019-12-08, 76.82, 2);
  251. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (5,5, 2019-12-08, 32.21, 5);
  252. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (5,9, 2019-12-08, 125.35, 15);
  253. INSERT INTO Asks (ID_person, ID_stock, date_ask, price_ask, quantity_ask) VALUES (3,10, 2019-12-08, 13.29, 20);
  254.  
  255.  
  256. -- BIDS FULLFILMENT
  257. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (1,7, 2019-12-08, 56.55, 5);
  258. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (4,2, 2019-12-08, 103.45, 5);
  259. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (1,3, 2019-12-08, 12.45, 10);
  260. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (3,4, 2019-12-08, 44.51, 20);
  261. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (5,1, 2019-12-08, 42.85, 40);
  262. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (3,2, 2019-12-08, 104.21, 5);
  263. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (4,9, 2019-12-08, 125.82, 10);
  264. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (2,10, 2019-12-08, 14.33, 20);
  265. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (4,8, 2019-12-08, 80.21, 15);
  266. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (1,6, 2019-12-08, 8.01, 80);
  267. INSERT INTO Bids (ID_person, ID_stock, date_bid, price_bid, quantity_bid) VALUES (2,5, 2019-12-08, 33.11, 30);
  268.  
  269.  
  270. -- QUOTES FULLFILMENT
  271. INSERT INTO Quotes (ID_ask, ID_bid, ID_stock, date_creation, quantity, ask_price, bid_price, last_price) VALUES (1,2,2, 2019-12-08, 5, 102.25, 103.45, 103.32);
  272. INSERT INTO Quotes (ID_ask, ID_bid, ID_stock, date_creation, quantity, ask_price, bid_price, last_price) VALUES ( 2, 4, 4, 2019-12-08, 10, 44.11, 44.51, 44.69);
  273. INSERT INTO Quotes (ID_ask, ID_bid, ID_stock, date_creation, quantity, ask_price, bid_price, last_price) VALUES (3,3,3, 2019-12-08, 10, 12.25, 12.45, 12.38);
  274. INSERT INTO Quotes (ID_ask, ID_bid, ID_stock, date_creation, quantity, ask_price, bid_price, last_price) VALUES (4,5,1, 2019-12-08, 3, 42.65, 42.85, 42.79);
  275. INSERT INTO Quotes (ID_ask, ID_bid, ID_stock, date_creation, quantity, ask_price, bid_price, last_price) VALUES (5,10,6, 2019-12-08, 80, 7.66, 8.01, 8.03);
  276. INSERT INTO Quotes (ID_ask, ID_bid, ID_stock, date_creation, quantity, ask_price, bid_price, last_price) VALUES (11,8,10, 2019-12-08, 20, 13.29, 14.33, 13.99);
  277.  
  278.  
  279. -- PERSONAL_STOCKS FULLFILMENT
  280. INSERT INTO Personal_Stocks (ID_person, ID_stock, date_of_buy, quantity, price_per_one) VALUES (1, 2, 2019-12-08, 5, 103.45);
  281. INSERT INTO Personal_Stocks (ID_person, ID_stock, date_of_buy, quantity, price_per_one) VALUES (1, 4, 2019-12-08, 10, 44.51);
  282. INSERT INTO Personal_Stocks (ID_person, ID_stock, date_of_buy, quantity, price_per_one) VALUES (2, 3, 2019-12-08, 10, 12.45);
  283. INSERT INTO Personal_Stocks (ID_person, ID_stock, date_of_buy, quantity, price_per_one) VALUES (4, 1, 2019-12-08, 3, 42.85);
  284. INSERT INTO Personal_Stocks (ID_person, ID_stock, date_of_buy, quantity, price_per_one) VALUES (5, 6, 2019-12-08, 80, 8.01);
  285. INSERT INTO Personal_Stocks (ID_person, ID_stock, date_of_buy, quantity, price_per_one) VALUES (3, 10, 2019-12-08, 20, 14.33);
  286.  
  287.  
  288. -- TRANSACTIONS FULLFILMENT
  289. INSERT INTO Transactions (ID_quote, ID_stock, quantity, date_transaction, fee_value, value_transaction) VALUES (1, 2, 5, 2019-12-08, 0.1, 568.97);
  290. INSERT INTO Transactions (ID_quote, ID_stock, quantity, date_transaction, fee_value, value_transaction) VALUES (2, 4, 10, 2019-12-08, 0.08, 480.70);
  291. INSERT INTO Transactions (ID_quote, ID_stock, quantity, date_transaction, fee_value, value_transaction) VALUES (3, 3, 10, 2019-12-08, 0.1, 136.95);
  292. INSERT INTO Transactions (ID_quote, ID_stock, quantity, date_transaction, fee_value, value_transaction) VALUES (4, 1, 3, 2019-12-08, 0.14, 146.54);
  293. INSERT INTO Transactions (ID_quote, ID_stock, quantity, date_transaction, fee_value, value_transaction) VALUES (5, 6, 80, 2019-12-08, 0.24, 794.59);
  294. INSERT INTO Transactions (ID_quote, ID_stock, quantity, date_transaction, fee_value, value_transaction) VALUES (6, 10, 20, 2019-12-08, 0.15, 329.59);
  295.  
  296.  
  297. -- DIVIDENDS FULLFILMENT
  298. INSERT INTO Dividends (ID_stock, ID_company, announcment_date, exdividend_date, record_date, payment_date) VALUES (1, 1, 2019-12-08, 2019-12-18, 2019-12-08, 2019-12-18);
  299. INSERT INTO Dividends (ID_stock, ID_company, announcment_date, exdividend_date, record_date, payment_date) VALUES (3, 3, 2019-12-08, 2019-12-18, 2019-12-08, 2019-12-18);
  300. INSERT INTO Dividends (ID_stock, ID_company, announcment_date, exdividend_date, record_date, payment_date) VALUES (5, 5, 2019-12-08, 2019-12-18, 2019-12-08, 2019-12-18);
  301. INSERT INTO Dividends (ID_stock, ID_company, announcment_date, exdividend_date, record_date, payment_date) VALUES (4, 4, 2019-12-08, 2019-12-18, 2019-12-08, 2019-12-18);
  302.  
  303.  
  304. -- TURNOVERS FULLFILMENT
  305. INSERT INTO Dividends (date_turnovers, ID_stock, quantity, value_tunover, highest_value, lowest_value, last_trade) VALUES (2019-12-08, 2, 5, 1.2,103.45, 102.25, 103.45);
  306. INSERT INTO Dividends (date_turnovers, ID_stock, quantity, value_tunover, highest_value, lowest_value, last_trade) VALUES (2019-12-08, 4, 10, 0.58, 44.69, 44.11, 44.51);
  307. INSERT INTO Dividends (date_turnovers, ID_stock, quantity, value_tunover, highest_value, lowest_value, last_trade) VALUES (2019-12-08, 3, 10, 0.2, 12.45, 12.25, 12.45);
  308. INSERT INTO Dividends (date_turnovers, ID_stock, quantity, value_tunover, highest_value, lowest_value, last_trade) VALUES (2019-12-08, 1, 3, 0.2, 42.85, 42.65, 42.85);
  309. INSERT INTO Dividends (date_turnovers, ID_stock, quantity, value_tunover, highest_value, lowest_value, last_trade) VALUES (2019-12-08, 6, 80, 0.37, 8.03, 7.66, 8.01);
  310. INSERT INTO Dividends (date_turnovers, ID_stock, quantity, value_tunover, highest_value, lowest_value, last_trade) VALUES (2019-12-08, 10, 20, 1.04, 14.33, 13.29, 14.33);
  311.  
  312.  
  313.  
  314. -- OPERATION FULLFILMENT
  315. INSERT INTO Operation (ID_person, currency, type_operation, date_operation, balance) VALUES (6, 10, 20, 2019-12-08, 0.15, 329.59);
  316.  
  317.  
  318.  
  319.  
  320.  
  321.  
  322.  
  323.  
  324. CREATE TABLE table1(
  325.     id_1 int identity(1,1),
  326.     atr1a int,
  327.     atr1b int,
  328.     PRIMARY KEY (id_1),
  329. );
  330.  
  331. CREATE TABLE table2(
  332.     id_2 int identity(1,1),
  333.     id_1 int,
  334.     atr12 varchar(3),
  335.     PRIMARY KEY (id_2),
  336.     FOREIGN KEY (id_1) REFERENCES table1 ON DELETE CASCADE,
  337.     CONSTRAINT CHK_Person CHECK (atr12 IN ('PLN','EUR','USD'))
  338. );
  339.  
  340. DROP TABLE table1;
  341. DROP TABLE table2;
  342.  
  343. INSERT INTO table1 (atr1a, atr1b) VALUES  (12, 12);
  344. INSERT INTO table1 (atr1a, atr1b) VALUES  (14, 14);
  345. INSERT INTO table2 (id_1, atr12) VALUES  (1, 'USD');
  346.  
  347. SELECT * FROM table1;
  348. SELECT * FROM table2;
  349.  
  350. DELETE FROM table1
  351.  WHERE id_1=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!