In this phase you will be designing a table of information (in a file) that will...

Transcribed Image Text:

In this phase you will be designing a table of information (in a file) that will be created later in your database application. Your table must have a minimum of 6 rows of data with 6 attributes (columns/fields). Step 1: Gather information to store in the table. There are many free datasets from which you can get real data. Draw from your own interests. Open Datasets: kaggle.com Step 2: Identify the primary key. Design the table so that 1 attribute or a combination of attributes create a key which uniquely identifies any record (row) of data in the table. More on keys: SQL PRIMARY KEY Constraint Table Name: Pitcher Name Joe Joe Lee Joe Kyle Joe Team Yankees Yankees Mets Mets Phillies Phillies City NY NY NY NY UniformNumber 12 13 12 13 Philadelphia 12 Philadelphia 13 ERA 3.25 2.25 2.25 3.25 3.25 1.25 AVG .200 .200 .225 250 .200 .250 Using the table above you can see that Name can not be the primary key, since two or more pitchers have the same name. Is Team a good key? How about Uniform Number? City? What attribute(s) would make for a good primary key? For this table we will use a combination of Team and UniformNumber since no 2 pitchers (rows of data) on the same team have the same uniform number. Every row can be uniquely identified by the Team and UniformNumber: Team: Yankees and Uniform Number: 12 is the 1st row. Team: Yankees and UniformNumber: 13 is the 2nd row. Team: Mets and Uniform Number: 12 is the 3rd row. Team: Mets and Uniform Number: 13 is the 4th row. Team: Phillies and UniformNumber: 12 is the 5th row. Team: Phillies and UniformNumber: 13 is the 6th row. Your submission must include: 1. A visual representation of the table (May use Google Docs Insert Table option) 2. Table name 3. 6+ rows of real data 4. Primary key(s) highlighted in red 5. A description of the primary key(s) and why you chose it 6. A description of the 6 attributes (columns) and their data types Include a state what you would like to learn by analyzing the data. For example, using the Pitcher data I want to know the average ERA of all the pitchers. Use citations. In this phase you will be designing a table of information (in a file) that will be created later in your database application. Your table must have a minimum of 6 rows of data with 6 attributes (columns/fields). Step 1: Gather information to store in the table. There are many free datasets from which you can get real data. Draw from your own interests. Open Datasets: kaggle.com Step 2: Identify the primary key. Design the table so that 1 attribute or a combination of attributes create a key which uniquely identifies any record (row) of data in the table. More on keys: SQL PRIMARY KEY Constraint Table Name: Pitcher Name Joe Joe Lee Joe Kyle Joe Team Yankees Yankees Mets Mets Phillies Phillies City NY NY NY NY UniformNumber 12 13 12 13 Philadelphia 12 Philadelphia 13 ERA 3.25 2.25 2.25 3.25 3.25 1.25 AVG .200 .200 .225 250 .200 .250 Using the table above you can see that Name can not be the primary key, since two or more pitchers have the same name. Is Team a good key? How about Uniform Number? City? What attribute(s) would make for a good primary key? For this table we will use a combination of Team and UniformNumber since no 2 pitchers (rows of data) on the same team have the same uniform number. Every row can be uniquely identified by the Team and UniformNumber: Team: Yankees and Uniform Number: 12 is the 1st row. Team: Yankees and UniformNumber: 13 is the 2nd row. Team: Mets and Uniform Number: 12 is the 3rd row. Team: Mets and Uniform Number: 13 is the 4th row. Team: Phillies and UniformNumber: 12 is the 5th row. Team: Phillies and UniformNumber: 13 is the 6th row. Your submission must include: 1. A visual representation of the table (May use Google Docs Insert Table option) 2. Table name 3. 6+ rows of real data 4. Primary key(s) highlighted in red 5. A description of the primary key(s) and why you chose it 6. A description of the 6 attributes (columns) and their data types Include a state what you would like to learn by analyzing the data. For example, using the Pitcher data I want to know the average ERA of all the pitchers. Use citations.

Answer rating: 100% (QA)

Table Name Pitcher Name Team City Uniform Number ERA AVG Joe Yankees ... View the full answer