问题描述
Q1:-对以下数据进行归一化并在mysql中进行设计?
PatientName，PatientNumber，PatientCondition，DoctorRegistration，PatientSignin，PatientSignout，DoctorRDO，医院名称，医院地址，门诊病人，NumStaff，NumBeds，DoctorName，AssignedDoctor
我做了这个
如果我错了，请纠正
医院详细信息表
医院名称
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
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
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
推荐答案
这篇关于如何实现规范化?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！