Sample: Oracle Assignment

Question

Oracle Assignment Help Order Now

oracle assignment

Answer

the auction house ER Diagram

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 (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 (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 (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 (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 (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

Oracle Assignment Help | Oracle Homework Help | Oracle Sample Assignment | Oracle Assignment Sample | Sample Homework