POSSIBLE HELPERS BELOW: Section 1 This section covers the practical implementati

Question

POSSIBLE HELPERS BELOW:

Section 1 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 command 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) team team ID tname rank city championships INTEGER INTEGER VARCHAR(15) INTEGER VARCHAR(20) player team_player_arena player ID pname position draft year INTEGER retire year INTEGER education VARCHAR(30) team ID INTEGER player ID INTEGER arena ID INTEGER points INTEGER INTEGER VARCHAR(30) VARCHAR(20) 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

Explanation / Answer

If you have any doubts, please give me comment...

> sqlplus / as sysdba

> SET ECHO ON

> SPOOL 2_CHEGGUSER_Lab.txt

> Execute your created table statements

> SPOOL OFF

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.