Professional Writers
We assemble our team by selectively choosing highly skilled writers, each boasting specialized knowledge in specific subject areas and a robust background in academic writing
Find The Best Nursing Paper Writers For Your Assignments
You Can order for custom written paper 24/7! by completig a form in 3 steps. Get those desired coursework assessment grades!
Posted: November 29th, 2017
just q. 1 and 2 queries
Question description
i need queries for Q.no. 1 and Q.no.2SQL queries is ./* Database Systems, 8th Ed., Rob/Coronel */
/* Type of SQL : SQL Server */
CREATE TABLE CUSTOMER (
CUS_CODE int,
CUS_LNAME varchar(15),
CUS_FNAME varchar(15),
CUS_INITIAL varchar(1),
CUS_AREACODE varchar(3),
CUS_PHONE varchar(8),
CUS_CREDITLIMIT float(8),
CUS_BALANCE float(8),
CUS_DATELSTPMT datetime,
CUS_DATELSTPUR datetime
);
INSERT INTO CUSTOMER VALUES(‘10010′,’Ramas’,’Alfred’,’A’,’615′,’844-2573′,”,’0′,”,”);
INSERT INTO CUSTOMER VALUES(‘10011′,’Dunne’,’Leona’,’K’,’713′,’894-1238′,”,’0′,”,”);
INSERT INTO CUSTOMER VALUES(‘10012′,’Smith’,’Kathy’,’W’,’615′,’894-2285′,”,’345.86′,”,”);
INSERT INTO CUSTOMER VALUES(‘10013′,’Olowski’,’Paul’,’F’,’615′,’894-2180′,”,’536.75′,”,”);
INSERT INTO CUSTOMER VALUES(‘10014′,’Orlando’,’Myron’,”,’615′,’222-1672′,”,’0′,”,”);
INSERT INTO CUSTOMER VALUES(‘10015′,’O”Brian’,’Amy’,’B’,’713′,’442-3381′,”,’0′,”,”);
INSERT INTO CUSTOMER VALUES(‘10016′,’Brown’,’James’,’G’,’615′,’297-1228′,”,’221.19′,”,”);
INSERT INTO CUSTOMER VALUES(‘10017′,’Williams’,’George’,”,’615′,’290-2556′,”,’768.93′,”,”);
INSERT INTO CUSTOMER VALUES(‘10018′,’Farriss’,’Anne’,’G’,’713′,’382-7185′,”,’216.55′,”,”);
INSERT INTO CUSTOMER VALUES(‘10019′,’Smith’,’Olette’,’K’,’615′,’297-3809′,”,’0′,”,”);
Will Your Service Help Me Achieve Top Grades?
Absolutely! Our mission is to help you excel with A+ papers. From writing to our refund policy, everything is student-focused. We’re not just about meeting deadlines—we’re here to support your success. Have questions? Our friendly team is ready to assist anytime to ensure you reach your academic goals.
/* — */
CREATE TABLE INVOICE (
INV_NUMBER int,
CUS_CODE int,
INV_DATE datetime,
INV_TOTAL float(8),
INV_TERMS varchar(50),
INV_STATUS varchar(50)
);
INSERT INTO INVOICE VALUES(‘1001′,’10014′,’3/18/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’,’24.94′,’CASH’,’PAID’);
INSERT INTO INVOICE VALUES(‘1002′,’10011′,’3/18/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’,’9.98′,’CASH’,’PAID’);
INSERT INTO INVOICE VALUES(‘1003′,’10012′,’3/18/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’,’153.85′,’CASH’,’PAID’);
INSERT INTO INVOICE VALUES(‘1004′,’10011′,’3/19/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’,’34.87′,’CASH’,’PAID’);
INSERT INTO INVOICE VALUES(‘1005′,’10018′,’3/19/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’,’70.44′,’CASH’,’PAID’);
INSERT INTO INVOICE VALUES(‘1006′,’10014′,’3/19/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’,’397.83′,’CASH’,’PAID’);
INSERT INTO INVOICE VALUES(‘1007′,’10015′,’3/19/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’,’34.97′,’CASH’,’PAID’);
INSERT INTO INVOICE VALUES(‘1008′,’10011′,’3/19/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’,’399.15′,’CASH’,’PAID’);
/* — */
CREATE TABLE INVTOTALS (
INV_NUMBER int,
TOTAL float(8)
);
INSERT INTO INVTOTALS VALUES(‘1001′,’24.94’);
INSERT INTO INVTOTALS VALUES(‘1002′,’9.98’);
INSERT INTO INVTOTALS VALUES(‘1003′,’153.85’);
INSERT INTO INVTOTALS VALUES(‘1004′,’34.87’);
INSERT INTO INVTOTALS VALUES(‘1005′,’70.44’);
INSERT INTO INVTOTALS VALUES(‘1006′,’397.83’);
INSERT INTO INVTOTALS VALUES(‘1007′,’34.97’);
INSERT INTO INVTOTALS VALUES(‘1008′,’399.15’);
/* — */
CREATE TABLE LINE (
INV_NUMBER int,
LINE_NUMBER int,
P_CODE varchar(10),
LINE_UNITS float(8),
LINE_PRICE float(8)
);
INSERT INTO LINE VALUES(‘1001′,’1′,’13-Q2/P2′,’1′,’14.99’);
INSERT INTO LINE VALUES(‘1001′,’2′,’23109-HB’,’1′,’9.95′);
INSERT INTO LINE VALUES(‘1002′,’1′,’54778-2T’,’2′,’4.99′);
INSERT INTO LINE VALUES(‘1003′,’1′,’2238/QPD’,’1′,’38.95′);
INSERT INTO LINE VALUES(‘1003′,’2′,’1546-QQ2′,’1′,’39.95’);
INSERT INTO LINE VALUES(‘1003′,’3′,’13-Q2/P2′,’5′,’14.99’);
INSERT INTO LINE VALUES(‘1004′,’1′,’54778-2T’,’3′,’4.99′);
INSERT INTO LINE VALUES(‘1004′,’2′,’23109-HB’,’2′,’9.95′);
INSERT INTO LINE VALUES(‘1005′,’1′,’PVC23DRT’,’12’,’5.87′);
INSERT INTO LINE VALUES(‘1006′,’1′,’SM-18277′,’3′,’6.99’);
INSERT INTO LINE VALUES(‘1006′,’2′,’2232/QTY’,’1′,’109.92′);
INSERT INTO LINE VALUES(‘1006′,’3′,’23109-HB’,’1′,’9.95′);
INSERT INTO LINE VALUES(‘1006′,’4′,’89-WRE-Q’,’1′,’256.99′);
INSERT INTO LINE VALUES(‘1007′,’1′,’13-Q2/P2′,’2′,’14.99’);
INSERT INTO LINE VALUES(‘1007′,’2′,’54778-2T’,’1′,’4.99′);
INSERT INTO LINE VALUES(‘1008′,’1′,’PVC23DRT’,’5′,’5.87′);
INSERT INTO LINE VALUES(‘1008′,’2′,’WR3/TT3′,’3′,’119.95’);
INSERT INTO LINE VALUES(‘1008′,’3′,’23109-HB’,’1′,’9.95′);
Do You Have Experts to Write My Paper Urgently?
Yes! Our experienced writers can tackle any paper, even with tight deadlines like 6 hours. Specializing in diverse subjects, they ensure your assignment is top-notch. If you’re searching for the best site to write your paper fast, we’re your solution, with over a decade of expertise across academic levels.
/* — */
CREATE TABLE PRODUCT (
P_CODE varchar(10),
P_DESCRIPT varchar(35),
P_INDATE datetime,
P_QTYOH int,
P_MIN int,
P_PRICE float(8),
P_DISCOUNT float(8),
V_CODE int
);
INSERT INTO PRODUCT VALUES(’11QER/31′,’Power painter, 15 psi., 3-nozzle’, ‘1/2/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ‘8’, ‘5’, ‘109.99’, ‘0’, ‘25595’);
INSERT INTO PRODUCT VALUES(’13-Q2/P2′,’7.25-in. pwr. saw blade’, ‘1/12/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ’32’, ’15’, ‘14.99’, ‘0.05’, ‘21344’);
INSERT INTO PRODUCT VALUES(’14-Q1/L3′,’9.00-in. pwr. saw blade’,’2/12/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ’18’, ’12’, ‘17.49’, ‘0’, ‘21344’);
INSERT INTO PRODUCT VALUES(‘1546-QQ2′,’Hrd. cloth, 1/4-in., 2×50’, ‘1/14/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ’15’, ‘8’, ‘39.95’, ‘0’, ‘23119’);
INSERT INTO PRODUCT VALUES(‘1558-QW1′,’Hrd. cloth, 1/2-in., 3×50’, ‘8/14/2011′, ’23’, ‘5’, ‘43.99’, ‘0’, ‘23119’);
INSERT INTO PRODUCT VALUES(‘2232/QTY’,’B&D jigsaw, 12-in. blade’, ‘2/28/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ‘8’, ‘5’, ‘109.92’, ‘0.05’, ‘24288’);
INSERT INTO PRODUCT VALUES(‘2232/QWE’,’B&D jigsaw, 8-in. blade’, ‘1/23/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ‘6’, ‘5’, ‘99.87’, ‘0.05’, ‘24288’);
INSERT INTO PRODUCT VALUES(‘2238/QPD’, ‘B&D cordless drill, 1/2-in.’, ’12/19/2011′, ’12’, ‘5’, ‘38.95’, ‘0.05’, ‘25595’);
INSERT INTO PRODUCT VALUES(‘23109-HB’, ‘Claw hammer’, ‘2/19/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ’23’, ’10’, ‘9.95’, ‘0.1’, ‘21225’);
INSERT INTO PRODUCT VALUES(‘23114-AA’,’Sledge hammer, 12 lb.’,’11/1/2011′,’8′,’5′,’14.40′,’0.05′,”);
INSERT INTO PRODUCT VALUES(‘54778-2T’,’Rat-tail file, 1/8-in. fine’, ‘1/14/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ’43’, ’20’, ‘4.99’, ‘0’, ‘21344’);
INSERT INTO PRODUCT VALUES(’89-WRE-Q’,’Hicut chain saw, 16 in.’, ’11/6/2011′, ’11’, ‘5’, ‘256.99’, ‘0.05’, ‘24288’);
INSERT INTO PRODUCT VALUES(‘PVC23DRT’,’PVC pipe, 3.5-in., 8-ft’, ‘2/19/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ‘188’, ’75’, ‘5.87’, ‘0’, ”);
INSERT INTO PRODUCT VALUES(‘SM-18277′,’1.25-in. metal screw, 25’, ‘2/28/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ‘172’, ’75’, ‘6.99’, ‘0’, ‘21225’);
INSERT INTO PRODUCT VALUES(‘SW-23116′,’2.5-in. wd. screw, 50’, ‘1/23/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ‘237’, ‘100’, ‘8.45’, ‘0’, ‘21231’);
INSERT INTO PRODUCT VALUES(‘WR3/TT3′,’Steel matting, 4”x8”x1/6″, .5″ mesh’, ‘2/16/2014: 2024 – Essay Writing Service. Custom Essay Services Cheap’, ’18’, ‘5’, ‘119.95’, ‘0.1’, ‘25595’);
/* — */
CREATE TABLE VENDOR (
V_CODE int,
V_NAME varchar(15),
V_CONTACT varchar(50),
V_AREACODE varchar(3),
V_PHONE varchar(8),
V_STATE varchar(2),
V_ORDER varchar(1)
);
INSERT INTO VENDOR VALUES(‘21225′,’Bryson, Inc.’,’Smithson’,’615′,’223-3234′,’TN’,’Y’);
INSERT INTO VENDOR VALUES(‘21226′,’SuperLoo, Inc.’,’Flushing’,’904′,’215-8995′,’FL’,’N’);
INSERT INTO VENDOR VALUES(‘21231′,’D&E Supply’,’Singh’,’615′,’228-3245′,’TN’,’Y’);
INSERT INTO VENDOR VALUES(‘21344′,’Gomez Bros.’,’Ortega’,’615′,’889-2546′,’KY’,’N’);
INSERT INTO VENDOR VALUES(‘22567′,’Dome Supply’,’Smith’,’901′,’678-1419′,’GA’,’N’);
INSERT INTO VENDOR VALUES(‘23119′,’Randsets Ltd.’,’Anderson’,’901′,’678-3998′,’GA’,’Y’);
INSERT INTO VENDOR VALUES(‘24004′,’Brackman Bros.’,’Browning’,’615′,’228-1410′,’TN’,’N’);
INSERT INTO VENDOR VALUES(‘24288′,’ORDVA, Inc.’,’Hakford’,’615′,’898-1234′,’TN’,’Y’);
INSERT INTO VENDOR VALUES(‘25443′,’B&K, Inc.’,’Smith’,’904′,’227-0093′,’FL’,’N’);
INSERT INTO VENDOR VALUES(‘25501′,’Damal Supplies’,’Smythe’,’615′,’890-3529′,’TN’,’N’);
INSERT INTO VENDOR VALUES(‘25595′,’Rubicon Sis.’,’Orton’,’904′,’456-0092′,’FL’,’Y’);
Why choose us
You Want Quality and That’s What We Deliver
Discounted Prices
Our service is committed to delivering the finest writers at the most competitive rates, ensuring that affordability is balanced with uncompromising quality. Our pricing strategy is designed to be both fair and reasonable, standing out favorably against other writing services in the market.
AI & Plagiarism-Free
Rest assured, you'll never receive a product tainted by plagiarism or AI-generated content. Each paper is research-written by human writers, followed by a rigorous scanning process of the final draft before it's delivered to you, ensuring the content is entirely original and maintaining our unwavering commitment to providing plagiarism-free work.
How it works
When you decide to place an order with Nurscola, here is what happens: