Answered You can hire a professional tutor to get the answer.
Need to create a table with the following columns-we are tracking properties that have been rented PropertyNum 5 maximum numeric digits (no decimal
Need to create a table with the following columns-we are tracking properties that have been rented
PropertyNum 5 maximum numeric digits (no decimal points)
Street up to 15 characters
City up to 12 characters
State 2 characters
Zip 5 characters
WeeklyRental 6 maximum numeric digits (2 decimal digits)
MonthlyRental 6 maximum numeric digits (2 decimal digits)
AgentNum 5 characters
Tentant up to 14 Characters
The table name should be your last name, plus your student number or another "unique" number (which can be John Doe 1245)
Insert the following four records into the table (ensure the format agrees with the field type)
(40011, 8215 Main St, Denver, CO, 33331, 650.75, 1200, ID102, Johnson)
(50112, 4711 Beacon St, Boston, MA, 60644, 800.50,, 1300, ID103, Brown)
(60213, 925 Myrtle Rd, Sarasota, FL, 33385, 450.50, 1100, ID103, Davis)
Include another record with different content- you determine the content, EXCEPT it must use ID103 for the AgentNum, and your last name for the Tenant
