You should have 3 queries for each of the databases. One query will CREATE the t

Question

You should have 3 queries for each of the databases. One query will CREATE the table. One query will INSERT INTO the table and one will DROP the table.

Please give step by step instructions how to do this in micrsoft access

Owner city Owner state Owner postal code 25 CITY STATE POSTAL CODE CHAR CHAR CHAR CONDO UNIT Description Decimal places Nulls allowed? Type Length DECIMAL 4 DECIMAL 2 CHAR3 DECIMAL 5 Condo ID (primary key) Location number Unit number in condo CONDO IID 0 LOCATION NUM UNIT NUM 0 building SQR_FT SOR FT 0 Size of condo unit in square feet BDRMS DECIMAL 2 Number of bedrooms in condo BATHS DECIMAL 2 0 Number of bathrooms in condo Monthly condo fee Number of condo owner CONDO FEE DECIMAL 6 OWNER NUM CHAR FIGURE 3-40 Table layouts for the Solmaris Condominium Group database

Explanation / Answer

1.CREATE the table:

Query:

>Create table VACATION_UNIT(CONDOID INTEGER(4),LOCATION_NUM INTEGER(2),UNIT_NUM

char (3),SQR_FT decimal(5,0),BDRMS decimal(2,0),BATHS decimal(2,0),CONDO_FEE INTEGER(6),

OWNER_NUM char(5));

        Command to describe the layout and characteristics of the VACATIONJJNIT table:

        >Describe VACATIONJJNIT;

        2.Insertion :

>insert into VACATION_UNIT values(20,2,’A04’,1680,3,3,775,’BL720’);

3.Drop Table:

>Drop table VACATION_UNIT;

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

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