Add the following record to the VAC unit number: A04; square feet: 1680; bedroom

Question

Add the following record to the VAC unit number: A04; square feet: 1680; bedrooms: 3; bathrooms: 3; condo fee: 775 owner number: BL720. Display the contents of the VACATION UNIT table. 2. TION UNIT table: condo ID: 20; location number: 2; 3. Delete the VACATION_UNIT table. 4. Run the script file for the Solmaris Condominium Group database to create the five tables and add records to the tables. Be sure to select the script file for the particular DBMS that you are using (Oracle, SQL Server, or Access). (Note: If you do not have the script files for this text, ask your instructor for assistance.) Confirm that you have created the tables correctly by describing each table and compar- ing the results to Figure 3-40 5.

Explanation / Answer

2. Adding record into VACATION_UNIT table:

INSERT INTO VACATION_UNIT (CONDO_ID, LOCATION_NUM, UNIT_NUM, SQR_FT, BDRMS, BATHS, CONDO_FEE, OWNER_NUM) VALUES (20, 2, "A04", 1680, 3, 3, 775, "BL720");

To display contents:

SELECT * FROM VACATION_UNIT;

3. To delete VACATION_UNIT table:

DROP TABLE VACATION_UNIT;

4.Creating Tables

LOCATION TABLE:

CREATE TABLE LOCATION (LOCATION_NUM DECIMAL(2,0) NOT NULL, LOCATION_NAME CHAR(25), ADDRESS CHAR(25), CITY CHAR(25), STATE CHAR(2), POSTAL_CODE CHAR(5));

OWNER TABLE:

CREATE TABLE OWNER (OWNER_NUM CHAR(5) NOT NULL, LAST_NMAE CHAR(25), FIRST_NAME CHAR(25), ADDRESS CHAR(25), CITY CHAR(25), STATE CHAR(2), POSTAL_CODE CHAR(5));

CONDO_UNIT:

CREATE TABLE CONDO_UNIT (CONDO_ID DECIMAL(4,0) NOT NULL, LOCATION_NUM DECIMAL(2,0), UNIT_NUM CHAR(3), SQR_FT DECIMAL(5,0), BDRMS DECIMAL(2,0), CONDO_FEE DECIMAL(6,2), OWNER_NUM CHAR(5));

SERVICE_CATAGORY TABLE:

CREATE TABLE SERVICE_CATEGORY (CATEGORY_NUM DECIMAL(4,0) NOT NULL, CATEGORY_DESCRIPTION CHAR(35));

SERVICE_REQUEST TABLE:

CREATE TABLE SERVICE_REQUEST (SERVICE_ID DECIMAL (4,0) NOT NULL, CONDO_ID DECIMAL(4,0), CATEGORY_NUM DECIMAL(4,0), DESCRIPTION CHAR(255), STATUS CHAR(255), EST_HOURS DECIMAL(4,2), SPENT_HOURS DECIMAL(4,2), NEXT_SERVICE_DATE DATE);

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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