hi i am stuck on these questions of my final project the first one said to create a 5151874

Hi I am stuck on these questions of my final project the first one said to create a table using the erd scenario and the second one said to add a column to the table and alter the column constraint's but I don't understand what it wants me to do can someone please help me figure this out thank you. Also, it should be in ORACLE SQL statement

II.Table creation process: Based on the ERD provided in the accompanying case scenario:

A.Write a query to create tables, assigning a primary key and any required foreign keys and default values. In other words, create a table that utilizes the appropriate keys and default values as provided in the scenario.

B.Write an SQL statement to add a column to the table and then alter that column’s constraints.

Team Data

Teamid, teamname

1, Penguins

2, Dolphins

3, Sharks

Player Data

Playerid, firstname, lastname, Teamid, dateofbirth, social

1, Mike, Schaub, 2, 07/05/1978, 134-00-9872

2, Marci, Rogan, 2, 01/09/1985, 143-09-6793

3, Carl, Fenzila, 2, 04/25/1968, 009-87-2365

4, John, Pomeraina, 1, 02/04/1975, 128-09-6874

5, Anton, Orlovsky, 1, 09/10/2001, 234-09-9087

6, Brian, Portis, 1, 07/02/1973, 125-09-9988

7, Andrew, Jackson, 1, 06/27/2001

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now