Sample: Oracle Assignment

Question

Answer

Create Table (DONATION )
Now we create a table called "DONATION" that contains Three columns: Donationid, Donationtype, Donationpercent.
Here Donationid are define PRIMARY KEY.

Create Table (CUSTOMER).
We create a table called "CUSTOMER" that contains Nine columns: Customerid, Fname, Surname, Streetname, City, County, Telno, Rating, Donationid.
Here Customerid are define PRIMARY KEY.

Create Table (ITEM )
Now we create a table called "ITEM" that contains Six columns: Itemid, Itemcategory, Itemtype, Retailprice, Reserveprice, Customerid.
Here Itemid are define PRIMARY KEY and Customerid is FOREIGN KEY (points to a PRIMARY KEY in CUSTOMER table).

Create Table (CHARITY)
Now we create a table called "CHARITY" that contains Four columns: Charityid, Charitytype, CharityLocation.
Here Charityid are define PRIMARY KEY.

Create Table (AUCTION)
Now we create a table called "AUCTION" that contains Four columns: Auctionid, Auctiondate, Auctionlocation, Charityid.
Here Auctionid are define PRIMARY KEY and Charityid (points to a PRIMARY KEY in CHARITY table) is FOREIGN KEY.

Create Table (TRANSACTION)
Now we create a table called "TRANSACTION" that contains Nine columns: Transactionid, Itemid, Customerid, Auctionid, Maxbidprice, Paymenttype, ReceiptInvoice, Required, Paymentdate.
Here Transactionid are define PRIMARY KEY and Itemid(points to a PRIMARY KEY in ITEM table), Customerid(points to a PRIMARY KEY in CUSTOMER table), Auctionid(points to a PRIMARY KEY in AUCTION table) are FOREIGN KEY.