文件名称:Exercise1
介绍说明－－下载内容均来自于网络，请自行研究使用
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"). -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").
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"). -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").
(系统自动生成,下载前可以参看下载内容)
下载文件列表
| 文件名 | 大小 | 更新时间 |
|---|---|---|
| Exercise1\BookPublisher.html | ||
| .........\ex1 part 2 | 3.txt | |
| Exercise1 |