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.