Please consider offering answers and suggestions to help other students!
And if you fix a problem by following a suggestion here,
it would be great if other interested students could see a short
"Great, fixed it!" followup message.
Hi
Today, I accidentally found that I submitted the wrong folder for my project part1 (the folder whose format was not changed to PDF). In this folder, the format of my ER diagram Is PNG, and the format of the four data dictionaries is word document. ...
Oh dear ...
Never do a project in the last day.
Entities there is a text about the clinic case
How to fill those blank templates Workshop 1 and 3 weeks ago.
Student need to go to class, or at least check the online materials weekly, my friend.
Hi
I can't seem to find any info on the project besides the blank templates and the assessment outline, and I have no clue how to fill those in, please point me in the right direction.
e.g. it says list all entities, but I don't know where to find thes...
Yes, you can have a relationship between subclasses.
As far as including foreign keys as regular attributes, do not do that. Whenever, you are doubt, check the ERD in the dreamhome case study.
Cheers
Mehwish
G'day Professor,
There is two CONSTRAINTs that make me very confused on what should I done with it
A ONLY 1 SURGEON( 1 Appointment) IN 1 ROOM IN 1 DATE HOUR
Please note that more than one surgeon can use the same room at different
times. However, a ...
Great, thanks. Also are we allowed to create a relationship between subclasses? I have set up the Client superclass with patient and customer subclasses, so am I able to create a customerID (seperate from the ClientID), that I can link to the patient...
Hi Reuben,
Absolutely, you can have a composite primary key in the Appointments table if you deem it necessary. For instance, if there's a relationship between appointments, patients, and surgeons, you can designate an attribute (think of which attrib...
Can we create a primary key in an instance where there are multiple primary keys (Appointments table). So we can link it to the relevant tables. Thanks