Database

Masters
Assignment
Technology
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…

Introduction

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 papers

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…
Database Management System Assignment
This thesis provides a benchmark to assess the performance of storing binary large objects in a relational database management system.A benchmark framework that reduces development and integration costs of benchmarking the database performance of a specific application is included.A randomly generated test script is utilized to provide variation among test cases and consistency between different…
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.…
Object Relational Database
In ORDB, reusability is achieved by using the techniques of inheritance of types and polymorphism. Every record has unique identity within the object table. Here every record is termed to be active, persistent objects encapsulating both data and methods. The only way to access any data, is through the object methods.…
DATABASE MANAGEMENT SYSTEMS Essay
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.…
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…
Database
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.…