How would you use SQL to create a new table in the Pitt Fitness database to capture the line of t-shirts and their retail price?

Refer to the “Pitt Fitness Case Exercises” in Chapter 3 of the textbook. Discuss the following in the Discussion Board:

• Pitt Fitness is selling a line of exercise clothing at their three locations. At the beginning of this venture, they decide to sell only three types of t-shirts with the Pitt Fitness logo: two women’s sizes and one men’s size. How would you use SQL to create a new table in the Pitt Fitness database to capture the line of t-shirts and their retail price? This new table would be used for advertising purposes only, so no quantity-on-hand fields are necessary.

In your own words, post a substantive response to the Discussion Board question(s) and comment on other postings. Your response should address the DB question(s) and move the conversation forward. You will be graded on the quality of your postings, including mastery of the concept as well as critical thinking. If asked for your opinion, do not simply state that it is a good or bad idea; elaborate on your reasons and argument. Include enough detail to substantiate your thinking as well as your position on the questions or comments.

Refer to the “Pitt Fitness Case Exercises” in Chapter 3 of the textbook. Discuss the following in the Discussion Board:

• Pitt Fitness is selling a line of exercise clothing at their three locations. At the beginning of this venture, they decide to sell only three types of t-shirts with the Pitt Fitness logo: two women’s sizes and one men’s size. How would you use SQL to create a new table in the Pitt Fitness database to capture the line of t-shirts and their retail price? This new table would be used for advertising purposes only, so no quantity-on-hand fields are necessary.

In your own words, post a substantive response to the Discussion Board question(s) and comment on other postings. Your response should address the DB question(s) and move the conversation forward. You will be graded on the quality of your postings, including mastery of the concept as well as critical thinking. If asked for your opinion, do not simply state that it is a good or bad idea; elaborate on your reasons and argument. Include enough detail to substantiate your thinking as well as your position on the questions or comments.