Q1:-对以下数据进行归一化并在mysql中进行设计? PatientName,PatientNumber,PatientCondition,DoctorRegistration,PatientSignin,PatientSignout,DoctorRDO,医院名称,医院地址,门诊病人,NumStaff,NumBeds,DoctorName,AssignedDoctor 我做了这个 如果我错了,请纠正 第一个规范化<</b>/big> 医院桌 医院名称 Hospital_Address NumStaff NumBeds DoctorRDO 门诊病人 Doctor_Registration Doctor_Name 患者表 DoctorRDO Patient_Number Patient_Name Patient_Condition PatientSignin PatientSignout Assigned_Doctor 第二次标准化 医院详细信息表 医院名称 Hospital_Address NumStaff NumBeds 门诊 Hospital_Address是主键 患者表 DoctorRDO Patient_Number Patient_Name Patient_Condition PatientSignin PatientSignout Assigned_Doctor 在这里,Patient_Number是主键,而DoctorRDO是外键 Doctor_Details表 DoctorRegistration DoctorRDO DoctorName 在这里,Patient_ Number是外键,而DoctorRDO是主键 第三次标准化 医院详细信息表 医院名称 Hospital_Address NumStaff NumBeds 门诊 患者表 DoctorRDO Patient_Number Patient_Name Patient_Condition PatientSignin PatientSignout 在这里,Patient_Number是主键,而DoctorRDO是外键 Doctor_Details表 DoctorRegistration DoctorRDO DoctorName Assigned_Doctor_Details表 DoctorRDO Patient_Number 在此先感谢 问候
Q1:-Perform normalisation on the following data and design it in mysql? PatientName, PatientNumber, PatientCondition, DoctorRegistration, PatientSignin, PatientSignout, DoctorRDO, Hospital Name, Hospital Address, Outpatients, NumStaff, NumBeds, DoctorName, AssignedDoctor i performed this please correct if i am wrong 1st Normalisation<</b>/big> Hospital Table Hospital_Name Hospital_Address NumStaff NumBeds DoctorRDO Outpatients Doctor_Registration Doctor_Name Patient Table DoctorRDO Patient_Number Patient_Name Patient_Condition PatientSignin PatientSignout Assigned_Doctor 2nd Normalisation Hospital_Details Table Hospital_Name Hospital_Address NumStaff NumBeds Outpatients Hospital_Address is primary key Patient Table DoctorRDO Patient_Number Patient_Name Patient_Condition PatientSignin PatientSignout Assigned_Doctor Here, Patient_Number is primary key and DoctorRDO is foreign key Doctor_Details Table DoctorRegistration DoctorRDO DoctorName Here, Patient_ Number is foreign key and DoctorRDO is primary key 3rd Normalisation Hospital_Details Table Hospital_Name Hospital_Address NumStaff NumBeds Outpatients Patient Table DoctorRDO Patient_Number Patient_Name Patient_Condition PatientSignin PatientSignout Here, Patient_Number is primary key and DoctorRDO is foreign key Doctor_Details Table DoctorRegistration DoctorRDO DoctorName Assigned_Doctor_Details Table DoctorRDO Patient_Number Thanks in advance regards
推荐答案如果要将患者与多家医院联系起来,则需要小心. If you want to associate the patient with multiple hospital, then it needs to be taken care.
更多推荐
如何实现规范化?
发布评论