1) In our unit 2 we are looking at Pitt Fitness case exercise in our readings in chapter 3 of our textbook. The requirements are to create a table to capture the line of t-shirts and their retail...


1)


In our unit 2 we are looking at Pitt Fitness case exercise in our readings in chapter 3 of our textbook. The requirements are to create a table to capture the line of t-shirts and their retail price. SQL is a structured query language where users can manage, select, update, and analyze data in a relational database management system(Friedrichsen, Ruffolo, & Monk, 2020). So, let’s get started with this.


First and foremost, we need to create a table for T-Shirts and the process for that is simple. We would need to use the keyword “CREATE”. In this case we are creating a table for T-shirts (entity), and this is how it would look in SQL.


CREATE TABLE T-shirts (


Once we created the table, we can then start adding attributes into the table. So, for this part of the discussion post we need to add t-shirt ID such as a UPC number or product code (will be the primary key) then we would need to add an attribute for the type of t-shirt Pitt Fitness is selling followed by gender, size, price float and location to represent the three locations they are selling the t-shirts in. The end results will look like this:


CREATE TABLE T_shirts (


T_ShirtID INT(9) PRIMARY KEY,


T_ShirtType VARCHAR(15),


Gender CHAR,


Size CHAR,


Price Float(5,2),


Location VARCHAR(20));



As shown in the SQL statement, T-shirts will represent the primary key because t-shirts identify the rows in the table. INT abbreviates integer which is used for numbers that range from negative 2,147,483,647 for 9 or 10 digits of precision.


T-shirt type has avarcharafter it followed by a number. VARCHAR is a “variable character” where users can enter numbers and alphabetical letters together whereas, the number 15 represents how many characters can be used to describe the types of t-shirts.


Gender shows CHAR (stands for character where only letters of the alphabet will be used) with no character quantity as the data will only use 1 character (F) for female and (M) for male.


Same goes for the next attribute for size. It does not include character quantity as the letters S, M, and L, etc., will be used for small, medium, and large.


Price float will show the prices for each t-shirt. For example, $10.00.


Finally, the location may include a city or the store number so it will utilize both alphabetical letters and numbers.


For students that are interested in checking their SQL statements to ensure there are no errors in their statements, there is a free website that I will include in this discussion post for students to utilizehttps://en.rakko.tools/tools/36/They can also utilize SQL coding in the tutor section of our AIU tutor home page.



Friedrichsen, L., Ruffolo, L., &) Monk, E. (2020).Concepts of Database Management(10th Edition). Cengage Learning US.https://aiu.vitalsource.com/books/9780357885697



2)


I will refer to the "Pitt Fitness Case Exercise" in the assigned readings. I will first break down each Structured Query Language (SQL) command I input step by step. I will then describe how to create a new table and capture the additional requirements.


Step 1 - CREATE TABLE T-SHIRTS (


Step 2 - WomenSize TEXT (5)


Step 3 - MenSize TEXT (5),


Step 4 - WomenRetailPrice_1 TEXT (5)


Step 5 - WomenRetailPrice_2 TEXT (5)


Step 6- MensRetailPrice TEXT (5)


Step 7- )


Step 8 - ;


Figure 3-4 "Access SQL to Create a Table" provided the perfect example of how to create a table. Therefore I inputted the above SQL command beginning with Step 1. According to the assignment, we also had to capture two women's sizes, one men's size, and their retail price. To do so, I created attributes to the Table, which can be seen in steps 2-6.


Furthermore, the command "TEXT" means that words or numbers can be input followed by the number in parenthesis, representing the total characters available/allotted for the TEXT. Finally, SQL statement, or command, is completed by a closing parenthesis followed by a semicolon, which can be seen in steps 7 and 8. Although steps 7 and 8 can be combined, I separated them, making it easier for the reader and a good SQL command.


Finally, per the assignment, this is for advertisement purposes only, so no quantity on hand fields are necessary.


Reference


Friedrichsen, L., Ruffolo, L., Monk, E. (20200304). Concepts of Database Management, 10th Edition. [VitalSource Bookshelf 10.0.1]. Retrieved from vbk://9780357885697



3)


In our textbook,Concepts of Database Management, it explains that SQL (Structured Query Language) is the basic language for analyzing, selecting, and updating data in a data management system (Friedrichsen, L., Ruffolo, L., & Monk, E., 2020). The use of SQL is to manipulate the structure or pick the data needed. The first thing that needs to be done is to have a table created, and change the font for it, if need be.



Create Table T-Shirts (



Male Char(size)



Female Char 1(size)



Female Char 2(size)



Text(size)



Values(M)



Values(F1)



Values(F2)




3)


This table is about the t-shirts needed for display. The Char for both male and female are for sizes. The Text would be the logo of Pitt Fitness. This could go up to a certain byte and not characters as other SQL codes have. The Values would be the pricing of the t-shirts to be made and/or for how much they will be sold for. There is enough room on the table for all three t-shirts. This makes it easier to read and understand since there are 2 different female shirts and three t-shirts in general. This helps with a lesser chance of mistakes being made.


Keep in mind that there are many types of SQL codes, so there are going to be different outcomes depending on what is used. The main thing is if it makes sense, and the table can be read with no issues for when they are getting made. From personal experience, my Muay Thai coach got uniforms made with non-American sizes and even told the guy making them. When the delivery came, they were made in American sizes and were ten times too big. That is why it is important to make sure everything is written down correctly.


There are also different types of SQL that can be used, but that is in Chapter 3 of our textbook if more information is needed.


Resources


Friedrichsen, L., Ruffolo, L., & Monk, E. (2020). Concepts of Database Management (10th Edition). Cengage Limited. https://aiu.vitalsource.com/books/9780357885697




HI THERE KINDLY JUST ANSWER FROM THE TUTOR VIEWPOINT AND THERE ARE 3 TO ANSWER....FOR 80 WORDS EACH 1,2 AND THREE THANKS

Jan 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here