[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

7

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