Answered You can hire a professional tutor to get the answer.

QUESTION

Write the SQL statement to add a table FACT_POSTS containing:

Write the SQL statement to add a table FACT_POSTS containing: • A surrogate primary key called POST_ID which uses AUTO_INCREMENT • PATRON_ID as a foreign key with on delete cascade • BOOK_ID as a foreign key with on delete set NULL • POST_DATE as a timestamp with default value CURRENT_TIMESTAMP • COMMENT as mediumtext with a FULLTEXT index

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question