Database Design Questions



1) a) A feild is a single data item

b) Getting information from a database is called a query

c) a flat file is the simplest type of database

d) a record is a collection of facts about one specific entry

e) a DBMS is used to build, maintain and provide access to a database

f) a query is a method of creating a listing of selected data

g) Replacing out of date information with new information is called updating.

2) i) Name, ID, Address, Surname, Date of birth, Mobile, Home ph, Middle name, previous employment

ii)

B) i) Name, ID, Address, price, estimated price, sale price, owner, agent, land value

ii)

c) i) Report – First Name = Barbra

ii) Report – Selling price > 100,000

iii) Report – selling price< 100,000 + number bedrooms = 3

iv) surnames = ‘M’

v) Suburb = ‘Freemantle’ DOB < 1/1/1952