Hello I need help on following hw assignment on .net

 

1BIT 3444Homework 4: A DataReader ApplicationDue by Thursday, March 31, 2016 (11:55pm)Homework 4 Submission: This is an individual homework assignment. You should saveyour database file in the folder: <your VB project folder>/bin/debug. Compress yourcomplete VB project folder into a .zip file. The file name should have the format:4_LastName_F.zip. Upload the .zip file to our homework submission site.In this assignment, you will implement an electronic stock trading system. Your systemwill accept trading orders and based on those orders, it will keep track of pending orders,and execute trades when possible.1. Database design (15 points)Design a relational database for the stock trading system using Microsoft Access. Youshould determine the tables to be created, the attributes in each table, and the primary keyin each table.DO NOT define foreign keys in this assignment even they do exist. It will be easier foryou to debug your VB program when foreign keys are absent.Do NOT use special characters (e.g., space) in table/attribute names.Do NOT use any Microsoft Access Reserved word (List of MS Access Reserved words:https://support.office.com/en-us/article/Access-2007-reserved-words-and-symbols-e33eb3a9-8baa-4335-9f57-da237c63eabe).The system maintains common stocks records. Each stock is described by a ticker symbol(e.g., BAC), a company name, exchange venue (e.g., NYSE), listing date, sector, andindustry.The system also keeps track of stocks’ daily closing records. Each closing record consistsof a ticker symbol, a date, the opening price, the highest price of the day, the lowest priceof the day, the closing price, the trading volume on that day, 1 day price change %, andlast year’s return rate %.Users can use the system to place market order requests for stock trading. A market orderis a request to purchase or sell a stock at the current market price. Each order requestshould include a ticker symbol, date and time of the request, type of order (buy or sell),quantity of stock to be traded, and order status (pending, completed, or cancelled).2. Database population (5 points)Use Microsoft Access to populate at least 10 records into each of the database tables createdabove. You must pick at least 10 stocks from this web site:http://www.1stock1.com/1stock1_112.htm, where you can find last year’s return rate % for eachstock. For other stock information, please use the Yahoo! Finance(http://finance.yahoo.com/stock-center/) and search by the stock ticker symbol. The sector and

• 1496714784-HW4.pdf

ComputerScienceExpert

(11)

Status NEW Posted 06 Jun 2017 02:06 AM My Price 8.00

-----------

Attachments

file 1496714785-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer