Answered step by step
Verified Expert Solution
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
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
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