Sample: Oracle Assignment
Question
![oracle assignment oracle assignment](https://www.assignmenthelp.net/webimg/yah/images/oracle-assignment.jpg)
Answer
![the auction house ER Diagram the auction house ER Diagram](https://www.assignmenthelp.net/webimg/yah/images/the-auction-house-ER-Diagaram.jpg)
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 donation create table donation](https://www.assignmenthelp.net/webimg/yah/images/create-table-donation.jpg)
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 customer create table customer](https://www.assignmenthelp.net/webimg/yah/images/create-table-customer.jpg)
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 item create table item](https://www.assignmenthelp.net/webimg/yah/images/create-table-item.jpg)
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 charity create table charity](https://www.assignmenthelp.net/webimg/yah/images/create-table-charity.jpg)
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 auction create table auction](https://www.assignmenthelp.net/webimg/yah/images/create-table-auction.jpg)
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.
![create table transaction create table transaction](https://www.assignmenthelp.net/webimg/yah/images/create-table-transaction.jpg)
Oracle Assignment Help | Oracle Homework Help | Oracle Sample Assignment | Oracle Assignment Sample | Sample Homework