Question 1: Use this table to answer questions 1.1 and 1.2. Invoices table. INVOICE_ID | VENDOR_ID | INVOICE_NUMBER | INVOICE_DATE | INVOICE_TOTAL | PAYMENT_TOTAL | CREDIT_TOTAL | TERMS_ID 1 | 34 | QP58872 | 25-FEB-14 | 116.54 | 116.54 | 0 | 4 2 | 34 | Q545443 | 14-MAR-14 | 1083.58 | 1083.58 | 0 | 4 3 | 110 | P-0608 | 11-APR-14 | 20551.18 | 0 | 1200 | 5 4 | 110 | P-0259 | 16-APR-14 | 26881.4 | 26881.4 | 0 | 3 5 | 81 | MABO1489 | 16-APR-14 | 936.93 | 936.93 | 0 | 3 6 | 122 | 989319-497 | 17-APR-14 | 2312.2 | 0 | 0 | 4 7 | 82 | C73-24 | 17-APR-14 | 600 | 600 | 0 | 2 8 | 122 | 989319-487 | 18-APR-14 | 1927.54 | 0 | 0 | 4 9 | 122 | 989319-477 | 19-APR-14 | 2184.11 | 2184.11 | 0 | 4 10 | 122 | 989319-467 | 24-APR-14 | 2318.03 | 2318.03 | 0 | 4 11 | 122 | 989319-457 | 24-APR-14 | 3813.33 | 3813.33 | 0 | 3 12 | 122 | 989319-447 | 24-APR-14 | 3689.99 | 3689.99 | 0 | 3 13 | 122 | 989319-437 | 24-APR-14 | 2765.36 | 2765.36 | 0 | 2 14 | 122 | 989319-427 | 25-APR-14 | 2115.81 | 2115.81 | 0 | 1 15 | 121 | 97/553B | 26-APR-14 | 313.55 | 0 | 0 | 4 1.1 Write a statement that creates the table above. Add invoice_due_date and payment_date columns 1.2 Write a statement that creates the vendors table. Add 4 more rows to this table in addition to the primary key. 1.3 Insert the 15 rows as indicated on the invoices table.
Added by Julie P.
Close
Step 1
1 To create the Invoices table with the given columns and additional invoice_due_date and payment_date columns, you can use the following SQL statement: ```sql CREATE TABLE Invoices ( INVOICE_ID INT PRIMARY KEY, VENDOR_ID INT, INVOICE_NUMBER Show more…
Show all steps
Your feedback will help us improve your experience
Madhur L and 69 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
In a study about undergraduate student credit card usage, it was reported that undergraduate students have a mean credit card balance of $3173 (Sallie Mae, April 2009). This figure was an all-time high and had increased 44% over the previous five years. Assume that a current study is being conducted to determine if it can be concluded that the mean credit card balance for undergraduate students has continued to increase compared to the April 2009 report. Based on previous studies, assume a population standard deviation of 1650. Suppose you look at a random sample of 117 undergraduate students with a sample mean credit card balance of $3325.5. You wish to test the claim that the mean credit card balance is higher than it was in 2009 at the ̑́ = 0.001 level. What is the test statistic for this sample? test statistic = (Report answer accurate to 3 decimal places.) What is the p-value for this sample? p-value = (Report answer accurate to 4 decimal places.) The p-value is... less than (or equal to) ̑́ greater than ̑́ This test statistic leads to a decision to... reject the null accept the null fail to reject the null As such, the final conclusion is that... There is sufficient evidence to warrant rejection of the claim that the population mean is greater than 3173. There is not sufficient evidence to warrant rejection of the claim that the population mean is greater than 3173. The sample data support the claim that the population mean is greater than 3173. There is not sufficient sample evidence to support the claim that the population mean is greater than 3173.
Suman K.
Jessica has bought her first new car! She has an add-on interest loan (an uncommon type of simple interest loan in which all the interest is calculated up front and added to the balance at the beginning), which means that if she makes her payments as scheduled, the balance will decrease linearly. For tax purposes she needs to know what the loan balance was at the end of December (month 4) but she can only find the statements from the ends of October (month 2), November, and February. The chart below shows what she owed at the end of the months she has statements for: Month October November February Statement Number 2 3 6 Balance $13849.60 $13,610.81 $12,894.44 Use the statement numbers and the balances in Excel to determine the equation for Jessica's balance, B, as a function of which month, m, it is. Write the equation below using the correct variables. Round all values to 2 decimal places and use a comma in numbers larger than 1000. NOTE: You need to have both numbers in your model accurate to two decimal places. If Excel is rounding your numbers, try this. Right click on the number that you want Excel to show you more decimal places for. Choose "format trendline label" and for the format change "general" to "number" and it will default to showing you two decimal places. What was Jessica's balance at the end of December? What is Jessica's monthly payment on her car?
Ameer S.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD