logo
+1-617-874-1011 (US)
+61-7-5641-0117 (AU)
+44-117-230-1145 (UK)
Live Chat

Sample: Oracle Assignment

Question

oracle assignment

Answer

the auction house ER Diagram
Do You Want A Fresh Assignment Like This Order Now

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

Improve Your Grades with Custom Writing Help
Homework Help
Writing Help
Editing Services
Plagiarism check
Proofreading services
Research Project help
Custom writing services
scanner
E learning blogs

Disclaimer : The study tools and academic assistance/guidance through online tutoring sessions provided by AssignmentHelp.Net is to help and enable students to compete academically. The website does not provide ghostwriting services and has ZERO TOLERANCE towards misuse of the services. In case any user is found misusing our services, the user's account will be immediately terminated.