Question: SQL ORACLE QUESTION How write a statement to add a new Credit Card for yourself (using the @@IDENTITY value for the FK Guest ID Number

SQL ORACLE QUESTION

How write a statement to add a new Credit Card for yourself (using the @@IDENTITY value for the FK Guest ID Number that was issued when you did query #1).

The GuestID number that was givien in query #1 was 1506. SQL ORACLE QUESTION How write a statement to add a new Credit

Card for yourself (using the @@IDENTITY value for the FK Guest ID

CreditCardID Guest ID CCType CCNumber CCCompany CCCardHolder CCExpiration 1500 AMEX 123456789012345 NULL Anita Proul 2018-09-30 00:00:00 Anita Proul 1500 VISA 1234567890123450 BYU 2018-11-30 00:00:00 3 3 1500 VISA 8887776665551110 NULL Anita Proul 2018-09-30 00:00:00 4 1501 MCARD 8574820349202020 NULL Ted Cowan 2018-08-31 00:00:00 5 1502 VISA 4949676734341210 NULL Greg Anderson 2018-09-30 00:00:00 6 1502 DISC 4959039448278280 NULL Greg Anderson 2018-09-30 00:00:00 7 7 1503 DISC 409395034903459 NULL 2018-05-31 00:00:00 Rob Hilton 8 8 1504 AMEX 949494949494944 Attic Circle Bradley B. Peterson 2018-01-31 00:00 00 Shawn O'Brien 2018-10-31 00:00:00 1505 AMEX 494595503953049 NULL 2018-12-31 00:00:00 Sean O'Brien 10 10 1505 AMEX 494958584949444. NULL

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!

In SQL, Using MAMP It says it thoughout each part. It is SQL. 3. Write one statement to alter the table Booking to add a column, property No, which: a is an integer representing the property No for...

NOTE: There are two types of catalog items Book and DVD. A customer can check out one item at a time. Study the ERD and answer the following questions: Identify all relationships and specify...

For Q1 - Use the 7 Principle Framework we discussed (Chp 2) and explain which principles are violated, and why? Provide appropriate reasoning. I need to write a 300 word about the seven elements...

The question is for introduction to database system with sql live. The assignmemt is due on tomorrow 12p.m. Part 1 Maintaining and redesigning an existing database Create the following schema for...

Use the 7 Principle Framework and explain which principles are violated, and why? Provide appropriate reasoning. THANKS! A man walked into a Target outside Minneapolis and demanded to see the...

Problem 1 Create your database and Images The Problem: This term the topic of your web site is rummage sales. Your client wants to put the rummage sale online! So your first task is to make a...

Part 1 Maintaining and redesigning an existing database Create the following schema for maintaining the books issued to the patrons. books ( book_id int, title varchar(20), author_last_name...

Problem 1 Create your database and Images The Problem: This term the topic of your web site is rummage sales. Your client wants to put the rummage sale online! So your first task is to make a...

ASSESSMENT TASKS - ASSIGNMENT 1 Page 2 ASSIGNMENT 1 Task Using the information contained in the Scenario below, please complete the following 6 tasks. You must complete each task for your submission...

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS Successful people did not attain their success without first overcoming challenges.------- Catherine Pulsifer FOLLOW...

Assume that Intel can be treated as the dominant firm in the market for computer chips. What three basic factors determine the elasticity of demand confronted by Intel? Explain whether increases or...

Write an assembly language program that circularly shifts rightward a value in memory a certain number of times . The number of times to shift should also be stored in memory. Example: Suppose one...

Statement of Cash Flows, Worksheet Balance sheets for Brierwold Corporation follow: Brierwold Corporation Balance Sheet Beginning Balances Ending Balances Assets: Cash $ 1 0 0 , 0 0 0 $ 1 5 0 , 0 0 0...

What value of x in below cash flow will make the annual worth from year 1 through 7 equal to 300/year if the interest rate is 10%/year. Year Cash Flow Year Cash Flow O 200 4 X 1 200 5 200 2 200 6 200...

KEY QUESTION Suppose an economys real GDP is $30,000 in year 1 and $31,200 in year

KEY QUESTION Identify and state the significance of each of the following: ( a ) WTO; ( b ) EU; ( c ) euro; ( d ) NAFTA. What commonality do they share?

KEY QUESTION What are the two characteristics of public goods? Explain the significance of each for public provision as opposed to private provision. What is the free-rider problem as it relates to...