[CS457]HW2

docx

School

Northwestern Polytechnic University *

*We aren’t endorsed by this school

Course

457

Subject

Computer Science

Date

Jan 9, 2024

Type

docx

Pages

Uploaded by arsaikiran11

HOME WORK #2. Answer:1 1. List of all integers Data types : Type Storage Minimum Value Maximum Value (Bytes) (Signed/Unsigned) (Signed/Unsigned) TINYINT 1 -128 127 0 255 SMALLINT 2 -32768 32767 0 65535 MEDIUMINT 3 -8388608 8388607 0 16777215 INT 4 -2147483648 2147483647 0 4294967295 BIGINT 8 -9223372036854775808 9223372036854775807 0 18446744073709551615 Answer 2. 1. select * from terms; INSERT INTO terms(terms_description ,terms_due_days)VALUES ('Feb', 5);

2. INSERT INTO vendors (vendor_name,vendor_address1,vendor_address2,vendor_city,vendor_state,vendor_zip_code,v endor_phone,vendor_contact_last_name,vendor_contact_first_name)VALUES ('Arcot', '39800 Pathfinder', 'apt 421', 'fremont', 'ca', 94538,'4084311706', 'kiran', 'sai'), ('AAA', '39800 Pathfinder', 'apt 421', 'fremont', 'ca', 94538,'4084311706', 'kKK', 'SSS');

3. INSERT INTO invoices(vendor_id,invoice_number,invoice_date ,invoice_total ,payment_total,credit_total,ter ms_id ,invoice_due_date,payment_date)VALUES (2, 456, '2014-02-05', 100, 204, 421, 1, '2014- 03-13', '2014-03-06' ),(2, 123, '2014-03-05', 100, 204, 421, 1, '2014-04-13', '2014-04-06'),(2,123, '2014-04-05', 100, 204, 421, 1, '2014-05-13', '2014-05-06');

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

4. SELECT CONCAT (vendor_contact_first_name,vendor_contact_last_name),(vendor_city) FROM vendors; 5. select * from invoice where invoice_total>10000;

6. Select * from invoices where invoice_due_date between 140101 and 140131; 7. Delete from invoices where vendor_id=111; Delete from vendors where vendor_id=111;

8. Truncate invoice_line_items; 9. Drop table invoices; Drop table terms; Drop table vendors; Drop table invoice_line_items;

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

10. DROP database cs457_lab;

Related Documents

Reading Comprehension Assignment.docx

chkpt2_template.pdf

chkpt3_template.pdf

chkpt1_template.pdf

Jenkins_Antonio_C950T2.docx

Jenkins_Antonio_C464T1.docx

Thursday-solution_-1139956641.PDF

Recommended textbooks for you

Systems Architecture

Computer Science

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Cengage Learning

C++ for Engineers and Scientists

Computer Science

ISBN:9781133187844

Author:Bronson, Gary J.

Publisher:Course Technology Ptr

Microsoft Visual C#

Computer Science

ISBN:9781337102100

Author:Joyce, Farrell.

Publisher:Cengage Learning,

Principles of Information Systems (MindTap Course...

Computer Science

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

CMPTR

Computer Science

ISBN:9781337681872

Author:PINARD

Publisher:Cengage

SEE MORE TEXTBOOKS

Recommended textbooks for you

Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage