Database - Assignment Example

Only on StudentShare

Extract of sample
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.
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)) ...Show more

Summary

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…
Author : runtearlene
Save Your Time for More Important Things
Let us write a custom assignment on your topic
"Database"
with a personal 20% discount.
Find out more

Related Essays

Object Database Management System
A database is a set of records stored in a computer in an organized way, so that a computer program is able to consult it to answer questions. For better recovery and sorting, each record is generally organized as a set of data elements. The objects retrieved in reply to queries become information that can be used to make decisions. The computer program used to control and query a database is known as a database management system.
8 pages (2000 words) Essay
Database Technology
Today, with the increasing data requirements and storage needs, the databases have gone a step further. The emergence of data warehouses or advanced databases support huge data storage needs and provide analytical capabilities to stored data. The data stored in such databases includes the past data and archives too along with the current one.
13 pages (3250 words) Essay
DATABASE MANAGEMENT SYSTEMS Essay
Though both the technologies have their own advantages, disadvantages and interoperability, there are some instances where one is proffered more than the other. Hence the current study makes an insight into the minute details of the relation between XML and RDBMS to understand their true nature of complimentary and controversy.
14 pages (3500 words) Essay
Database Design
The primary entity in the validations information model is the meter assigned to the customer, as this is a unique entity for every customer. The meter assigned to the domestic customers in the market not only provides the flexibility for the organization to effectively identify the customer and his/her consumption but also provides the ability for the company to conduct regular maintenance on the meters so as to prevent any malfunctioning and abuse of the facility provided to the customers.
14 pages (3500 words) Essay
Find out how much would it cost
to get a custom paper written by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT