Database Help

Just looking for instructions on how to do this step by step, if it needs broke down into more parts PLEASE let me know.

Database Implementation. Please help, due to family issues I am way behind in classes right now. I am just looking for a set of step by steps on how to do this.

Again Just looking for instructions on how to do this step by step, if it needs broke down into more parts PLEASE let me know.

Had to break the ERD into chunks as it wasn't showing up well enought for it to be seen. Part 2 has been solved and I have copied and pasted the solution from the expert at the bottom.

I have highlighted the next portion that I need help to solve.

Need help with part 3. I know it is a question that has a few steps.

3. Use these forms to enter at least two rows of data into each table. You may use data found in Assignment 2, or on the Fivver.org website. Create queries that show:

3A. For each gig, the number of ratings and average star rating.

3B. For each gig package, the price and the total money earned with it.

3C. For each client, the total number of orders placed and the total amount spent on them. (This does not include money received for work done as a freelancer.)

3D. For each freelancer, the total number of gigs completed for clients and total amount earned from them.

3E. For each gig category, the total number of orders and the total amount ($) earned/spent on them.

Expert Answer from previous portion of the question is down below.

praveenkumar answered this

2. DDL statements for the ER diagram:-

1. create table client (ordertracking varchar2(10) primary key,orderinghistory char(10),freelancerfeedback char(20));

2. create table freelancer(freelancerid int primary key,firstname varchar2(10),lastname varchar2(10),residence varchar2(10),language varchar2(10),onelinestory varchar2(20),vacationmode varchar2(10),skills varchar2(10),rating char(2),socialmedia varchar2(10),registrydate timestamp);

3. Create table user (ID varchar2(10) primary key,firstname varchar2(10),lastname varchar2(10),memberdate timestamp,userlanguage varchar2(10),usertype varchar2(10),emailid varchar2(20),password varchar2(10));

4. create table gig(gigcode int,freelancerid int,title varchar2(5),Image varchar2(10),category varchar2(10),servicedelivery timestamp,projectdescription varchar2(10),primary key(gigcode,freelancerid),foreign key(freelancerid) references freelancer(freelancerid));

5. create table communication (orderid int,communicationdatetime timestamp,message varchar2(10),attachment varchar2(10),orderid1 int,ordertracking varchar2(10),freelancerid int, primary key(ordertracking,freelancerid,orderid),foreign key(ordertracking) references client(ordertracking),foreign key(freelancerid) references freelancer(freelancerid));

6. create table order (orderid int,ordertype varchar2(10),odate date,otime time,ordertotal int,status varchar2(10),deliverytime timestamp,ordertracking varchar2(10),primary key(orderid,ordertracking),foreign key(ordertracking) references client(ordertracking));

7. create table transaction ( transactiondate timestamp,amount int primary key,paymentmethod varchar2(10),remainingbalance int,orderid int,ordertracking varchar2(10),primary key(amount,orderid,ordertracking),foreign key(ordertracking) references client(ordertracking),foreign key(orderid) references order(orderid));

First Name Laat Nune MemberDae User Larguage ARCHAR Enal ID Frocianeer Foodbosk TEXT Ordering Hiszory Order Tracking On Line Stery VARCHAR Social Meda Transaction Tranescion Date Paymant Mcthod Order Trac ARCHAR Transacton PK (Amount, Ordeno, Order Ode Tracking Freelance Order Type Order Totzl Projeet Deacription VARCHAR De very ie Datstime Order D Order PK (OrderD, Order Tracking) First Name Laat Nune MemberDae User Larguage ARCHAR Enal ID Frocianeer Foodbosk TEXT Ordering Hiszory Order Tracking On Line Stery VARCHAR Social Meda Transaction Tranescion Date Paymant Mcthod Order Trac ARCHAR Transacton PK (Amount, Ordeno, Order Ode Tracking Freelance Order Type Order Totzl Projeet Deacription VARCHAR De very ie Datstime Order D Order PK (OrderD, Order Tracking)