1. What is database?
2. What is a Table in a database?
3. Which command is used to create a database?
4. What is a primary key?
5. Create a database called, GroceryShop
6. You need to write a query to Create three tables called Customers, Products and Orders in the GroceryShop. In each of the table it should have the following fields.
Customers
- CustomerId
- Name
- Address
- City
- State
- Zip
- Email address
Products
- ProductId
- Name
- Price
- Quantity in stock
- Quantity on order
Orders
- CustomerId
- Date
- ProductId
- Quantity
- Price
- Total
You need to decide the datatypes on your own whichever is suitable for each one of them.