Question
You are the owner of Veronicas Teddy Bear store Create a new database called Teddy Bear Create a Products table include such fields as Item
You are the owner of Veronicas Teddy Bear store
Create a new database called Teddy Bear
Create a Products table include such fields as Item description, cost, and Product ID
The cost field should be formatted as Currency
Add at least 6 products into the table
Create a Customers database and include such fields as Customer ID, Name, Address, Phone. Make First Name and Last Name required fields
Add at least 10 customers into the table
Create an Orders table. Include such fields as Order date, Date Shipped, Quantity, Customer ID and ProductID
Set the data type of both the Customer and Product fields to number.
Enter at least 5 orders into your Orders table using a different customer for each order
You are the owner of Veronicas Teddy Bear store Create a new database called Teddy Bear
Create a Products table include such fields as Item description, cost, and Product ID The cost field should be formatted as Currency Add at least 6 products into the table
Create a Customers database and include such fields as Customer ID, Name, Address, Phone. Make First Name and Last Name required fields Add at least 10 customers into the table
Create an Orders table. Include such fields as Order date, Date Shipped, Quantity, Customer ID and ProductID Set the data type of both the Customer and Product fields to number. Enter at least 5 orders into your Orders table using a different customer for each order
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started