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.
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post database assignment 23 appeared first on The Nursing Hub.