Got a tricky question? Receive an answer from students like you! Try us!

Database - Assignment Example

Only on StudentShare
Pages 4 (1004 words)


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…

Extract of sample

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?

Related Essays

Object Database Management System
There are two most important factors that lead users to implement object database technology. Firstly, relational databases turn out to be cumbersome to use with composite data. Secondly, data is usually operated by application software written using object-oriented programming languages such as C+, Java, Delphi and C#, and the code required translating between this demonstration of the data and…
9 pages (2259 words)
Database Technology
Object oriented databases have now become very popular as they provide a greater degree of flexibility in data storage and also provide a resource efficient storage mechanism. The data storage in the object oriented databases is in the form of objects instead of storing as rows and columns.…
13 pages (3263 words)
Basically, XML document is a collection of data. Though by collection of data, XML document is said as database in other sense a mere collection of data doesn't make much difference between the other files that store data. After all, all files contain data of some sort.…
14 pages (3514 words)
Database Design
Furthermore, the information model comprises of the customer and the details of the meter including the intricate technical details as well as the maintenance schedules apart from the measurements that quantify for billing. This is necessary for the effective management of the information system and conduct regular checks on the meters in order to prevent errors in the readings leading to unwanted…
14 pages (3514 words)