Question: Acquire the csv files below which are Calendar StockData and CompanyInformation Observe the following data in the stockdata csv fileTickerSymbol Industry TradeDate STOpen STHigh STLow

Acquire the csv files below which are Calendar StockData and CompanyInformation Observe the following data in the stockdata csv fileTickerSymbol Industry TradeDate STOpen STHigh STLow STClose Volume Import the stock data into SQL Server and change the data types to be appropriate Note that at this point you have data in a single table Make sure to name the table StockData Import the companyinformation csv file and change the data types and name the table CompanyInformation Import the calendar table from the Stockdata table to include all days from Jan 1 1900 to Dec 31 2050The calendar attributes you need are ActualDate MonthName DayNumber YearNumber DayOfWeek and DayType Create a foreign key relationship with the date attributes in the stock data and calendar tables Make sure you understand the primary key and foreign key relationship Create five constraints on any of the three tables in any combination Make an attractive cover page with your name the assignment due date and the assignment number Deliverables A Prove that you acquired your data and that it is in SQL Server in tables B Prove that you have three tables and the data types that are in those tables C Prove that you created the constraints D Prove that you created relationships between the three tables CalendarcsvDownload Calendarcsv CompanyInformationcsvDownload CompanyInformationcsv StockDatacsvDownload StockDatacsv SQL Connectiondocx

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!