. a universityhas five Campuses, each campus has mailing address and known by abbreviation title such as KHI,PWR,ISB

2. There are different Schools of various disciplines such as School of Computing, School of Engineering etc., each school has its head with job title Dean and mailing address. Each school has its subordinates departments and programs of campuses. .

3. There are various departments fCS, EE etc.) exist in each campus, each has mailing address, managed under Schools with HOD. Although, departments are administratively managed under their Campuses

. 4. There are many programs (e.g., Computer Science BS, MS, PhD), Supervised by the Schools and execute in departments. One department may offer multiple programs such as CS, SE etc.

5. Every campus has its own Semester schedule for all its departments and programs. Courses are offered in semesters

. a) Draw an E/R diagram (to manage centralized for all campuses) with all possible valid attributes of this scenario. Do not forget to underline the keys and to mention the cardinalities

B)CONVERT THE ER DIAGRAM INTO KEYS AND CONSTRAINTS.

C)GIVE DATASET OF YOUR MAPPING WITH ALL POSSIBLE RECORDS