I have recently read the document for our project assignment. Many of the questions can be easy to implement, but there are also a lot of things that confuse me, so I am here to seek clarification. - There is a question asking "Find the surgeon who provides the service X". Do you mean for each service X, there will be exactly one surgeon who can provide the service? Or there can be more than one surgeon? I am worrying about this because it determines the multiplicity of the relation. - "For each actual patient, their Date of Birth (D) and their Medicare number (S 12) are also recorded, along with which customer is currently responsible for paying for their treatment." But why should I include who is responsible for paying in the personal information of a patient? An invoice already "identifies the patient and the surgeon involved, as well as the customer billed". It seems more reasonable to only store the payer with invoice details. Likewise, should I include date in invoice details? As each appointment has their own date, and generates exactly one invoice, there is no need to record the relevant date in invoice details, i.e. no attribute "date" for entity "invoice". - I know "Each eye surgeon has one or two minor surgeries in which they work". I know "When a patient requires some treatment, one or more appointments are scheduled". I also know "At any one time there is only one appointment for a particular surgery and a particular surgeon". Now I hope I can assume "treatment" is personalized, i.e. every patient would have their own treatment plan which is a series of surgeries, but I am asked "Which treatment is most popular". So, is "treatment" a pre-defined bundle of one or more surgeries, and patients would just choose from the bundles? Or do you mean "Which surgery is most popular"? - I know each appointment has a surgery. I also know the invoice generated at the end of an appointment will include one to five lines that identify the services given during the appointment. But how does "appointment", "surgery", and "service" relate with each other? Is a surgery made of one or more services, or services are independent with surgeries and just add-ons for an appointment? - What's the "treatment room" doing here? There is a constraint "Please note that more than one surgeon can use the same room at different times. However, a surgeon will only use one room at a time", but I do not know how should it be represented in my model. I guess I will eventually be required to implement my model in SQL, and in this case it is possible to fulfill the description by storing the room number as a column in the appointments table and apply some unique constraints. Can I model in this way: "room" is not an entity, while "room number" is an attribute of entity "appointment"?

Hi, As discussed in the class on Monday, I want the students to have a discussion with each other (either in person or on this forum) to try to resolve ambiguities. If there are still some confusions, I'll respond after Thursday. Mehwish

I still do not understand what a treatment is and how does it relate to a service or a surgery.

me too