Question

Please create the Order_xxxx table in CPS3740_2023F database instance with these fields: 1. oid: the order id field in your Order_xxxx table. It should be the primary key and auto increment. 2. order_datetime: the datetime when the order is placed by the customer. 3. order_qty: a positive integer. 4. cid: a foreign key reference to the primary key in CPS3740.Customers table. 5. pid: a foreign key reference to the primary key in CPS3740.Products table. 6. All values cannot be NULL, empty, O and negative.

          Please create the Order_xxxx table in CPS3740_2023F database instance with these fields:
1. oid: the order id field in your Order_xxxx table. It should be the primary key and auto increment.
2. order_datetime: the datetime when the order is placed by the customer.
3. order_qty: a positive integer.
4. cid: a foreign key reference to the primary key in CPS3740.Customers table.
5. pid: a foreign key reference to the primary key in CPS3740.Products table.
6. All values cannot be NULL, empty, O and negative.

Show more…

Please create the Orderxxxx table in CPS37402023F database instance with these fields:
1. oid: the order id field in your Orderxxxx table. It should be the primary key and auto increment.
2. orderdatetime: the datetime when the order is placed by the customer.
3. orderqty: a positive integer.
4. cid: a foreign key reference to the primary key in CPS3740.Customers table.
5. pid: a foreign key reference to the primary key in CPS3740.Products table.
6. All values cannot be NULL, empty, O and negative.

Added by Bryce M.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Supreeta N

09/19/2023

Step 1

Step 1: Connect to the CPs3740_2023F database instance. Show more…

Show all steps

lock

Thanks for your feedback!

PLEASE I NEED WITHTHIS ASAP Please create the Order_xxxx table in CPs3740_2023F database instance with these fields: 1.oid: the order id field in your Order xxxx table.It should be the primary key and auto increment. 2. order_datetime: the datetime when the order is placed by the customer. 3. order_gty: a positive integer. 4. cid: a foreign key reference to the primary key in CPS3740.Customers table 5. pid: a foreign key reference to the primary key in CPS3740.Products table. 6. All values cannot be NULL,empty,O and negative.

Play audio

Feedback

Powered by NumerAI

Supreeta N and 99 other subject AP CS educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Transcript

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later