Design Database Term Project Project Description Security Trading System 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, each 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 10. 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 be both, and it can not be something else. The last trading price and current daily volume for every symbol and option should be recorded. Stocks and options are owned and traded by traders. A trader has a name and a tax id. The tax id uniquely determines the trader. The value of tax id is between "000001" and "500000". Traders do not trade directly, but via brokerages. A brokerage is uniquely determined by its name and state. Each brokerage deals with one or more exchanges and pays a fixed yearly fee to every exchange it deals with. The fee could be different for every brokerage/exchange pair. A trader owns at least one account with at least one brokerage. She/he may hold more than one account with the same brokerage and deal with more than 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. Traders place trading orders via their brokerages. An order specifies the account, exactly one symbol or option to trade, "bid" (buy) or "ask" (sell), number of shares to trade, and the order expiration. There are two types of orders: "market" and "limit". A limit order has the limit price in addition to the 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: exactly one bid order, exactly one ask order, number of shares, transaction price, commissions paid by the buyer and the seller to their brokerages, and the timestamp. Exchange and transaction number uniquely determine the transaction. Note that an order could be filled by several transactions. The stocks and options are traded if their orders are fulfilled by some transactions. you are required to create a database for this company. 1. Draw a ER diagram, 2. Normalized tables, 3. Relationships, 4. Sample data (minimum of 15 rows per table). 5. Table, queries, forms, reports and switchboard.
Recently Asked Questions
- What lines in Sam Cooke's lyric "A Change Is Gonna Come" invoke the antebellum slavery origins of the spirituals? What historical underpinnings do you find in
- Please refer to the attachment to answer this question. This question was created from Study Guide Exam 1.
- If Wanda increases the price on her products, demand will decrease. She will make a profit with the higher price and have the ability to increase supply but if