Typing

Cloth.docx

DATABASE 5

1. Your wardrobe is totally disorganized. You cannot find anything! You have decided to organize your clothing by creating an inventory database on the computer.

· Create a database file; name it CLOTH.

· From the completed database planning sheet indicated below for a clothing inventory, enter the FIELD NAMES, FIELD TYPES and FIELD LENGTHS on the computer.

D A T A B A S E P L A N I N G S H E E T PURPOSE OF THE DATABASE: To create a database to organize my wardrobe so I would know what I own and where it is located in my house.
DESCRIPTION	FIELD NAME	FIELD TYPE	FIELD SIZE	DECIMAL PLACES
Item number	ITEM#	Text	3
Clothing article	ITEMNAME	Text	10
Cost of article	COST	Currency		2
Colour of clothing	COLOUR	Text	6
Where clothing is located	LOCATION	Text	20

· From the data below, enter the records for some of your clothing items.

ITEM#	ITEMNAME	COST	COLOUR	LOCATION
111	Jeans	25.00	Blue	Drawer
221	Jacket	144.95	Green	Closet Hall
331	Pants	22.96	Green	Closet Bedroom
441	Sweater	44.00	Red	Drawer
551	Raincoat	33.80	Beige	Closet Hall
661	Coat	114.50	Brown	Closet Hall
771	Sneakers	42.45	White	Closet Bedroom
881	Shirt	19.00	White	Drawer
442	Sweater	22.50	White	Drawer
991	Shoes	33.40	Black	Closet Bedroom
001	Boots	155.80	Brown	Closet Hall
002	Boots	175.95	Black	Closet Hall
112	Jeans	145.00	Black	Drawer
772	Sneakers	15.00	White	Closet Bedroom
992	Shoes	25.50	Brown	Closet Bedroom
332	Pants	25.69	Blue	Closet Bedroom
443	Sweater	156.95	Green	Closet Bedroom
882	Shirt	25.00	Beige	Closet Bedroom

· Add a field to the table to record the date the items of clothing were purchased; name it PDATE.

· From the data given below, use the appropriate data type and enter the records.

ITEM#	PDATE
111	02/12/2019
112	12/12/2019
221	11/15/2019
331	05/08/2011
332	08/10/2012
441	01/11/2012
442	12/23/2012
443	08/23/2012
551	02/15/2012
661	01/19/2013
771	05/06/2013
772	05/29/2013
881	09/10/2013
882	09/25/2014
991	12/12/2014
992	03/03/2014
001	10/27/2014
002	04/16/2014

· Create a field name DDATE to show when the items would be discarded. Set the appropriate Data type, field size or format and description for the discard date field.

· From that data below, edit the records to show the DDATE (discard date):-

ITEM#	DDATE
111	02/12/2024
112	12/12/2024
221	11/15/2024
331	05/08/2025
332	08/10/2026
441	01/11/2026
442	12/23/2026
443	08/23/2026
551	02/15/2026
661	01/19/2026
771	05/06/2027
772	05/29/2027
881	09/10/2027
882	09/25/2027
991	12/12/2028
992	03/03/2028
001	10/27/2028
002	04/16/2028

COMPLETE THE FOLLOWING QUERIES:

· List all items that can be found in the Closet Bedroom. Name it BEDROOM.

· List all items that can be found in the Closet Hall. Name it HALL.

· List all items that can be found in the Drawer. Name it DRAWER.

· Sort all items by colour. Name it COLOURS.

· List all the items that are white. Name it WHITE.

· List all the items that are black. Name it BLACK.

· List all the items that are beige or brown. Name it BEIGE or BROWN.

· List all the items that are green. Name it GREEN.

· What items cost more than $100. Name it EXPENSIVE.

· What items cost less than $25 or less. Name it SALE.

Typing

DATABASE 5

D A T A B A S E P L A N I N G S H E E T

DESCRIPTION

ITEM#