Question: This section covers the practical implementation of a database schema using DDL and SQL queries (50 points). .Login in to the Linux Oracle server and



This section covers the practical implementation of a database schema using DDL and SQL queries (50 points). .Login in to the Linux Oracle server and access the database using sqlplus (refer to Oracle Linux Server Instructions) Display the SQL commands using: SET ECHO ON .Create your homework submission log file using: SPOOL 2-FirstLastName-Lab.txt To terminate log file after working on parts A) and B) use: SPOOL OFF command A) Using the nba.sql script file provided, create the below NBA schema. (5 points). command team ID INTEGER VARCHAR(15) INTEGER VARCHARI20) city INTEGER player INTEGER VARCHAR(30) VARCHAR 20) eam ID INTECER player ID INTEGER arena ID INTEGER points INTEGER player ID position draft year INTEGER retire year INTEGER arena ID INTEGER aname VARCHAR(20) city VARCHAR(20) . The team table has a team_id primary key . The player table has a player_id primary key . The arena table has an arena_id primary key
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
