1. Q1: Write the SQL DDL commands (CREATE TABLE statements) to convert the ER diagram below...

  

Transcribed Image Text:

1. Q1: Write the SQL DDL commands (CREATE TABLE statements) to convert the ER diagram below to a database schema. All attributes should be integers (type int). Use the attribute names as depicted in the diagram, and declare all the appropriate constraints. Do not create a separate table for relationship R. When you define combined keys, please list the attributes in the combined keys in alphabetical order in the key definition. Enter all the CREATE TABLE statements, in the proper order, in file Q1.sql. e a A isa C b R f S C q B D d h 1. Q1: Write the SQL DDL commands (CREATE TABLE statements) to convert the ER diagram below to a database schema. All attributes should be integers (type int). Use the attribute names as depicted in the diagram, and declare all the appropriate constraints. Do not create a separate table for relationship R. When you define combined keys, please list the attributes in the combined keys in alphabetical order in the key definition. Enter all the CREATE TABLE statements, in the proper order, in file Q1.sql. e a A isa C b R f S C q B D d h

Answer rating: 100% (QA)

CREATE TABLE B c integer d integer PRIMARY KEY c CREATE TABLE D g integer h integer PRIMARY KEY g CR... View the full answer