Answer Happy

போரான் பாப்பா பாமா homnathamaaா பாரியான - WoW the motor end of the unioren ne temat the next tima day they wantment is made or write the statement are necessary to create each of the sector one and Arts Your SOL should clearer the tributes of each bevor ested caras for those atributes and all the necessary constraints de primary hey, Foreign key were you do not pechowder constraints are a 02 trettional atera expression that perform the following praction 02. Find the names of all doctors 02>Pind the sof patients who suffer from Asthma 02 the De of a doctors that have had appointments with the partier Maher To www your relational era expressions, you can use the equation editor provided by blackboard or you can simply copy and paste the following symbol in your wer when needed. Aca last resort, you can use the first setter of each operator as the symbol for that operator Project: I or P Selectors or

Doctors did dname address age Patients pid pname diagnosis Appointments did pid day Consider the database schema shown above, in which each of the attributes is explained as follows: .did: the unique ID of a doctor dname: the name of a doctor • address: an the address of a doctor • age: the age of a doctor • pid: the unique ID of a patient • pname: the name of a patient • diagnosis: the name of the illness/disease a patient might have (e.g., Asthma) day: the day in which an appointment is made Write relational algebra expressions that perform the following operations: Q1: Find the names of all doctors Q2: Find the IDs of all patients who suffer from Asthma Q3: Find the IDs of all doctors that have had appointments with the patient'Maha'.

o wste the three sex statements that we necesary to create each of the table Doctor Pension. Your SOL should do the stributes of each table our usted data for those attributes and all the necessary constraints les primary key foreigney, However you do not need to writy hower care oz. W relational algebra expressions that perform the following operation 2. Find the names of all doctors 022wind the sor a patients who suffer from the nes of all doctors that have had anpointments with the patient Maha Te wite your relational gebra expressions, you can win the equation or provided toy blacktard, or you can simply copy and paste the following symbol in yours when needed As a last resort, you can use the first letter of each operate as the symbol for that operator Project Il or p Selectors Jor)