Supplier Name Supplierno Location Project Name Project No Budget M N SUPPLIER PROVIDES PROJECT Table 1: Table 2: Table 3

[answerhappygod]

Supplier Name Supplierno Location Project Name Project No Budget M N Supplier Provides Project Table 1 Table 2 Table 3 1 (26.41 KiB) Viewed 34 times

Consider the figure above, which shows the ER model for a ternary relationship, and the corresponding database schema.
Write the four SQL statements that are necessary to create each of the tables Supplier, Project, Part, and Provides. Your SQL should clearly specify the attributes of each table, your
suggested data types for those attributes, and all the necessary constraints (e.g.. primary key, foreign key, etc). However, you do not need to specify how referential integrity
constraints are handled.
Supplier Name Supplierno Location Project Name Project No Budget M N SUPPLIER PROVIDES PROJECT Table 1: Table 2: Table 3: Table 4: PartNo QTY PART Part Name Price Supplier (SupplierNo, SupplierName, Location) Project (ProjectNo, ProjectName, Budget) Part (PartNo, PartName, QTY, Price) Provides (SupplierNo, PartNo, ProjectNo)