Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help with #8 and 12 1. Create a new table to track the Library location. - Screen shot not required, please paste the SQL statement
help with #8 and 12
1. Create a new table to track the Library location. - Screen shot not required, please paste the SQL statement to create the table. (5 pts) LIBRARY (lib id, lib_name, lib address, lib_city, lib state, lib zip) LIB_ID is the primary key and should be numeric. LIB_NAME, LIB_ADDRESS, and LIB_CITY is between 1 and 35 characters. -These should not be null LIB_STATE is 2 characters- default to TX. LIB_ZIP is 5 numbers. Check for one of the following zip codes- 75081, 75080, 75082 75079, 75078 CREATE TABLE LIBRARY LIB_ID YARCHAR(4) PRIMARY KEY LIB NAME VARCHAR(35) NOT NULL, LIB_ADDRESS VARCHAR(35) NOT NULL LIB_CITY VARCHAR(35) NOT NULL LIB_STATE VARCHARI2) DEFAULT 'TX' NOT NULL LIB_ZIP NUMBER(5) NOT NULL CHECK(LIB_ZIP IN (75081', 75080','75082','75079''75078') CREATE SEQUENCE LIB_ID_SEQ MINVALUE 1000 START WITH 1001 INCREMENT BY 1 2. Insert the following records into the LIBRARY table - Show each SQL statement and then provide a screen shot listing all the rows in the table. (5 pts) 1000, JFK Library, 800 West Campbell Road, Richardson, 75080 1001, MLK Library, 105 King Blvd., Richardson, TX, 75081 1002, Hoover Library, 932 Arapaho St., Richardson, TX, 75080 INSERT INTO LIBRARY (lib_id, lib_name, lib_address, lib_city, lib state, lib..zip) VALUES ('1000', 'JFK Library', '800 West Campbell Road','Richardson', 'TX', '75080'); INSERT INTO LIBRARY (lib_id, lib_name, lib_address, lib_city, lib state, lib..zip) VALUES ('1001', 'MLK Library', '105 King Blvd.', 'Richardson', 'TX', '75081'); INSERT INTO LIBRARY (lib_id, lib_name, lib_address, lib_city, lib state, lib..zip) VALUES ('1002', 'Hoover Library', '932 Arapaho St.', 'Richardson', TX', '75080)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started