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.

Oracle Assignment Help | Oracle Homework Help | Oracle Sample Assignment | Oracle Assignment Sample | Sample Homework
- 24 x 7 Availability
- Plagiarism Free
- Trained and Certified Experts.
- Deadline Guaranteed
- Privacy Guaranteed
- Assignment Help Reward
- Online help for all project.
- Service for everyone
- Online Tutoring
- Free download.
- Free study help whitepapers
- Assignment Help
- Homework Help
- Writing Help
- Academic Writing Assistance
- Editing Services
- Plagiarism Checker Online
- Proofreading
- Research Writing Help
- Services