I accidentally submitted the wrong file for lab 3, is it possible to submit again without getting marked down?

Are the strings 'Type' and 'Code' required in the results for question 6 of Lab 3?

Is the sting 'code' and 'type' required in the results?

You need to use a union operator between the two queries. And then use orderby. Note Do not attempt this through subqueries.

Hi, Have we learned all the required content to work on Lab 3 Q6? I noticed it wants us to merge attributes together and concatenate a string of either 'Code' or 'Type' and am not really sure how to proceed. Or am I overthinking it and it is a simple o...

It won't be happened next time. Thanks a lot

Please be careful next time. I'll evaluate the existing submission.

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. ...

Hi Declan, You can find the list of entities by reading the project worksheet. If you need help to get started, come to the labs.

Me too, but lab 1 is auto marking so why it need to be in csmarks D, just open LMS, when it not in LMS then it in CSmarks, simple.

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...

When I log onto csmarks, it says the lab 1 marks are not released yet, is it the same for everyone, or just for on my side? Thanks

Lab 3 is using the same database as Lab 2. I have again uploaded the database files under lab 3. Cheers Mehwish

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

Thanks for pointing that out. I'll fix it. Even if you write lab2 it will not make a difference. Cheers

The Lab3 document says to upload a folder titled "studentID CITS1402 Lab2". This should be "studentID CITS1402 Lab3".

Hi, Lab 3 is on the same printing press case study as of lab 2. So please download the corresponding data files under lab 2. ANONYMOUS wrote

Hi, may I know where can I download the

Yes, but there will be 5 penalty per day. ANONYMOUS wrote