This bank wants to computerize the process of banking. Lee Wong is the newly appointed database administrator at Standard bank. The relationship between the author entity and the book entity and represent it with an ERħ. In the preceding diagram, you have to identify the entities, their attributes, and the type ofĪttributes for Patient : patient name, date admitted, patient idĪttributes for doctor : Doc_ID, Specialization, Doc_NameĪn author can write multiple books and a book can be written by more than one author.
Theįollowing ER diagram represents the relationship between the patient and the doctor. Implementing the database will make the data easily accessible. You have been hired by a regional hospital to create a database that will be used to store the In the preceding diagram, you have to identify entities, their attributes, and type of relationshipĪttributes of department : DepID,DepName and DepIdĪttributes of employee : EmpID, EmpName ,and DepIDĥ. Theįollowing ER diagram represents the relationship between the departments and the employees. Organization has multiple departments and each department has multiple employees. Tom is working in an organization as a database administrator. The Shift id coloumn may contain duplicate values as two doctors may be on the same shift.ĭoctorID should be chosen as the primary key and shiftid as the alternate key.Ĥ. Therefore the coloumns, doctorID and ShiftID ,are candidate keys for the primary key. In the preceding table, you have to identify primary key, candidate key, and alternate key and giveĭoctorID and shiftID are individually unique in every row. Consider the following DoctorDetails table.
0 kommentar(er)
