, t MIDTERM-Zelada-schema X , SQL File 3 x , Le MIDTERM-Zelada-Schema x Limit to

Question

, 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 BUSINESS_ADDRESS(
ADDRESS_ID INT NOT NULL AUTO_INCREMENT,
ADDRESSS VARCHAR(100) NOT NULL,
BUSINESS_NAME VARCHAR(100) NOT NULL,
PRIMARY KEY ( ADDRESS_ID ),
FOREIGN KEY (BUSINESS_NAME) REFERENCES BUSINESS(NAME)
);

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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