POSSIBLE HELPER BELOW: - MAY OR MAY NOT NEED Section 1 This section covers the p

Question

POSSIBLE HELPER BELOW: - MAY OR MAY NOT NEED

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

login as: sqlplus / as sysdba

SET ECHO ON

SPOOL 2-ANUNAGA-Lab.txt

//run your sql

SPOOL OFF

Let me know if you have any clarifications. Thank you...

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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