Write SQL statements to create database and tables using the conceptual design from Phase I. Use appropriate
Question:
Write SQL statements to create database and tables using the conceptual design from Phase I. Use appropriate naming conventions for all tables, attributes, primary keys, and foreign keys. You may copy and paste SQL statements from your own DBMS to the file you'll upload.
• Insert at least 5 rows data in each table via SQL statements. Write SELECT * for each table and do a SNIP or screen shot that shows your tables.
• Write SQL statements to update 1 column and delete 1 row for each table. You may copy and paste SQL statements from your own DBMS to the file you'll upload.
• Write four SQL queries,
1 contains GROUP BY
1 contains GROUP BY and HAVING
1 contains nested query with ALL
1 contains nested query with IN
show a screen shot or SNIP that shows the SQL code and the result.
For this relational schema:
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi