Table Name: SUPPLIERS (.5) FIELD NAME DATA TYPE CONSTRAINT DESCRIPTION SID NUMBER(5) PRIMARY KEY Supplier ID SNAME VARCHAR2(30) NOT NULL Supplier Name STYPE VARCHAR2(30) WS, DS Supplier Type LOCATION...

FIELD NAME

DATA TYPE

CONSTRAINT

DESCRIPTION

SID

NUMBER(5)

PRIMARY KEY

Supplier ID

SNAME

VARCHAR2(30)

NOT NULL

Supplier Name

STYPE

VARCHAR2(30)

WS, DS

Supplier Type

LOCATION

VARCHAR2(30)

Location

FIELD NAME

DATA TYPE

CONSTRAINT

DESCRIPTION

PID

NUMBER (5)

PRIMARY KEY

Product ID

DESC

VARCHAR2(30)

NOT NULL

Description

PRICE

NUMBER(5)

Price

SID

NUMBER(5)

FOREIGN KEY

Supplier ID

SID

SNAME

STYPE

LOCATION

1

Lulu

DS

Salalah

2

C4

DS

Saadah

3

Smile

WS

Awqad

PID

DESC

PRICE

SID

QTY

801

Pencil

3

1

10

802

A4

6

2

15

803

Ballpen

4

2

804

Marker

2

3

20