Write an SQL Script to add a new table to this Schema for business addresses wit

Question

Write an SQL Script to add a new table to this Schema for business addresses with a one to many relationship with the business table. You do not need to enter data into this table. Copy script to answer sheet.

, t MIDTERM-Zelada-schema X , SQL File 3 x , Le MIDTERM-Zelada-Schema x Limit to 1000 rows Query 1 x Context SCHEMAS Q Filter objects SELECT FROM MIDTERM_Zelada.BUSINESS; Automatic co disabled. Use manually get caret position automatic he MIDTERMZelada - Tables ACCOUNT ACC-TRANSACTION BRANCH BUSINESS 100% 1:1 Result Grid Filter Rows: a | Edit: 1 Export/Import: Columns Indexes STATE ID CUST ID INCORP DATE NAME 1995-05-01 Chilton 2001-01-01 2002-06-30 Superior Auto Body 34-567-800 1 1999-05-01 AAA Result Grid Engineering 12-345-6T8 10 Northeast Cooling Inc. 23-458-789 11 Foreign Keys Triggers CUSTOMER Insurance Inc. 45-678-901 13 HULL Form Editor DEPARTMENT EMPLOYEE INDIVIDUAL OFFICER Field Types PRODUCT E PRODUCT_TYPE Views Stored Procedures Functions Execution Plan Object info Session BUSINESS 1 Apply

Explanation / Answer

create table MIDTERM_Zelada.BUSINESSADDRESSES
(
CUST_ID INT,
NAME VARCHAR(50),
ADDRESS VARCHAR(30),
STATE_ID VARCHAR(25),
COUNTRY_ID VARCHAR(10)
);

INSERT INTO MIDTERM_Zelada.BUSINESSADDRESSES VALUES
(10,'CHITON ENGINNERING','NAGAR','12-354-678','UK'),
(11,'NORTHEAST COOLING INC','RAJIV','23-456-789','US'),
(10,'CHITON ENGINNERING','NNYK','12-354-678','MN')

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.