Typing

ELECTRICITY.docx

DATABASE MANAGEMENT

The management of the CARICOM Electricity Cooperation would like to computerize their services in the form of a database. You are required to create the database ELECTRICITY and enter the records shown below.

FIELD NAME	DATA TYPE	DESCRIPTION	FIELD LENGTH
CID	SHORT TEXT	CUSTOMERS’ IDENTIFICATION NUMBER	3
FNAME	SHORT TEXT	CUSTOMERS’ FIRST NAME	12
LNAME	SHORT TEXT	CUSTOMERS’ LAST NAME	15
ADDRESS	SHORT TEXT	STREET ADDRESS	25
COUNTRY	SHORT TEXT	COUNTRY	10
PHONE	SHORT TEXT	TELEPHONE NUMBER	12
UNITS	NUMBER	UNITS ORDERED
COST	CURRENCY	COST PER UNIT

CUSTOMER
CID	FNAME	LNAME	ADDRESS	COUNTRY	PHONE	UNITS	COST
100	Shem	Davis	14 Midland Drive	Tortola	284-931-2315	100	$10.00
101	Peter	Alli	2 Market Street	Grenada	351-839-2342	48	$5.00
102	Tina	Allscot	1 Adman Lane	Nevis	585-908-3242	34	$1.00
103	Cilda	Anderson	12 Fairway Avenue	Nevis	585-983-3243	34	$2.00
104	Angel	Wilson	12 Gordon Terrace	Grenada	351-345-2657	43	$3.00
105	Simon	Bloom	4 A Linford Avenue	Tortola	284-763-3242	2	$4.00
106	Zelda	Blair	141 Hope Road	Tortola	284-987-6574	6	$5.00
107	Bailey	Bobb	26 Red Hills	Grenada	351-897-5766	45	$4.00
108	John	Abrah	13 Main Street	Grenada	351-324-1248	37	$3.00
109	David	Dave	11 A Lorraine Ave	Nevis	585-901-1969	23	$45.00
110	Rainy	Sam	3 Hillside Drive	Grenada	351-984-3754	92	$6.00
111	Craig	Sam	104 Waltham	Nevis	585-345-5082	48	$3.00
112	Dan	Alli	10 Derry Road	Tortola	284-748-6364	35	$6.00
113	Jack	Hill	1 Worthington Terrace	Tortola	284-894-3587	32	$10.00
114	Jason	Gally	28 Union St	Nevis	585-743-3653	64	$1.00
115	Alice	Blair	21 Third Ave	Tortola	284-924-1177	6	$2.00
116	Syd	Wilson	7 Lindale Avenue	Grenada	351-864-3459	4	$1.00
117	Nica	Nash	7 A Moreton Avenue	Grenada	351-928-7545	8	$6.00
118	Olive	Sam	Dayton	Nevis	585-865-8754	3	$4.00
119	Mary	Patmore	Parry Town	Tortola	284-938-6746	83	$3.00
120	Cleo	Bobb	7 Anderson Road	Nevis	585-987-5683	3	$2.00

Complete the following queries:

1. Make a list of all the customers who live in the country Nevis. Save as QUERY A

2. List the names of the customers who used more than 40 units of electricity. Save as QUERY B.

3. List the phone number for the customer Nica Nash. Save as QUERY C.

4. List the customers that live in the country Grenada. Save as QUERY E.

5. In which country can the address of Parry Town be found. Save as QUERY F.

6. List the customers who used less than 50 units of electricity. Save as QUERY G.

7. List the customers who live in Tortola who used more than 50 units of electricity. Save as QUERY H.

8. List the customers that used more than 50 units and who live in Grenada. Save as QUERY I.

9. List the customers whose Last Name begins with the letter B. Save as QUERY J.

10. Sort the table using a query on the field name COUNTRY in descending order. Save as QUERY K.