Assignment $1$

Acquire and Load the Data

$1.$ Acquire the $.$CSV files from Canvas which are Calendar, StockData and

CompanyInformation.

$2.$ Observe the following data in the stockdata $.$csv file: TickerSymbol, TradeDate,

ST$\_$Open, ST$\_$High, ST$\_$Low, ST$\_$Close, Volume

$3.$ Import the stockdata data into SQL Server and change the data types to be

appropriate and defend your choices. Note that at this point you have data in

a single table.

$4.$ Make sure to name the table $$StockData$.$

$5.$ Import the companyinformation csv file and change the data types and name

the table CompanyInformation.

$6.$ Create a relationship between CompanyInformation and StockData on the

common attribute "ticker symbol."

$7.$ Import the calendar table from the Stockdata table to include all days from

Jan. $1,1900$ to Dec. $31,2050.$The calendar attributes you need are ActualDate,

MonthName, DayNumber, YearNumber, DayOfWeek and DayType.

$8.$ Create relationships from date attributes in the StockData table to the

calendar table. Make sure you understand the primary key and foreign key

relationship.

$9.$ Create five constraints on any of the three tables in any combination.

$10.$ Snip the comments where you answered questions.

$11.$ Make an attractive cover page with your name, the assignment due date, and

the assignment number.

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