In this phase you will be designing a table of information (in a file) that will...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Answer rating: 100% (QA)
Table Name Pitcher Name Team City Uniform Number ERA AVG Joe Yankees ... View the full answer
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these programming questions
-
A patient is being admitted to receive a high-cost medication at a dose of 1000 mg/hr for 48 hours. The medication is only available in 6-gram vials. In order to minimize waste, what is the lowest...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....
-
Write a nonrecursive function that takes the first Node in a linked list as an argument and reverses the list, returning the first Node in the result.
-
A conductor of uniform radius 1.20 cm carries a current of 3.00 A produced by an electric field of 120 V/m. What is the resistively of the material?
-
A hedge trimmer has a blade that moves back and forth with a frequency of 28 Hz. The blade motion is converted from the rotation provided by the electric motor to an oscillatory motion by means of a...
-
One can follow the developments in the chemical industry in trade magazines such as the Chemical \& Engineering News. Answer the following questions after reading the article, "Global Top 50 " for...
-
On January 31, 2019, the general ledger of Palmer Company showed the following account balances. Prepare the worksheet through the Adjusted Trial Balance section. Assume that every account has the...
-
Managers often use variance analysis in employee performance evaluations for the following two attributeseffectiveness and efficiency. Variance analysis alerts management to whether the organization...
-
Let P = (0.7, 100, 15) be a risky prospect. State 2 could be thought of as the occurrence of an accident which imposes a financial loss of 15 (figures could be thousands of euros). An insurance...
-
A firm with a return on common equity (ROCE) of 30% has financial leverage of 37.5% and a net after-tax borrowing cost of 5% on $240 million of net debt. Required: (a) What rate of return does this...
-
Home Furnishings reports inventory using the lower of cost and net realizable value (NRV). Below is information related to its year-end inventory. Inventory Furniture Quantity Unit Cost Unit NRV...
-
Create an own original 3-line argument that contains the following (please list with bullets as you see below): Premise 1 Premise 2 A conclusion The argument should be relevant to your life in some...
-
Ken and Lars formed the equal KL Partnership during the current year; Ken contributes $100,000 in cash and Lars contributes land (basis of $60,000, fair market value of $40,000) and equipment (basis...
-
On 20 January 2006, at its first meeting for the year 2006, Bank Negara Malaysia's Monetary Policy Committee (MPC) decided to leave the Overnight Policy Rate (OPR) unchanged at 3 percent. Malaysia's...
-
Suppose a criminal case has been heard at a state trial court and the defendant has been found guilty. The defendant and his legal team believe he has been wrongfully convicted and decide to appeal...
-
Consider the following the flat database table: FName LName Address California Florida New Jersey California Mark Maria John Mark John Smith Cruise Hareson Smith Hareson Course code TM366 TM366 TM112...
-
Sandcastles, Inc.s management has recently been looking at a proposal to purchase a new brick molding machine. With the new machine, the company would not have to buy bricks. The estimated useful...
-
What measures do many development groups use to assess a systems usability?
-
What is JAD? How is it better than traditional information gathering techniques? What are its weaknesses?
-
Design one sample data entry screen for a hotel registration system using the data entry guidelines provided in this chapter (Table 11-6). Support your design with arguments for each of the design...
-
Describe the process of going public using an IPO, starting with underwriter selection and proceeding through the various stages that lead to determination of an issue price.
-
Identify at least four methods by which investors and/or the entrepreneur in a new venture can harvest their investment in a new venture. Describe the costs and benefits of each, and provide a...
-
From the perspective of the entrepreneur, what are the pros and cons of an IPO as opposed to private sale of the venture to a public company in exchange for stock or cash?
Study smarter with the SolutionInn App