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.