Manage orders New order

SQL assignment

Order now Get a quote
  • Home
  • Computer Science
  • SQL assignment

Use this script for the assignment.

Please follow instructions as to what to turn in.

Haven’t Found The Relevant Content? Hire a Subject Expert to Help You With
SQL assignment
Post Your Own Question And Get A Custom Answer
Hire Writer

USE MYSQL ONLY. 

# orderentrydbScript.sql

#  REV 3 Updated 05/15/2017 Added employee comm pct to employee name Theresa Beck

# Script to build the Order Entry Database

# Creates tables and inserts data for this assignment

# into an already open database.

#

# Drop database if exists for a clean copy

Drop database if exists orderentrydb;

# Assumes student has created a database and activated it.

# Create Database before you begin to populate data

Create Database orderentrydb;

Use orderentrydb;

# Remove tables if they already exist

# Useful if it’s not your first time trying this script

DROP TABLE if exists ordline ;

Drop TABLE if exists OrderTBL ;

DROP TABLE if exists Customer ;

DROP TABLE if exists Employee ;

DROP TABLE if exists Product ;

# Create the Product Table

CREATE TABLE Product

( ProdNo         CHAR(8),

  ProdName VARCHAR(50)  NOT NULL,

ProdMfg         varchar(20)  NOT NULL,

ProdQOH         decimal(10,2),

ProdPrice        DECIMAL(12,2),

        ProdNextShipDate DATE,

  PRIMARY KEY (ProdNo)  );

# Put data into the Product Table

INSERT INTO product

(ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)

VALUES (‘P0036566′,’17 inch Color Monitor’,’ColorMeg, Inc.’,12,’2007-02-20′,169.00); 

INSERT INTO product

(ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)

VALUES (‘P0036577′,’19 inch Color Monitor’,’ColorMeg, Inc.’,10,’2007-02-20′,319.00);

INSERT INTO product

(ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)

VALUES (‘P1114590′,’R3000 Color Laser Printer’,’Connex’,5,’2007-01-22′,699.00);

INSERT INTO product

(ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)

VALUES (‘P1412138′,’10 Foot Printer Cable’,’Ethlite’,100,null,12.00);

INSERT INTO product

(ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)

VALUES (‘P1445671′,’8-Outlet Surge Protector’,’Intersafe’,33,null,14.99);

INSERT INTO product

(ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)

VALUES (‘P1556678′,’CVP Ink Jet Color Printer’,’Connex’,8, ‘2007-01-22’,99.00);

INSERT INTO product

(ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)

VALUES (‘P3455443′,’Color Ink Jet Cartridge’,’Connex’,24,’2007-01-22′,38.00);

INSERT INTO product

(ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)

VALUES (‘P6677900′,’Black Ink Jet Cartridge’,’Connex’,44,null,25.69);

INSERT INTO product

(ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)

VALUES (‘P9995676′,’Battery Back-up System’,’Cybercx’,12,’2007-02-01′,89.00);

INSERT INTO product

(ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)

VALUES (‘P4200344′,’36-Bit Color Scanner’,’UV Components’,16,’2007-01-29′,199.99);

# Create the Employee Table

CREATE TABLE Employee

( EmpNo varCHAR(8),

  EmpFirstName    varchar(20) NOT NULL,

EmpLastName     varchar(30) NOT NULL,

EmpPhone        varCHAR(15),

EmpEMail        VARCHAR(50) NOT NULL,

   SupEmpNo varCHAR(8) REFERENCES Employee  (SupEmpNo),

        EmpCommRateDECIMAL(3,3),

 PRIMARY KEY (EmpNo),

 UNIQUE(EmpEMail))

;

# Put data into the Employee table

INSERT INTO employee (EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,

 SupEmpNo, EmpCommRate)

VALUES (‘E9884325′,’Thomas’,’Johnson’,'(303) 556-9987′,”,”,0.05);

INSERT INTO employee

(EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,

 SupEmpNo, EmpCommRate)

VALUES (‘E8843211′,’Amy’,’Tang’,'(303) 556-4321′,”,’E9884325′,0.04);

INSERT INTO employee

(EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,

 SupEmpNo, EmpCommRate)

VALUES (‘E9345771′,’Colin’,’White’,'(303) 221-4453′,”,’E9884325′,0.04);

INSERT INTO employee

(EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,

 SupEmpNo, EmpCommRate)

VALUES (‘E1329594′,’Landi’,’Santos’,'(303) 789-1234′,”,’E8843211′,0.02);

INSERT INTO employee

(EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,

 SupEmpNo, EmpCommRate)

VALUES (‘E8544399′,’Joe’,’Jenkins’,'(303) 221-9875′,”,’E8843211′,0.02);

INSERT INTO employee

(EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,

 SupEmpNo, EmpCommRate)

VALUES (‘E9954302′,’Mary’,’Hill’,'(303) 556-9871′,”,’E8843211′,0.02);

INSERT INTO employee

(EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,

 SupEmpNo)

VALUES (‘E9973110′,’Theresa’,’Beck’,'(720) 320-2234′,”,’E9884325′);

# update employee commission rate for assignment 5.2 – change requested 12/3/2016

Update employee  set empcommrate=0.01 where empno=’E9973110′ and empfirstname=’Theresa’;

# Create the Customer Table

CREATE TABLE Customer

( CustNo        varCHAR(8),

        CustFirstName    varchar(20)  NOT NULL,

        CustLastName     varchar(30)  NOT NULL,

CustStreetvarchar(50),

CustCityvarchar(30),

   CustStatevarCHAR(2),

CustZipvarCHAR(10),

CustBalDECIMAL(12,2),

PRIMARY KEY (CustNo)  );

# Put data into the Customer table

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C0954327′,’Sheri’,’Gordon’,’336 Hill St.’,’Littleton’,’CO’,’80129-5543′,230.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C1010398′,’Jim’,’Glussman’,’1432 E. Ravenna’,’Denver’,’CO’,’80111-0033′,200.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C2388597′,’Beth’,’Taylor’,’2396 Rafter Rd’,’Seattle’,’WA’,’98103-1121′,500.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C3340959′,’Betty’,’Wise’,’4334 153rd NW’,’Seattle’,’WA’,’98178-3311′,200.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C3499503′,’Bob’,’Mann’,’1190 Lorraine Cir.’,’Monroe’,’WA’,’98013-1095′,0.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C8543321′,’Ron’,’Thompson’,’789 122nd St.’,’Renton’,’WA’,’98666-1289′,85.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C8574932′,’Wally’,’Jones’,’411 Webber Ave.’,’Seattle’,’WA’,’98105-1093′,1500.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C8654390′,’Candy’,’Kendall’,’456 Pine St.’,’Seattle’,’WA’,’98105-3345′,50.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C9128574′,’Jerry’,’Wyatt’,’16212 123rd Ct.’,’Denver’,’CO’,’80222-0022′,100.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C9403348′,’Mike’,’Boren’,’642 Crest Ave.’,’Englewood’,’CO’,’80113-5431′,0.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C9432910′,’Larry’,’Styles’,’9825 S. Crest Lane’,’Bellevue’,’WA’,’98104-2211′,250.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C9543029′,’Sharon’,’Johnson’,’1223 Meyer Way’,’Fife’,’WA’,’98222-1123′,856.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C9549302′,’Todd’,’Hayes’,’1400 NW 88th’,’Lynnwood’,’WA’,’98036-2244′,0.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C9857432′,’Homer’,’Wells’,’123 Main St.’,’Seattle’,’WA’,’98105-4322′,500.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C9865874′,’Mary’,’Hill’,’206 McCaffrey’,’Littleton’,’CO’,’80129-5543′,150.00);

INSERT INTO customer

(CustNo, CustFirstName, CustLastName, CustStreet, CustCity,

 CustState, CustZip, CustBal) 

VALUES(‘C9943201′,’Harry’,’Sanders’,’1280 S. Hill Rd.’,’Fife’,’WA’,’98222-2258′,1000.00);

# Create the OrderTbl table

CREATE TABLE OrderTbl

( OrdNo   varchar(8),

  OrdDate   DATE     NOT NULL,

CustNo   varchar(8)  NOT NULL REFERENCES Customer(custNo),

        EmpNo   varchar(8)  REFERENCES Employee (EmpNo),

        OrdName    varchar(50),

        OrdStreet  varchar(50),

        OrdCity    varchar(30),

        OrdState   varchar(2),

        OrdZip     varchar(10),

PRIMARY KEY (OrdNo)

);

# Put data into the OrderTbl table

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O1116324′,’2007-01-23′,’C0954327′,’E8544399′,’Sheri Gordon’,’336 Hill St.’,’Littleton’,’CO’,’80129-5543′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O1231231′,’2007-01-23′,’C9432910′,’E9954302′,’Larry Styles’,’9825 S. Crest Lane’,’Bellevue’,’WA’,’98104-2211′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O1241518′,’2007-02-10′,’C9549302′,”,’Todd Hayes’,’1400 NW 88th’,’Lynnwood’,’WA’,’98036-2244′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O1455122′,’2007-01-09′,’C8574932′,’E9345771′,’Wally Jones’,’411 Webber Ave.’,’Seattle’,’WA’,’98105-1093′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O1579999′,’2007-01-05′,’C9543029′,’E8544399′,’Tom Johnson’,’1632 Ocean Dr.’,’Des Moines’,’WA’,’98222-1123′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O1615141′,’2007-01-23′,’C8654390′,’E8544399′,’Candy Kendall’,’456 Pine St.’,’Seattle’,’WA’,’98105-3345′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O1656777′,’2007-02-11′,’C8543321′,”,’Ron Thompson’,’789 122nd St.’,’Renton’,’WA’,’98666-1289′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O2233457′,’2007-01-12′,’C2388597′,’E9884325′,’Beth Taylor’,’2396 Rafter Rd’,’Seattle’,’WA’,’98103-1121′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O2334661′,’2007-01-14′,’C0954327′,’E1329594′,’Mrs. Ruth Gordon’,’233 S. 166th’,’Seattle’,’WA’,’98011′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O3252629′,’2007-01-23′,’C9403348′,’E9954302′,’Mike Boren’,’642 Crest Ave.’,’Englewood’,’CO’,’80113-5431′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O3331222′,’2007-01-15′,’C1010398′,”,’Jim Glussman’,’1432 E. Ravenna’,’Denver’,’CO’,’80111-0033′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O3377543′,’2007-01-15′,’C9128574′,’E8843211′,’Jerry Wyatt’,’16212 123rd Ct.’,’Denver’,’CO’,’80222-0022′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O4714645′,’2007-01-11′,’C2388597′,’E1329594′,’Beth Taylor’,’2396 Rafter Rd’,’Seattle’,’WA’,’98103-1121′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O5511365′,’2007-01-22′,’C3340959′,’E9884325′,’Betty White’,’4334 153rd NW’,’Seattle’,’WA’,’98178-3311′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O6565656′,’2007-01-20′,’C9865874′,’E8843211′,’Mr. Jack Sibley’,’166 E. 344th’,’Renton’,’WA’,’98006-5543′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O7847172′,’2007-01-23′,’C9943201′,”,’Harry Sanders’,’1280 S. Hill Rd.’,’Fife’,’WA’,’98222-2258′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O7959898′,’2007-02-19′,’C8543321′,’E8544399′,’Ron Thompson’,’789 122nd St.’,’Renton’,’WA’,’98666-1289′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O7989497′,’2007-01-16′,’C3499503′,’E9345771′,’Bob Mann’,’1190 Lorraine Cir.’,’Monroe’,’WA’,’98013-1095′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O8979495′,’2007-01-23′,’C9865874′,”,’HelenSibley’,’206 McCaffrey’,’Renton’,’WA’,’98006-5543′);

INSERT INTO ordertbl

(OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,

 OrdState, OrdZip)

VALUES (‘O9919699′,’2007-02-11′,’C9857432′,’E9954302′,’Homer Wells’,’123 Main St.’,’Seattle’,’WA’,’98105-4322′);

# Create the OrdLine table

CREATE TABLE OrdLine

( OrdNo CHAR(8),

  ProdNoCHAR(8),

QtyINTEGER DEFAULT 1,

 CONSTRAINT PKOrdLine PRIMARY KEY (OrdNo, ProdNo),

 CONSTRAINT FKOrdNo FOREIGN KEY (OrdNo) REFERENCES OrderTbl(OrdNo)  

ON DELETE CASCADE,

 CONSTRAINT FKProdNo FOREIGN KEY (ProdNo) REFERENCES Product(ProdNo)  );

# Put data into the OrdLine table

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1116324′,’P1445671’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1231231′,’P0036566’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1231231′,’P1445671’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1241518′,’P0036577’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1455122′,’P4200344’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1579999′,’P1556678’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1579999′,’P6677900’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1579999′,’P9995676’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1615141′,’P0036566’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1615141′,’P1445671’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1615141′,’P4200344’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1656777′,’P1445671’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O1656777′,’P1556678’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O2233457′,’P0036577’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O2233457′,’P1445671’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O2334661′,’P0036566’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O2334661′,’P1412138’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O2334661′,’P1556678’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O3252629′,’P4200344’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O3252629′,’P9995676’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O3331222′,’P1412138’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O3331222′,’P1556678’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O3331222′,’P3455443’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O3377543′,’P1445671’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O3377543′,’P9995676’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O4714645′,’P0036566’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O4714645′,’P9995676’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O5511365′,’P1412138’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O5511365′,’P1445671’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O5511365′,’P1556678’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O5511365′,’P3455443’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O5511365′,’P6677900’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O6565656′,’P0036566’,10);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O7847172′,’P1556678’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O7847172′,’P6677900’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O7959898′,’P1412138’,5);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O7959898′,’P1556678’,5);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O7959898′,’P3455443’,5);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O7959898′,’P6677900’,5);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O7989497′,’P1114590’,2);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O7989497′,’P1412138’,2);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O7989497′,’P1445671’,3);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O8979495′,’P1114590’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O8979495′,’P1412138’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O8979495′,’P1445671’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O9919699′,’P0036577’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O9919699′,’P1114590’,1);

INSERT INTO ordline

(OrdNo, ProdNo, Qty)

VALUES(‘O9919699′,’P4200344’,1);

Calculate the price of your order

Select your paper details and see how much our professional writing services will cost.

We`ll send you the first draft for approval by at
Price: $36
  • Freebies
  • Format
  • Formatting (MLA, APA, Chicago, custom, etc.)
  • Title page & bibliography
  • 24/7 customer support
  • Amendments to your paper when they are needed
  • Chat with your writer
  • 275 word/double-spaced page
  • 12 point Arial/Times New Roman
  • Double, single, and custom spacing
  • We care about originality

    Our custom human-written papers from top essay writers are always free from plagiarism.

  • We protect your privacy

    Your data and payment info stay secured every time you get our help from an essay writer.

  • You control your money

    Your money is safe with us. If your plans change, you can get it sent back to your card.

How it works

  1. 1
    You give us the details
    Complete a brief order form to tell us what kind of paper you need.
  2. 2
    We find you a top writer
    One of the best experts in your discipline starts working on your essay.
  3. 3
    You get the paper done
    Enjoy writing that meets your demands and high academic standards!

Samples from our advanced writers

Check out some essay pieces from our best essay writers before your place an order. They will help you better understand what our service can do for you.

Get your own paper from top experts

Order now

Perks of our essay writing service

We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.

  • Swift delivery
    Our writing service can deliver your short and urgent papers in just 4 hours!
  • Professional touch
    We find you a pro writer who knows all the ins and outs of your subject.
  • Easy order placing/tracking
    Create a new order and check on its progress at any time in your dashboard.
  • Help with any kind of paper
    Need a PhD thesis, research project, or a two-page essay? For you, we can do it all.
  • Experts in 80+ subjects
    Our pro writers can help you with anything, from nursing to business studies.
  • Calculations and code
    We also do math, write code, and solve problems in 30+ STEM disciplines.

Frequently asked questions

Get instant answers to the questions that students ask most often.

See full FAQ

  • What if I’m dissatisfied with the paper I get?

    The average quality score at our professional custom essay writing service is 8.5 out of 10. The high satisfaction rate is set by our Quality Control Department, which checks all papers before submission. The final check includes:
    • Compliance with initial order details.
    • Plagiarism.
    • Proper referencing.
    If for some reason we happen to leave a mistake unnoticed, you are invited to request unlimited revisions of your custom-written paper. For more information, check our Revision Policy. We will do our best to make your experience with Familiar Essays enjoyable.

  • I need an essay on the same day. Is it something you can do?

    Sure. Our writing company offers a fast service with an 8-hour deadline for orders up to master’s level. Make sure to specify the deadline in the order form and our writers will write a paper within the indicated timeslot. Just proceed to submit your requirements here Once you order a custom-written essay, our managers will assign your order to the well-suited writer, who has the best skills and experience for preparing your specific assignment. You can also request one of these extra features:
    • Choose the Writer’s Samples option – study 3 randomly-provided pages from orders that have been written by the assigned writer.
    • Request a specific writer – choose an academic writer from the dropdown list in the order’s form (optional for returning customers).
    You can be sure that your custom writing order will be accomplished by one of our 400+ professional academic writers. They all pass a series of tests to prove their writing prowess and hold the reputation of being the most professional in the industry. Want to make sure writer’s skills match your needs? Get more details on how to choose the appropriate author.

  • How can I be sure your writing service is not a scam?

    We understand that a shade of mistrust has covered the paper writing industry, and we want to convince you of our loyalty. Apart from high-quality writing services, we offer:
    • The chances of students to boost writing skills in a quick and effective way.
    • The opportunity to manage studies and free time in an enjoyable manner.
    • The possibilities to improve overall academic performance.
    Our custom writing company has been working for more than 12 years and always puts quality and clients’ needs first. Our operations are legally documented, we are easily accessible online and offline,

  • Is it legal to use your professional writing service?

    Yes. Custom writing help is not prohibited by any university or college. It’s a 100% legal way of getting professional assistance with paper writing. Hiring writers from an essay writing company is in many ways similar to consulting a tutor – we help you solve the writing issues at hand.

  • How does your service work?

    Our custom writing service is a reliable solution on your academic journey that will always help you if your deadline is too tight. You fill in the order form with your basic requirements for a paper: your academic level, paper type and format, the number of pages and sources, discipline, and deadline. Then, you describe the specific details of the paper you need: add the topic, write or paste the instructions, and attach files to be used, if you have them. After that, an online customer support representative chooses the best writer that specializes in your discipline and assigns him or her to complete the paper according to your requirements. When the paper is ready, we check it for plagiarism and send it to you. If you want to change something, you can request a free revision.
See full FAQ

Take your studies to the next level with our experienced specialists

Order now
Live ChatWhatsApp