Please use the following schema and write a view that will show all the patients and the visitors for the current day. The current day is the date when the view get executed. PATIENT VISITOR PK Patient ID PK Visitor FirstName FirstName Last Name Last Name Room CreationDate Visilimit PerDay Last Edit Date Creation Date Deleted Last Edit Date Deleted VISIT PK Visit Patient ID Visitor VisitStartDateAndTime VisitEndDateAndTime Creation Date LastEdit Date Deleted