Answered step by step
Verified Expert Solution
Link Copied!

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Current Trends In Database Technology Edbt 2006 Edbt 2006 Workshops Phd Datax Iidb Iiha Icsnw Qlqp Pim Parma And Reactivity On The Web Munich Germany March 2006 Revised Selected Papers Lncs 4254

Authors: Torsten Grust ,Hagen Hopfner ,Arantza Illarramendi ,Stefan Jablonski ,Marco Mesiti ,Sascha Muller ,Paula-Lavinia Patranjan ,Kai-Uwe Sattler ,Myra Spiliopoulou ,Jef Wijsen

2006th Edition

3540467882, 978-3540467885

More Books

Students also viewed these Databases questions

Question

1. Discuss the four components of language.

Answered: 1 week ago

Question

a. How many different groups were represented?

Answered: 1 week ago