Computing: Database example.

... Computing: Database example. A computer database is needed for a company to hold its customer details on. The data held will be: * Name of Company * Address (line 1) * Address (line 2) * Town * Post Code * Telephone Number * Contact name within Company * Date of last salesman visit * Amount owing at this time * Value or total amount of orders last year * Discount applied (if any - 5, 10 or 20%) The company has 2000 customers of this type. Data Types Field Type Reason Name of Company Text This data will be text as it is the name of a company. Address Line 1 Text This data will be text as it is the first line of an address. Address Line 2 Text This data will be text as it is the second line of an address. Town Text This data will be text as it is a town. Post Code Text This data will be both characters and numbers so it must be of type text. Telephone Number Text Even though a telephone number is made up

want to read more? →