Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assignment 3 ( 1 0 0 Points ) Caren Schlaub Securities Caren Schlaub Securities ( CSS ) is a full service, discount brokerage firm selling
Assignment 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 YorkNew 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 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 Inexperienced traders are given a 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 YOURNAMEStocks Import your featured stock data using the CSV file you created in Assignment The name of this table will be of the form YourFirstNameYourLastNameFeaturedStockSymbol. For my example I will use ArtHendelaHD Create the tables, fields, data types, and primary keys for the database. Add your featured stock to the symbol table, if it is not already there. Create the relationships 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 keys 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 YourFirstNameYourLastNameYourStocksymbol. Substitute your actual names and stock symbols. PLEASE HELP. Attached Screenshot is of assignment
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started