Q1:- Removing suggested medicine ofa patient record from a hospital database could remove all details of the
Question:
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.
Statistics Unlocking The Power Of Data
ISBN: 9780470601877
1st Edition
Authors: Robin H. Lock, Patti Frazer Lock, Kari Lock Morgan, Eric F. Lock, Dennis F. Lock