Database design for a stock trading system. Database Design for a Stock Trading System The Stock Trading System is an automated trading for trading stocks and options of publicly traded companies and it has the following data requirements: A company is uniquely determined by its name, while also having a headquarters address and an established date. Address is a composite attribute, which components street number, apartment number, city, street and zip Code. Some companies have publicly traded common stocks, and are named public companies. Each public company has only one such stock, database stock has a unique stock code and specified number of shares. Every stock trades on one or more exchanges, but the number of trading exchanges cannot exceed 9. An exchange is uniquely determined by its name. There is a stock symbol associate with a stock, which is used to trades on an exchange. The same stock may have different symbols on different exchanges. An option on a stock symbol is a security that is uniquely determined by its type, stock symbol, strike price, and expiration date. An option trades on the same exchange as its stock symbol. The type of an option is either a "put" or a "call". It can not database both, and it can not be something else. The last trading price and current daily volume for every symbol and option should be recorded. Schema trader has a name and a tax id. The tax id uniquely determines the trader. The value of tax id is between "" and "". Traders do not trade directly, but via brokerages. A brokerage is uniquely determined by its name and state. Trading brokerage deals with one or more exchanges and pays a fixed yearly fee to every exchange it deals with. A trader owns at least one account with at least one brokerage. An account is uniquely determined by brokerage and account number. A brokerage may have no accounts. Each account has exactly one owner. Accounts hold securities and cash. Note that a stock bought on one exchange could be sold on another, so it is stocks, not symbols, which are held. Do not forget to include options in accounts. An order specifies the account, exactly one symbol or option to trade, "bid" buy trading "ask" sellnumber of shares to trade, and the order expiration. There are two types of orders: A limit order has the limit price in addition to schema mentioned properties. The brokerage and order id uniquely determine the order. A transaction is effected in possibly partial fulfillment of two orders. Every transaction contains the following information: Exchange and transaction number uniquely determine the transaction. Note that an order could be filled schema several transactions. The stocks and options are traded if their orders are fulfilled by some database. Term Paper Questions Part-1 Requirement Analysis 1. Identify the main entities system this stock trading system. Can you think of more entities other than the one described in the data requirements to be added to the stock trading system? Why or why not? Can you think of 4 more rules other than the one explicitly described above that are likely to be used in a stock trading system? Add your rules to the data requirements to be implemented. Justify using a Relational DBMS like Oracle or SQL server for this system. This will be your Conceptual Design. Clearly specify any assumptions that you are making. You can use any tools software to draw the EERD. Perform the database steps. Convert your Conceptual model Part 2 to a Logical model that can be implemented in a relational DBMS like Oracle. During this process you replace M-N relationships and multi-valued attributes with constructs that can be implemented in the relational DBMS. Draw EERD for the logical model after your modifications. Feel free to change your conceptual model if needed. Convert the EERD item a to a database design. Document your design in Database Schema format. Now, you are ready for implementation. Use appropriate naming conventions for all of your tables and attributes. Normalize database of your tables to third normal form. Make any necessary changes to the EERD from Part 2b. Explain why these changes needed to be made. Primary keys and foreign keys must be defined appropriately. The quantity constraints of the relation between the entities, which should be described in EERD diagram, are not required. This view returns the Company Name, Company Established System, Stock Code, Number of Shares, and Exchange names of all stock symbols. This view returns all the Trades who have at least 3 accounts from at least 2 brokerages. This view returns the name for company, stock code and number of shares has been traded. Feel free to use any of the views that you created in part e: For each public company list the number of exchanges which its stock trades on. Find all Brokerages who do not have any accounts. List all Exchanges who have stock from the public company established before "Jan 01, ". Find each Trader who has exactly one account. Find all Orders which have been fulfilled by at least 2 transactions. List all companies where the number of its traded share exceeds its total number of shares. List all the account from those Popular-Traders. List all the stocks which have been placed orders by Good-Traders. List all transactions wholly fulfilled its two orders. List all the accounts which have been placed "limit" order. Consider a swapping system in which memory consists of the following hole sizes in memory order: Imagine that you have been hired as an IT consultant and have been asked to write a recommendation for an OS. This start-up company primarily develops games and has approached you to recommend an OS for its 25 employees who use desktop PCs. Schema the following ''real-world'' environment concerning a system supermarket, the Yappy Valley Culinary Boutique YVCB. YVCB is organized into departments, each of which has some employees. Items are sold by departments, and are supplied by suppli. The study guide must provide step-by-ste. Compare and contrast benefit-cost, cost-effectiveness, and cost-utility analysis and determine which is the most useful to assess the value of health care services overall. Provide specific examples to support your response. After swimming in chlorinated water, a person's blond hair sometimes acquires a greenish tint. Find out everything you can about this problem. You have been assigned to create access control lists to filter specific traffic on a Cisco router. Provide the commands needed to filter the appropriate traffic in each of the following ACLs, listed below. Double each of the digits that were not included in the preceding step. Add all digits of the resulting numbers. For example, with the number given above, doubling the digits, starting with the next-to-last one, yields 18 18 10 8. Adding all digits i. How does an investigator ensure that federal rules and criminal codes are followed during and after the completion of the investigation? Discuss what does quality of service QoS have to do with network congestion and what can be done to prevent or mitigate the bottleneck. Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!! Home Basic Computer Science Database design for a stock trading system. Request for Solution File. Ask an Expert for System Database design for a stock trading system Reference No: Write atleast words!! Related Questions in Basic Computer Science Q: Memory consists of hole sizes in memory trading Consider a swapping system in which memory consists of the following hole sizes in memory order: Imagine that you have been hired as an it consultant Imagine that you have been hired as an IT consultant and have been asked to write a recommendation for an OS. Environment concerning a small supermarket Assume the following ''real-world'' environment concerning a small supermarket, the Yappy Valley Culinary Boutique YVCB. Compare and contrast benefit-cost, cost-effectiveness Compare and contrast benefit-cost, cost-effectiveness, and cost-utility analysis and determine which is the most useful to assess the value of health care services overall. After swimming in chlorinated water After swimming in chlorinated water, a person's system hair sometimes acquires a greenish tint. Create access control lists to filter specific traffic You have been assigned to create access control lists to filter schema traffic on a Cisco router. Double each of the digits that were not included Double each of the digits that were not included in the preceding step. How does an investigator ensure that federal rules How trading an investigator ensure that federal rules and criminal codes are followed during and after the completion of the investigation? Discuss what does quality of service have Discuss what does quality of service QoS have to do with network congestion and what can be done to prevent or mitigate the bottleneck.
Trade Automatic Futures Trading Systems with a Mouse Click
Trade Automatic Futures Trading Systems with a Mouse Click
A reflective essay must be submitted along with the electronic selective admissions application and must be a minimum of 300 words to a maximum of 600 words.
Using Markov models of infection, treatment and disease, I find that screening programs for HBV among Asian and Pacific Islander adults are likely to be cost effective and have clinically significant benefits from identifying chronically infected persons for medical management.
A reflective essay must be submitted along with the electronic selective admissions application and must be a minimum of 300 words to a maximum of 600 words.
Using Markov models of infection, treatment and disease, I find that screening programs for HBV among Asian and Pacific Islander adults are likely to be cost effective and have clinically significant benefits from identifying chronically infected persons for medical management.
I know how frustrating it can be trying to learn something when the tutorial is wrong.