1 / 15

St. Edwards COSC 3337

St. Edwards COSC 3337. Kasey Tague & Sean Dugan. J - do office managers manage more accounts than other non-office manages Brokers (number and stocks). Show all office manager accounts. SHOW ALL OFFICE MANAGER ACCOUNTS.

aira
Download Presentation

St. Edwards COSC 3337

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. St. Edwards COSC 3337 Kasey Tague & Sean Dugan

  2. J - do office managers manage more accounts than other non-office manages Brokers (number and stocks)

  3. Show all office manager accounts

  4. SHOW ALL OFFICE MANAGER ACCOUNTS

  5. No support for NOT NULL with comparison operators in order to show all brokers who are not office managers. This is why normalization and good database design is important from the start. Work around SELECT * FROM table WHERE NOT (YourColumn  NULL); Not standard SQL. Instead, restructure database design.

  6. Show all office manager accounts

  7. Output

  8. SHOW ALL BROKERS AND ACCOUNTS WHO ARE NOT MANAGERS

  9. OUTPUT

  10. Report results • Currently office managers manage more accounts and a greater number of stocks than non-office managers.

  11. Real Life Application • Here at Pie in the Sky we value integrity over self monetary gain • Our system involves the management of possibly millions of dollars so the need for auditing is very important

  12. Auditing Trigger On New Trades • The Auditing system fires on the event of a new trade entering the system • Currently it logs the tradeID and the number of Stocks • Easily evolved to catch any legality issues of a high volume trade system

  13. DELIMITER | CREATE TRIGGER audit_trade BEFORE INSERT ON Trades FOR EACH ROW BEGIN INSERT INTO trade_audit (tradeID,noStocks) values (NEW.tradeId,NEW.noStocks); DELETE FROM trade_audit WHERE noStocks<'10000'; END; | DELIMITER ;

  14. Demo

More Related