Lab $01$ Relational Model

Objectives:

The purpose of the first lab of TM$210$ is to familiarize yourself with the User Interface, SQL Developer, and the database that we will be using throughout the course to communicate with the Oracle server. By the end of this lab you should be able to:

$$ Successfully establish a connection with and login to the Oracle database server using SQL Developer

$$ Explore and work with the database and data

$$ Understandthe relationships, constraints, data types, and tables$$ specification.

Preface:

If you have not already done so$,$ you will need to download the sample database creation script from blackboard and run it$.$ These instructions are included in the Getting Started section with SQL Developer document.

LAB $01-$ SUBMISSION

Answer the following questions in the provided space. Save your file as a PDF file and name it as following:

DBS$211\_$L$01\_$LastName.sql$.$

Tasks:

By navigating through SQL Developer and looking at the Columns, Data, model, and Constraints tabs for thegiven tables. You will answer the following questions.

NOTE:In Question $($a$),$ some questions are answered as examples. You need to complete the rest. Add more rows to the tables in the document if you need more space for an answer. Use a different color for your answers.

For the given tables in your database, answer the following questions:

Part A

See the sample question:

a$)$ Answer the following Question for the DBS$211\_$PRODUCTS table.

$1)$ How many columns $($attributes$)$ are there in this table? $9$

$2)$ How many rows are there in this table? $110$

$3)$ List the table$$s columns and the requested information in the following format: