Caren Schlaub Securities DB

Caren Schlaub Securities (CSS) is a full service, discount brokerage firm selling stocks on behalf of its clients. The firm is based in Newark, New Jersey. CSS sells stocks mostly across the New York-New Jersey area, but can have customers anywhere in the United States. Customers open accounts in order to buy and sell stocks.

Every few months there is a new featured stock table imported into the system. To add this featured stock, import the data that is created in Assignment 2 into this database. Import the data before you begin to design the other tables.

The symbol table lists the stock symbols for each valid stock. It contains the symbol, the full company name, its last closing price, and the volume sold on the day of the close. Add your featured stock to this table with the closing price and volume from the last day you tracked.

Clients place their orders when they believe they can make a profit. Each client enters identifying information including an experience rating. Experienced traders are given a 5. Inexperienced traders are given a 1.

Each sale is tracked with the client number, the symbol of the stock bought or sold, the purchase date, and the quantity. Sales are entered as negative numbers. For this exercise we will assume there are only stock purchase. The sales price is the closing price given in the data table.

CSS needs you to:

• Create a Microsoft Access database named "YOURNAME_Stocks"
• Import your featured stock data using the CSV file you created in Assignment 2. The name of this table will be of the form "YourFirstName-YourLastName-FeaturedStockSymbol." For my data that table becomes Art-Hendela-CL
• Create the tables, fields, data types, and primary key(s) for the database.
• Add your featured stock to the symbol table, if it is not already there.
• Create the relationship(s) needed between the tables.
• Populate the database with the data provided at the end of this description.