Description: SSD7. ex1. Part II
Write SQL statements as specified below. You may find this help on setting up your DBMS useful. Submit your SQL statements in a file named createDB.sql.
Write the DDL statements to create the two tables using the CREATE TABLE statement. Be sure to identify your primary keys and alternate keys in the statement.
Write the INSERT statements to insert the four rows into each table.
Write the SQL statement to retrieve the title and price of all books published by either of two publishers (say "Addison Wesley" and "McGraw Hill"). In the file Rel-ops.txt, list which relational operations you used, from among the select/project/join operations, in order to perform this query. Explain the role of each operation in your query.
Write the SQL statement to retrieve the Publisher name of a particular book title (say "Fundamentals of Database Systems").
To Search:
File list (Check if you may need any files):
| Filename | Size | Date |
|---|
| Exercise1\BookPublisher.html |
| .........\ex1 part 2 | 3.txt |
| Exercise1 |
Download