Ski Club Skiing Database Using SQL Management Studio

Ski Club Skiing Database Using SQL Management Studio

Using SQL Management Studio, create the normalized tables, fields and relationships between the tables for the Skiing Database scenario below.

You have been contracted by the president of the Ski Club to design a Skiing Database:
The president has asked you to design a database to keep track of member and skiing resort information.
For each member of the club, she wants you to track name, address, phone number, age and skiing ability.
For the various ski mountains you need to track the name of the resort, its location, # of trails, # of lifts.
The president also wants a monthly report of skier activity including the skiers name, phone number, skiing ability, Ski Resort visited, the date of the visit and general comments on the skiing there.

Don’t add any additional fields other than what is being requested. That does not mean you should not break down each field to it’s smallest possible component.
Create the database using SQL Management Studio.
Detach the completed Database file and submit both the .mdf and .ldf files to the assignment in a zipped folder with your firstname followed by the initial of your lastname.