Assignment $3(100$ Points$)$

Caren Schlaub Securities

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 example I will use $$Art$-$Hendela$-$HD$$

$$ 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.

Please submit the created database file through the assignment link in Canvas.

HINT:

$$ There are four tables in the database

$$ Do NOT forget to define primary key$($s$)$ for your tables!

$$ Some table might have more than one attribute as its primary key

$$ Do NOT forget the relationship between the Symbol, Client, Sales, and Featured Stock tables!

Symbol Table and Data

$($NOTE: The name of the table is on the tab in the picture below. The name of your table should NOT be $$Symbol Table and Data.$)$

Client Table and Data

$($NOTE: The name of the table is on the tab in the picture below. It is NOT $$Client Table and Data.$)$

$$

Sale Table and Data

$($NOTE: The name of the table is on the tab in the picture below. The name of your table should NOT be $$Sale Table and Data.$)$

Example Feature Stock Table. YOUR DATA WILL BE DIFFERENT.

$($Note: The table name should be YourFirstName$-$YourLastName$-$YourStocksymbol. Substitute your actual names and stock symbols.$)$

PLEASE HELP. Attached Screenshot is of assignment $2.$