Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Assignment To successfully complete this activity, you must demonstrate your ability to generate the SQL statements, which will complete each of the tasks listed in parts 1 and 2 below. Test each of the statements within your course database space (phpMyAdmin). Upload a copy of the SQL used to create the tables and queries and the results to Blackboard.

Assignment To successfully complete this activity, you must demonstrate your ability to generate the SQL statements, which will complete each of the tasks listed in parts 1 and 2 below. Test each of the statements within your course database space (phpMyAdmin). Upload a copy of the SQL used to create the tables and queries and the results to Blackboard.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
100%

I Am struggling with this. Can someone please help me?

Bb Week 12: 11/9 - 11/15 – IS 381 A X Bb Creating Tables and Queries Usin X C Search Textbook Solutions | Chec X b Search results for 'Task 1. Using + A https://blackboard.chowan.edu/bbcswebdav/pid-384225-dt-content-rid-2317504_1/courses/22917/Creating%20Tables%20and%20Queries%20Using... of 4 A) Read aloud V Draw F Highlight O Erase 1 Assignment To successfully complete this activity, you must demonstrate your ability to generate the SQL statements, which will complete each of the tasks listed in parts 1 and 2 below. Test each of the statements within your course database space (phpMyAdmin). Upload a copy of the SQL used to create the tables and queries and the results to Blackboard. PART 1- CREATING THE DATABASE TABLES Task 1 Create a table with the following schema: Table: TEAM Length Туре INTEGER Column TEAMID 4 VARCHAR CITY STATE 25 CHARACTER 2 40 OWNER STADIUM TEAMNAME VARCHAR VARCHAR VARCHAR 40 40 The SQL statement used to create this table should also include the following constraints: The primary Key should be TEAMID Every attribute has a "NOT NULL" value, except for OWNER and STADIUM, which can both contain NULL Values. Martin_Ryan_S21.PNG Show all Open file 3:14 PM O Type here to search 11/22/2020
Transcribed Image Text:Bb Week 12: 11/9 - 11/15 – IS 381 A X Bb Creating Tables and Queries Usin X C Search Textbook Solutions | Chec X b Search results for 'Task 1. Using + A https://blackboard.chowan.edu/bbcswebdav/pid-384225-dt-content-rid-2317504_1/courses/22917/Creating%20Tables%20and%20Queries%20Using... of 4 A) Read aloud V Draw F Highlight O Erase 1 Assignment To successfully complete this activity, you must demonstrate your ability to generate the SQL statements, which will complete each of the tasks listed in parts 1 and 2 below. Test each of the statements within your course database space (phpMyAdmin). Upload a copy of the SQL used to create the tables and queries and the results to Blackboard. PART 1- CREATING THE DATABASE TABLES Task 1 Create a table with the following schema: Table: TEAM Length Туре INTEGER Column TEAMID 4 VARCHAR CITY STATE 25 CHARACTER 2 40 OWNER STADIUM TEAMNAME VARCHAR VARCHAR VARCHAR 40 40 The SQL statement used to create this table should also include the following constraints: The primary Key should be TEAMID Every attribute has a "NOT NULL" value, except for OWNER and STADIUM, which can both contain NULL Values. Martin_Ryan_S21.PNG Show all Open file 3:14 PM O Type here to search 11/22/2020
Bb Week 12: 11/9 - 11/15 – IS 381 A X Bb Creating Tables and Queries Usin X C Search Textbook Solutions | Chec X b Search results for 'Task 1. Using + A https://blackboard.chowan.edu/bbcswebdav/pid-384225-dt-content-rid-2317504_1/courses/22917/Creating%20Tables%20and%20Queries%20Using... of 4 --| A' Read aloud V Draw F Highlight O Erase 2 The primary Key should be TEAMID Every attribute has a “NOT NULL" value, except for OWNER and STADIUM, which can both contain NULL Values. Page 2 Task 2 Create a second table, named “PLAYERS", with the following schema: Table: PLAYERS Column Туре Length The SQL statement used to create this table should also include the PLAYERID INTEGER following constraints: TEAMID INTEGER 4 PLAYERID is the primary key FNAME VARCHAR 25 LNAME VARCHAR 40 The TEAMID in the PLAYERS table should be the foreign Key to JERSEYNUMBER SMALLINT 2 TEAMID from the TEAM table SALARY DECIMAL 5 Every attribute has a “NOT NULL" value except JERSEYNUMBER, which can contain NULL values Part 2: Using SQL to Query a Database Your ability to successfully create database applications will rely heavily on your ability to retrieve data from one or more tables within a database. The purpose of this activity is to test your ability to create queries using the structured query language, SQL. Throughout this assignment, you will be asked to populate a database and generate a series of SQL statements that pull information from it. Martin_Ryan_S21.PNG Show all Open file 3:15 PM O Type here to search 11/22/2020
Transcribed Image Text:Bb Week 12: 11/9 - 11/15 – IS 381 A X Bb Creating Tables and Queries Usin X C Search Textbook Solutions | Chec X b Search results for 'Task 1. Using + A https://blackboard.chowan.edu/bbcswebdav/pid-384225-dt-content-rid-2317504_1/courses/22917/Creating%20Tables%20and%20Queries%20Using... of 4 --| A' Read aloud V Draw F Highlight O Erase 2 The primary Key should be TEAMID Every attribute has a “NOT NULL" value, except for OWNER and STADIUM, which can both contain NULL Values. Page 2 Task 2 Create a second table, named “PLAYERS", with the following schema: Table: PLAYERS Column Туре Length The SQL statement used to create this table should also include the PLAYERID INTEGER following constraints: TEAMID INTEGER 4 PLAYERID is the primary key FNAME VARCHAR 25 LNAME VARCHAR 40 The TEAMID in the PLAYERS table should be the foreign Key to JERSEYNUMBER SMALLINT 2 TEAMID from the TEAM table SALARY DECIMAL 5 Every attribute has a “NOT NULL" value except JERSEYNUMBER, which can contain NULL values Part 2: Using SQL to Query a Database Your ability to successfully create database applications will rely heavily on your ability to retrieve data from one or more tables within a database. The purpose of this activity is to test your ability to create queries using the structured query language, SQL. Throughout this assignment, you will be asked to populate a database and generate a series of SQL statements that pull information from it. Martin_Ryan_S21.PNG Show all Open file 3:15 PM O Type here to search 11/22/2020
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Troubleshooting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS