Field Туре Null Key Default Extra OFFICE_NUM decimal(2,0) NO PRI NULL ADDRESS char(25) NO PRI NULL BDRMS decimal(2,0) YES NULL FLOORS decimal(2,0) YES NULL MONTHLY_RENT decimal(6,2) YES NULL OWNER_NUM...



Task 1: Create a LARGE_PROPERTY table with the structure shown below.



Field<br>Туре<br>Null<br>Key<br>Default<br>Extra<br>OFFICE_NUM<br>decimal(2,0)<br>NO<br>PRI<br>NULL<br>ADDRESS<br>char(25)<br>NO<br>PRI<br>NULL<br>BDRMS<br>decimal(2,0)<br>YES<br>NULL<br>FLOORS<br>decimal(2,0)<br>YES<br>NULL<br>MONTHLY_RENT<br>decimal(6,2)<br>YES<br>NULL<br>OWNER_NUM<br>char(5)<br>YES<br>NULL<br>

Extracted text: Field Туре Null Key Default Extra OFFICE_NUM decimal(2,0) NO PRI NULL ADDRESS char(25) NO PRI NULL BDRMS decimal(2,0) YES NULL FLOORS decimal(2,0) YES NULL MONTHLY_RENT decimal(6,2) YES NULL OWNER_NUM char(5) YES NULL

Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here