Typing
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.