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.
If you have any assumptions, please make them explicit. However, ensure that the logical dependencies remain intact. For instance, if the clinic decides to update how they store client numbers from 6 digits to 12 digits, this update should logically ...
Please adhere to the provided specification.
While you can include additional attributes such as 'appointment id' for entity identification, ensure that your database maintains all relationships and constraints as outlined in the project sheet.
Hi Zhulin,
I have copied this from the project sheet "At the end of an appointment, an invoice is generated."
So, after every appointment an invoice is generated.
Hope this helps.
Send an email to the unit email address and tell about your accidental submission, attaching your SQL queries in a zipped folder, to ensure you have a timely submission. However, I'm unsure if any penalty applies in this scenario.
ANONYMOUS wrote
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...
Hi Sammy,
A patient customer visits the clinic for the first time, their details are inserted into the system, and a client number is generated. Subsequent visits by the same patient customer would refer to the existing client number.
Now back to your ...
Hi,
There is a considerable amount of subjectivity involved in the project's conceptual modelling. Therefore, it's acceptable to introduce additional attributes if they contribute to addressing the questions outlined in the project sheet.
Also, ensure ...
Hi,
The question is Display the minimum on hand "times" price in a column called min....
I hope you can decipher it from the question. Hint You need to get minimum of (something "times" something)
ANONYMOUS wrote
Hi Thanh,
You are right, Powershell display Null as blank. The shared results are just self-checking hints.
Your code will be graded using an auto-grader that will run your queries on Powershell. So you don't need to worry about displaying NULLs as do...
Yes, you need to write a SQL query for each question.
It's up to you how you like to display your results on your console. Please make sure, while submitting your query file, it should only contain SQL query (i.e., starting from Select and ending with...