Favorr

Favorr

Group Members:

Prajwal Shetty

Rodolfo Zolezzi

Tejasvi Ramadas Sagar

Vinod Premkumar

Table of Contents

1.              Company Background

2.              Database Scope

3.              Table Description

4.              Entity-Relationship Diagram

5.              Relational Database Scheme

6.              Data Input Screens

7.              Sample Reports Screens

8.              Menu Screens

1.    Company background

Favorr is an online service website that allows members to offer and/or purchase online services at their own specified cost. Each service is called a “Job”. Jobs are offered on our website which include web application development, graphic design, video and animation, programing, advertising, music and many more services that are capable of being finished online. Our site will be primarily used by freelancers who will use our company to offer services to customers worldwide. Our service allows a user to list or purchase a job online. The jobs listed are diverse and range from “silly graphics” to complex database design using a programing language.

            In order for favor to better serve our customers more efficiently we must manage our customers’ orders more efficiently. The current method is unreliable and prone to error. By restructuring our database using Microsoft access, we believe that this would reduce errors, and become more efficient and this will allow us to expand accordingly.

2. Database Scope

            Favorrs database has eight tables which will be explained below. The main function of the database is to manage our buyer’s/seller’s transactions. When encountering our website, you will be prompted to create an account. Once your account is created you will have access to the buyer/seller functions. The buyer/seller will be able to sell “jobs” and buy them. Therefore, once our customer has set up their account at 100% we will have their payment information, rating, and jobs they have bought or created in our database.

3.Table Description

User Table

The User Table contains the Personal Information regarding app members and includes the following Attributes

●      User Id (Primary Key)

●      First Name

●      Last Name

●      Phone

●      Email Address

●      Address

●      City

●      State

Service Category

The Category Table contains information about the types of categories of services and information about the requestor. The table includes following Attributes

●      Service_ID (Primary Key)

●      Service Type

●      Requestor_ID

Sub Category

The Sub Category Table contains information regarding the specific service and has the following attributes

●      Subcategory Id (Primary Key)

●      Subcategory Type

●      Price

●      Description

●      Service_ID (Foreign Key referencing the Service Category Table)

ORDER

The Order Table contains information regarding orders placed by members and includes the following attributes

●      Order_ Id (Primary Key)

●      Order date

●      Order Status

●      Subcategory_Id(Foreign Key referencing the Subcategory Table)

●      Provider_Id (Foreign Key referencing the Seller Table)

●      Requirement_ID (Foreign Key referencing the Requirement Table)

REQUIREMENTS

Tis table contains information about any pre-requisites necessary for placing a service order. It contains one attribute

·       Requirement_ID

PAYMENT

The Payment Table contains payment information for orders placed by members.

●      Payment_Id (Primary Key)

●      Price

●      Payment Type

●      Order_ID (Foreign Key referencing the Order Table)

RATING

The Rating Table contain information about service ratings and also reviews posted by members about a service.

·       Rating_ID

·       Review

·       Payment_ID (Foreign Key referencing the Payment Table)

4.Entity-Relationship Diagram

5.Relational Database Schema

CREATE TABLE User

(User_Id varchar(20)  NOT NULL ,

 First Name varchar(20)  NOT NULL ,

 Last Name varchar(20)  NULL ,

 Phone integer  NULL ,

 Email varchar(20)  NULL ,

 Address varchar(50)  NULL

 City varchar(20)  NULL

 State varchar(20)  NULL

 Primary key (User_Id))

CREATE TABLE Order

(Order_Id integer  NOT NULL ,

 Order_Date datetime  NULL ,

 ETD datetime  NULL ,

 SubCategory_Id varchar(20)  NULL ,

 Provider_Id varchar(20)  NULL

 Primary key (Order_Id)

 Foreign key (Provider_Id)

 Foreign key (Subcategory_Id))

CREATE TABLE Rating

(Ratings integer  NULL ,

 Review varchar(20)  NOT NULL ,

 Payment_Id varchar(20)  NULL)

 Foreign key (Payment_Id))

CREATE TABLE Payment

(Payment_Id varchar(20)  NOT NULL ,

 Price integer  NULL ,

 Shipping_Charge integer  NULL ,

 Order_Id integer  NULL

 Primary key (Payment_Id)

 Foreign key (Order_Id))

CREATE TABLE Service_Category

(Service_Id varchar(20)  NOT NULL ,

 Service_type varchar(20)  NULL ,

 Service_Description varchar(20)  NULL ,

 Requestor_Id varchar(20)  NOT NULL

 Primary key (Service_Id)

 Foreign key (Requestor_Id))

CREATE TABLE Subcategory

(SubCategory_Id varchar(20)  NOT NULL ,

 Subcategory_Type varchar(20)  NULL ,

 Price integer  NULL ,

 Description varchar(20)  NULL ,

 Service_Id varchar(20)  NULL

 Primary key (Subcategory_Id)

 Foreign key (Service_Id))

6.Data Input Screens

7.Sample Reports Screens

8.Menu Screens