Q.2 Consider the business rules given below- A Computer must be the host of one and...

Transcribed Image Text:

Q.2 Consider the business rules given below- A Computer must be the host of one and only one motherboard. A motherboard may be incorporated into one and only one computer. A computer has many input devices. Each input device links to a computer. Answer the given below Questions: 3. Draw a relational diagram for the database represented by the above business rules 4. Give the relational schema for the tables. 5. Give the difference between primary key and foreign key taking examples from any of the above tables. Q.2 Consider the business rules given below- A Computer must be the host of one and only one motherboard. A motherboard may be incorporated into one and only one computer. A computer has many input devices. Each input device links to a computer. Answer the given below Questions: 3. Draw a relational diagram for the database represented by the above business rules 4. Give the relational schema for the tables. 5. Give the difference between primary key and foreign key taking examples from any of the above tables.

Answer rating: 100% (QA)

All the parts have been solved below 1 Relational Diagram for the database 1 Relational Schema f... View the full answer