SQL1 - spring 2013 patient PK patient_no FK1 name gender admit discharge exp_disch room_bed has accommodation PK type accommodation attends has FK1

Here, HW 2 (attached) file is the main assignment file and rest of the attached files are for the references. My professor gave us HW 1 (attached) first, which was a flawed database and we had to create the ERD and DDLs for this flawed database AND fix the database in HW 2. So, I did HW 1 and I have attached its ERD Solution and SQL Solution here for references. NOW we are assigned HW 2 (attached), which is the assignment to fix the flawed Database from HW 1. I have also attached the Yellow SQL Handout file, which both HW 1 and HW 2 references but you might not even need to look at it. Then I have attached another Sample Homework and its solutions because Sample solutions are an example of how my professor wants the 3NFs and indexing to be done. LASTLY, I have attached pdf version of HW 2 ERD file I last worked on where my professor has pointed out the things I needed to fix. But because of time constraints I am thinking about getting help from you guys if I get a good deal. Please let me know.

• Attachment 1
• Attachment 2
• Attachment 3
• Attachment 4
• Attachment 5
• Attachment 6
• Attachment 7
• Attachment 8
• Attachment 9