Explore BrainMass
Share

Explore BrainMass

    Create Table Statement

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    NOTE: You do NOT need to run/execute the script.

    Create a new table to be housed in the USERS01 tablespace. The table name will be PRECIOUS_METAL_PRICE and it will be used to store a history of the price of various precious metals. New rows are added to the table on a one-every-two-hours ratio. The table needs to have a relationship back to a parent table named METALS, which lists various precious metals like Gold, Silver, Zinc, etc. The table has a four-byte primary key ID number (METAL_ID) and a description of the metal. As you write the CREATE TABLE statement for this new table, you need to address the following points: The columns are named PRICE, PRICE_DATETIME, and TIME_BETWEEN. The following offers some additional direction on how the table should be created.
    • The PRICE can contain fractions of a penny down to thousandths of a penny, but the whole price will always be under 1000 dollars. A column named TIME_BETWEEN will store the number of days (up to 99 days), hours, minutes, and seconds (to the hundredth of a second) between the current record and the previous record. The table is never updated; only new data is inserted. Therefore, you want to minimize the storage space saved for updates.

    • Taking an average row length as 24 bytes, and an average of 12 inserted records per day, you want the table to be created with enough storage space for approximately 6 months; but at the same time, you do not want to waste unused space (try to be as exact as you can).

    © BrainMass Inc. brainmass.com October 9, 2019, 11:40 pm ad1c9bdddf
    https://brainmass.com/computer-science/data/create-table-statement-264041

    Attachments

    Solution Preview

    NOTE: You do NOT need to run/execute the script.

    Create a new table to be housed in the USERS01 tablespace. The table name will be PRECIOUS_METAL_PRICE and it will be used to store a history of the price of various precious metals. New rows are added to the table on a one-every-two-hours ratio. The table needs to have a relationship back to a parent table named METALS, which lists various precious metals like Gold, Silver, Zinc, ...

    Solution Summary

    The expert creates table statements.

    $2.19