Part A Scenario: Aaliya Institute of Management and Technology (AIMT) conducts courses to award Bachelors and Masters Degree programmes in various specializations. It has a well-established manual system to manage almost all the day to day business of an academic institute and is inclined to proceed with automation of all the process. AIMT has a Dean and few Associate and Assistant Deans to assist the Dean in academic matters. It has many departments and each department can offer different programmes. Each department is chaired by a Head of the Department (HoD). Further, each department is identified with a unique ID, department name, and employee_ID of the person who is heading the department. Within a department, each Programme is managed by a Programme Manager (PM), who in turn reports to the HoD. Each department offers a bunch of courses spread across different programmes which necessitates the need of interaction between the PMs and HoD during allotment of modules to teaching staff. A module to be offered can have multiple sessions and each module is identified by a unique module code, module name and number of credit hours. Each teaching faculty is allocated with a teaching load of minimum of 18 credits. If the module that is offered belong to Master's level, then one credit load is considered to be equal to one and a half credit. In order to be familiar with the responsibilities of HoDs, AIMT has decided to bring in some changes at the administrative level by introducing one or more Assistant HoDs who can assist the HoD in overall functioning of the department. Existing staff members instead of directly reporting to HoD, will now be directly reporting to one of the Assistant HoDs. After the introduction of Assistant HoDs, the teaching work load of staff who are serving as Assistant HoDs has been reduced to 10 credits and that of the PMs also. It is to be noted that Dean, Associate/Assistant Dean, HoD, PM, teaching staff such as Professor, Associate Professor, Assistant Professor, Lecturer are all employees and every employee is identified with a unique ID, name, gender, date of birth, designation, department to which he/she belongs, skills of the faculty. Propose a conceptual model after an in-depth research on AIMT operations and processes. In order to come up with an appropriate design/solution, you must study the requirements, issues and best practices in this problem context. You can make relevant assumptions required to formulate business rules, security, administration and modelling. Task 1: Design an Entity Relationship Diagram (ERD) to model the above scenario. Identify the different entities and attributes of each entity. Suggest and justify the choice of relationship and cardinality of the relationship. State the assumptions (if any) made by you to develop the ERD based on your research. Provide detailed analysis and justification for the selection of entities and attributes based on your research. Task 2: Derive a set of relational tables from the ER diagram (Task 1), using appropriate choices for the table attributes. List the integrity rules and business rules, which you would recommend to ensure the quality of data. Indicate all necessary key constraints. Critically analyze the constraints and business rules based on your study of the clinic. Task 3: Outline the kinds of anomalies that can arise in the scenario given above by using un-normalized tables. Show how the table created in task 2 could be re-organized into separate tables to avoid anomalies (Decompose the table structures to a set of 3NF tables). Task 4: As a database administrator identification of specific roles for users, authentication policy, storage management and database recovery are critical. The efficiency and complexity of database administration depends on the identified strategy and tools. Propose and critically review user management, backup/recovery strategy, storage management/techniques formulated for the system discussed in above tasks. Part B Write a research article in IEEE Format describing the solution to the scenario given in Part-A. The research article can be approximately 2500 words. The literature must be enhance and be more focused on data modeling of the similar institute given in the Scenario: CRITERIA Part A: Task 1: Extent of clarity in evaluating the role of conceptual modeling in the development of database systems and apply the entity-relationship modeling approach to a realistic scenario (a) 8 entities with attributes including justification (b) Justification of choice of relationship and cardinalities Task 2: Ability to apply the essential concepts of relational databases to sample data sets and demonstrate best practice in the development of an appropriate and effective database system. (a) Formation of 8 tables with PKs and FKs (b) Critical analysis of constraints and business rules Task 3: (a) Outline the 3 anomalies with appropriate examples (b) Normalization and normal forms Task 4: Ability to review (a) User management (b) Backup/recovery strategy (c) Storage management Part B: Research article: (a) Quality, originality and relevance of research article (b) Evidence of independent research and critical thinking (c) Depth of understanding of problem context (d) Literature review (e) Concise objectives of research problem (f) Research methodology (g) ; (g) IEEE format