You are tasked to develop a relational database for the following IT system. City Central Hospital Network IT systems include data centers, servers, personal computers, telecoms networks, devices, and printers. The information system with Databases is the comprehensive, integrated information system designed to manage all the aspects of a Hospitals operation, such as administrative, financial, and legal issues.

City Central Hospital Network system has three buildings. All buildings are connected to each other.

THE LISTS OF DATABASES ARE:

Patient: Currently 400 Patients in the Hospital

Doctors: 45 full-time Doctors

Nurses: 250 full-time Nurses. One Nurse can be assigned to more than one Doctor

Buildings and rooms. Three Buildings

Main Building: 350 Patients Room, and 25 offices

West Building: 50 Patients Room, and 15 offices

North Building : 0 Patients room, and 30 offices

Currently, City Central Hospital has a database with only one table to store all Patient, Doctor, Nurse, Building, and room data.

Q1 ) Give an example for Data Redundancy by considering the hospitals current database.

Q2) Consider the given City Central Hospitals database and come up the normalization. How many database tables you would do for the normalization process?

Q3) After the normalization process, how you would establish Functional Dependency among them. Give three examples of Functional Dependency.