1. Create the database of HW#2. Determine an appropriate data type for each attribute. Use
“create table~” statements and “create index~” statements to create the tables and appropriate index
structures. Note that in SQL-92 and 99 (aka SQL II and III) standards (and many DBMS
implementations), all primary key attributes are implicitly declared to be “not null”. However, in this
assignment, declare primary key attributes to be “not null” explicitly. In SQL, foreign key attributes are
allowed to be null. However, sometimes, to satisfy “total participation” in ER-diagram, related foreign
key attributes should be declared to be “not null”. Print the statements you used to create this database
and the results of them.
2. Populate your database by inserting 10 or more tuples into each table.
3. Create the following queries using SQL:
Write the queries in the HW#2 in SQL. Print the SQL statements of your queries as well as the results
of your queries.
0 comments