Management of CHARITY 4 AFRICA would like to add a new table called Funding that at...

Transcribed Image Text:

Management of CHARITY 4 AFRICA would like to add a new table called Funding that at present will not have any referential integrity. The organisation would like an automatically generated unique id every time a record is inserted into the new table. The attributes the table must contain for now are funding_id, funder and funding amount. Create the new table and implement a solution to automatically generate the unique ids with every new insert. In your solution provide an example of the insert statement. Explain the Oracle tool you have used to create the unique ids every time a new record is entered into the Funding table. Management of CHARITY 4 AFRICA would like to add a new table called Funding that at present will not have any referential integrity. The organisation would like an automatically generated unique id every time a record is inserted into the new table. The attributes the table must contain for now are funding_id, funder and funding amount. Create the new table and implement a solution to automatically generate the unique ids with every new insert. In your solution provide an example of the insert statement. Explain the Oracle tool you have used to create the unique ids every time a new record is entered into the Funding table.

Answer rating: 100% (QA)

To create the new Funding table with an automatically generated unique ID in Oracle you can use a co... View the full answer