need help with part a and b

Consider the Kafka University domain, a very high-level (and partial) data model for which is shown as Figure 1 below (a) (3 marks) Provide a set of relational schemas for this model. Identify primary and (b) (3 marks) foreign keys in the tables. (i) Explain what Entity Integrity is, and why it should be enforced in relational models. Use Figure 1 to provide the context for your discussion. (ii) A student enrolled in ISYS224 wants it to be counted both towards her current undergraduate program, as well as a planned postgraduate program in future. Is that consistent with the data-model provided in Figure 1? Please provide a brief explanation of your answer Facult facNo [PK facName 1...1 Manages 1..Department deptNo (PK ne Monitors dateJoined Offers Student Unit SID (PK name uCode PK) description year Name Name uarter Mandatory, OR) UG_unit PG unit level enrolCap Figure 1: A high-level partial data model of Kafka University