Pages 4 (1004 words)
Download 0
Consider the following requirements for the maintenance of computer hardware in an organisation. Each significant piece of computer hardware, such as a server or a printer, is known as an asset, with a unique asset number. For each asset the product name, such as the HP X1 Turbo, its location and the asset's lease renewal date have to be recorded.


Inspectors have a unique inspector number, and the details of their name and position are held on record. Products are identified by their name and records of the product type and a description of the product are kept.
Primary key attributes are indicated with {pk}. N.B. All dates are stored in the format number(6) to represent YYMMDD, i.e. the date 16th June 2005 will be stored as 050616. Selling_price is stored in the format number (4, 2). Quantities are stored in the format number (4). All other attributes are stored as char (). The order_total is the total value of the order. The qty_ordered is the quantity of a particular product ordered. Soil_type refers to the favoured growing conditions of the plant, e.g. 'sandy soil'. Specify the following queries in SQL:
Primary key attributes are indicated with {pk}. Notes - final_position is a numeric attribute that indicates where the dog was placed in the show, i.e. 1 = 1st place. Specify the following queries in relational algebra:
PROJECTDog.Dog_name, Dog.KC_reg_no, Entry.Show_name, Entry.Year, Entry.final_position (SELECT Entry.Show_name = 'Top Dog' and Entry.Year=2002 and Entry.Year =2003 group by Entry.final_position (Dog X Entry))
Download paper
Not exactly what you need?