question archive Q1:- Removing suggested medicine of a patient record from a hospital database could remove all details of the particular patient from the database such as the room_no, doctor,disease, bed_No , location etc
Q1:- Removing suggested medicine of a patient record from a hospital database could remove all details of the particular patient from the database such as the room_no, doctor,disease, bed_No , location etc
Subject:Computer SciencePrice: Bought3
Q1:- Removing suggested medicine of a patient record from a hospital database could remove all details of the particular patient from the database such as the room_no, doctor,disease, bed_No , location etc.Which kind of anomaly it is.
Q2:- In the University classes are scheduled according to courses,teachers, students, classrooms and labs. Create relational schema.
Q3. In a hospital OPD Patient_ID,Name,Age and Location are the information to be kept in the database using the schema PATIENT(Patient_ID, Name, Age, Location). Which attribute is to be selected as Primary key and why?
Q4:) Is many to many relationship between relations should be resolved in Entity Relationship Modeling ? Elaborate
Q5:) How to ensure that each cell in the table have atomic/single value.Justify with an example.
