Note: you will earn up to 5 points for the proper layout and structuring of your work

Thank you for helping me with this.

Objective: This lab aims to practically understand that a system must retrieve data effectively for it to become usable. Hence, designers should apply complex data structures to represent data within a database considering that end-users of ample database-system are not computer-literate. Hence, developers hide the complexity from users over several abstraction levels to simplify their interactions. As described during our lectures, such abstraction levels are internal, conceptual/logical, and external. Therefore, this lab gets scored out of 100 pts. \begin{tabular}{|lrr} \hline Part 4 considers the external level design point of view: implement two views & 25 pts. \\ \hline \end{tabular} - Query name (NurseScheduleView), which reports to the medical assistant all the scheduled activities by the week and by the month. Read into the extract function to work with respective date attributes. - Query name (PatientDoctorContactReference) reports to the medical assistant the contacts references of a patient and their respective doctors, possibly to call them and do a follow-up