Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your top menu (and the tasks you are asked to implement) includes the following: 1. 2. 3. 4. 5. 6. 7. add a customer add

image text in transcribedimage text in transcribed

Your top menu (and the tasks you are asked to implement) includes the following: 1. 2. 3. 4. 5. 6. 7. add a customer add an order remove an order ship an order print pending orders with customer information restock parts exit You'll receive 10 points for correct implementation of each of the above items 1-6. Keep in mind the following when you write your code: User will be promoted to enter the necessary info, one field at a name. All IDs except CustomerlD are automatically generated. (e.g. the biggest existing number+ 1). Most attribute values are required (NOT NULL). When add an order: o Add to both ORDERS and ORDER_DETAILS. o Pay attention to the foreign key constraints on CustomerlD, EmployeelD, ShipVia, Your top menu (and the tasks you are asked to implement) includes the following: 1. 2. 3. 4. 5. 6. 7. add a customer add an order remove an order ship an order print pending orders with customer information restock parts exit You'll receive 10 points for correct implementation of each of the above items 1-6. Keep in mind the following when you write your code: User will be promoted to enter the necessary info, one field at a name. All IDs except CustomerlD are automatically generated. (e.g. the biggest existing number+ 1). Most attribute values are required (NOT NULL). When add an order: o Add to both ORDERS and ORDER_DETAILS. o Pay attention to the foreign key constraints on CustomerlD, EmployeelD, ShipVia

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And Implementation

Authors: Edward Sciore

2nd Edition

3030338355, 978-3030338350

More Books

Students also viewed these Databases questions