Question: ANSWER ASAP PLEASE Complete the following two questions: a. Determine the Primary key in the following table. (2 marks) Orderltem Order Number Product Number Qty

ANSWER ASAP PLEASE Complete the following two questions: a. Determine the

ANSWER ASAP PLEASE

Complete the following two questions: a. Determine the Primary key in the following table. (2 marks) Orderltem Order Number Product Number Qty 27 PO1 5 45 PO4 8 8 27 PO2 10 56 PO4 4 b. What are the appropriate data types that can be used for the following fields? (4 marks) i. Order Status (placed, cancelled, processed etc.) ii. Title iii. expiry Date iv. ApprovalDate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

I need the answers to section IV on Walmart and Target ACCT 6305/SYSM 6337 Pre-Skilling Fall 2016 Table of contents Table of contents I. Basics of Financial Accounting...

Please help ASAP 2. Which of the following is the correct syntax for a value list? O'Option 15,"Option 2', 'Option 3 "Option 1";"Option 2":"Option 3" "Option 1":"Option 2":"Option 3" 21 3. To create...

Please complete the following reports for "kohl's 2017 financial statement" note that the suggested reports have numbers filled in but they do not relate. (Ignore where it says JCPenney on top of the...

Below are the questions for the case study and I need your help. Please complete the following questions from Forge Group Ltd Case Study (A)The Revealing Nature of Numbers (attached to this posting)...

Case: VLOFIX - Save Time. Ride More Davide Xausa, Boris Martin and Chris Guillemet stood in front of the bright red Mercedes Sprinter van (see Appendix 1 for photos of the van and related marketing...

Highlight the correct answer for the questions in the attachment. 1 Marks: 1 A sole proprietor is ________. Choose one answer. a. a shareholder in an S-Corporation. b. one or more individuals who are...

Learning Outcomes define the valuation and reporting of current liabilities, estimated liabilities, and other contingencies. interpret company solvency through selection and application of...

The daily milk production of cows is approximately normally distributed with a mean of 35 kg per day and has a standard deviation of 6 kg per day. 95% of cows will produce between _____ and _____ kg...

ales Tax Transactions Journalize the entries to record the following selected transactions: a. Sold $22,600 of merchandise on account, subject to a sales tax of 5%. The cost of the merchandise sold...

Ethical Issues The following statements have appeared in online news site editorials: 1. Business students come from all segments of society. If they have not been taught ethics by their families and...

Java Project Concepts Tested in this Program:Event-Driven Programming and Animations JavaFX Platform Design GUI (Graphic User Interface) using JavaFX framework Program: Racing Car Complete Java...