Which of the following statements are true about the advantages of creating relationships between tables? Data can be easily combined from multiple tables O Prevents data from becoming inconsistent More than one statement is correct O Prevents deletion of a record in one table if it has a record in another related table

Q: Create the following queries for the “books” database. For each query make sure to only include…

A: SELECT COUNT(TITLE_ID) AS "# of long books" FROM TITLES WHERE TITLES.PAGES>=450 GROUP BY TYPE;

Q: How do you create an index? How do you create a unique index? What is the difference between an…

A: -Creating an index involves the CREATE INDEX command. -it allows us to name the index, to specify…

Q: Q1: Identify one PK from each table and add the constraints using alter.

A: PK or Primary Key constraint represents unique values in a column or set of columns. PK column…

Q: In a relational database, you may narrow down the number of columns in a table that match your…

A: Given, In a relational database, you may narrow down the number of columns in a table that match…