View the step-by-step solution to:

Design Database Term Project Project Description Security Trading System A company is uniquely determined by its name, while also having a...

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.

This question was asked on Apr 28, 2010.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards