Need help with these questions

(a) (3 marks) Provide a set of relational schemas for the high-level data model shown in Figure 1 below. Identify primary, alternate, and foreign keys in the tables (b) (2 marks) (i) What is the significance of integrity constraints/rules in relational database de- sign? Explain in this context why Primary Keys alone are not sufficient to (ii) Give an example of an integrity constraint which can neither bNnodelled as an (c) (2 marks) Explain how, with respect to the entities Equipment and Fault, these two implement referential integrity constraints entity integrity constraint, nor as a referential integrity integrity rules/constraints are implemented in the schemas tha en designed as part of your answer to the question 1 (a) above Com Owns Equiom name PK ne price Employs Has Engineer engNo (PK) Na Fault faultID (PK] description name date hours Na Optional, OR ElectFault MechFault mPart ePart