Question

Project: Creating a Database
Imagine that you work for a company that manufactures and sells sportsware. You need a good way to keep track of the products in your inventory. You also need to be able to tell customers what a particular item will cost.

Objectives
Create a database to track information for retrieval later.
Directions
Let's build a simple database. You will create a database with information about products in a catalog. Plan the database first. As you plan, keep in mind that later you will want to sort this data by product number and retrieve a list of products with a quantity of less than one hundred. You will also need to look up the price and product description.

Create the database and populate the database with ten records about any type of products. Save your database. but make it short and the grammer on and 11 yr old

Answer 1

Sure! Let's create a simple database plan for your sportsware company.

### Database Plan

1. **Table Name:** Products
2. **Columns:**
- **ProductID** (Integer): A unique number for each product.
- **ProductName** (Text): The name of the product.
- **Description** (Text): A short description of the product.
- **Price** (Decimal): The cost of the product.
- **Quantity** (Integer): How many of this product are in stock.

### Example Records

Here are ten records to fill the database:

| ProductID | ProductName | Description | Price | Quantity |
|-----------|------------------|---------------------------------|-------|----------|
| 1 | Sports Shoes | Comfortable running shoes. | 49.99 | 120 |
| 2 | Basketball | High-quality basketball. | 29.99 | 80 |
| 3 | Soccer Ball | Durable soccer ball for games. | 24.99 | 60 |
| 4 | Gym Bag | Spacious gym bag for workouts. | 19.99 | 40 |
| 5 | Yoga Mat | Non-slip mat for yoga practice. | 15.99 | 90 |
| 6 | Tennis Racket | Lightweight tennis racket. | 89.99 | 30 |
| 7 | Water Bottle | Reusable water bottle. | 12.99 | 200 |
| 8 | Baseball Glove | Soft leather baseball glove. | 34.99 | 15 |
| 9 | Cycling Helmet | Safety helmet for biking. | 39.99 | 50 |
| 10 | Swim Goggles | Anti-fog swim goggles. | 14.99 | 25 |

### Instructions to Save the Database

1. Open your database software (like Microsoft Access, MySQL, etc.).
2. Create a new database called "SportswareInventory."
3. Create a table called "Products" and add the columns mentioned above.
4. Enter the ten records in the table.
5. Save the database.

### How to Use the Database

- **Sort by ProductID:** You can sort the records by the "ProductID" column.
- **Find Low Stock:** To find products with a quantity of less than 100, you can filter the "Quantity" column.

Now you can easily keep track of your sportsware products!