Create SQL DDL statements for each table in the ER diagram
 
Minimize the number of relations whenever possible.

Use the "Delta Table" approach for ISA relationships.

Derived attributes must be calculated via SQL queries or other mechanisms we have not learned yet. For now, enter a derived attribute as a basic attribute.

For domain names (data types), use the most appropriate types for each column.

Be sure to include the following information in the DDL statements for each table:

name, columns, and column types (and sizes if applicable)

primary keys column(s)

foreign key column(s) (and indicate which table it references)

not null constraints and/or other referential integrity constraints
 

 

ER Diagram First Email UCINetID TeamID Name DeptID Name Middle Name User ISA Competitor N memberOf Team N belong Department Last M M order Amount Sponsor Company Number Season N 1 M Name Product sponse Discount has Price ProdID GamelD N N ChallengelD Start Game 1 has N Challenge N End solve Competitor and Sponsor do NOT cover User Topic Duration Points