Database Design Multiple Choice

The implementation should capture which supplier(s) supplied which part(s) to which project(s). For each such supplying activity, what was the quantity of the part supplied. The PROJECT entity captures all the project information about the projects in file. The SUPPLIER entity represents the list of active suppliers. The PART entity represents the part inventory of the company. The best way to implement this design in a relational database is _____. (a) Have only three tables, one for each entity: PROJECT, PART, and SUPPLIER (b) Have only four tables: PROJECT, PART, SUPPLIER, and SUPPLY-FOR-PROJECT. The SUPPLIES-FOR-PROJECT table includes foreign keys that references the primary key attributes of PROJECT, PART, and SUPPLIER and a non-prime attribute Quantity. (c) Have only one table that captures all the data about PROJECT, PART, SUPPLY-FOR-PROJECT and SUPPLIER (d) It is impossible to implement this design in a relational database. (e) None of (a) to (d) is the correct