Database design question

1) My wife is a physician, and one of her duties is to create the call schedule for her and her colleagues. Each night exactly one doctor must be on call at the hospital, and my wife needs a database to keep track of which doctor is on call each night. A doctor has a first name, a last name, a beeper number (integer), and a set of initials (2 or 3 letters); al fields are required, where the beeper number and initials are unique. Example: "Pooja", "Sankar", 5096, "ps" Each doctor supplies 0 or more nights when he/she is on vacation and cannot work. Example: "ps" cannot work on December 25, 2016, December 31, 2016, and January 1, 2017 To be fair, my wife tries to assign each doctor the same number of weekday nights (i.e. Monday Thursday), weekend nights (Friday, Saturday, and Sunday), and holiday nights (e.g. Memorial day, July 4th Labor day, etc.). A doctor starts work at 7pm, so if the doctor starts work on a holiday (e.g. Memorial day,) that counts as a "Holiday". If the date is not a holiday, then if the doctor starts work on a Friday Saturday/ Sunday, then it counts as a "Weekend". Otherwise it counts as a "Weekday". This implies that if a holiday happens to fall on a weekend, it counts as a holiday, not a weekend. Since the date of a holiday may change from year to year (e.g. Memorial day), the date of each holiday is entered by my wife into the database. Whether a date is a weekday or a weekend does not need to be stored; this can be computed by SQL or C# function calls. Design a database to store the information described above, following the design rules we have learned in class (the 5 informal rules). (a) Draw an ER model of your design. Be sure to include relationships, and whether they are 1-to-1, 1-to- many, etc. (b) Write the SQL DDL for your design