No marks will be deducted for minor spelling mistakes or missing semicolons. Minor errors in opening closing brackets single double quotes will be ignored if the rest of the query is correct. Please make sure the order of statements is correct. For i...

1. Someone also asked this question on the email. Since all books can be up for sale and loan, you do not need to include a flag. However, if you include a flag, that is also fine. 2. No, you do not need to define alternate keys (recall the lecture)....

Hi, I do not agree with your observation. The first question about multiplicities is from conceptual modeling that was covered before the mid-term. Also, the first few questions in SQL are from topics that were covered before the mid-term. Cheers

No, alternate keys are not important, but you need to include primary keys and foreign keys in the logical model.

Hi I have added a clean copy without solutions. Cheers

I went through the recording and that is all you need for implementing views in sqlite. Hence I made the note under sql videos that the recording is under the lecture recording.

Hi, Students were called in for the interview on 10th October. If you were not called in via email, you do not need to worry about it. Cheers

Wednesday 1630 hrs. Microsoft Teams Need help? Join the meeting now https teams.microsoft.com l meetup-join 19 3ameeting ZmVkYmFmNTUtNmVjYS00OGRjLTk2NDQtYjVhZGY4MjFiMzc2 40thread.v2 0?context 7b 22Tid 22 3a 2205894af0-cb28-46d8-8716-74cdb46e2226 2...

The marks will be available on this thursday on csmarks, i.e., on 24 Oct 2024.

If you are preparing for SQL, you are following the rules of relational algebra. Yes, it is included, but I cannot give away the final exam )

Hi, It is there now ) In fact you can also find it under the solution for practice exam. The solution was discussed in 07 and 09 Oct lectures. Cheers

Hi, Please check now. Also note if you need to see how we arrived at the solution, you can watch the recording from 7th and 9th Oct.

In the afternoon, when we made it two attempts, the penalties were removed.

Thank you. We will check that.

It was deliberate not to post the schema, so that people do not put it in AI and generate the answers. I also categorically discussed and mentioned in announcements that you were not supposed to discuss the test anywhere. It comes under academic misc...

I am aware of this. We are going to ignore that question.

We have provided the table names that you are supposed to use. They match with the ERD. Any bridging tables have also been named along with PKs.

This is what I have mentioned in the instructions "Please use the case study and ERD provided to you to answer this part."

Except for any general comments, you are not allowed to discuss the test with each other or on the forums. I made that clear. If you have queries, you should email them to the teaching team.

If you remember in the class we had discussions on whether you can create unique PKs or not. A number of students did that and some did not. Hence, where we felt necessary, we have provided some key attributes and PKs.

Hi, You had to derive that schema from the ERD provided to you. Where we felt necessary, we have provided some key attributes.

Please follow the ERD model that was provided. In case there are PKs that are not specified, we have mentioned them under various questions.

Hi, No you do not need to use the average in Q7. Can you please post the actual question here, because i feel you may be referring to a different question.

Hi, No issues. I also mentioned in an announcement that it is expected that your understanding about the project would improve during the take home test, so please attempt the questions even if you did not implement certain tecnhiques in the project ...

Hi, Multiple ways to address this. Either you put a null, or you populate it correctly with the return depot (that's what happens in real life , one chooses the return depot when they make the booking). Cheers

Hi, The examples that you have mentioned are going to work in sqlite (see the code below). However, this is not going to work with other dilects of SQL. You can use it in sqlite if you want to. In the exam, if you have written a query that either work...

Hi, Your submission is in the draft format. You did not submit it. You can submit it under late submissions links. There is no penalty. Cheers

That's okay as long as you know what's going on cheers

Just 3-4 records for each table are sufficient. You will be questioned on your attempt and your understanding. Dummy data would not matter

Yes, after the take home test

Hi, Forget what the class mates are saying, look at the unit outline (what does it say?) "submitted via Moodle-Assessed via a take home test" Also look at the project question sheet (what does that say?). " Following the submission of both parts ...

Hi Can you please email me your first solution? I can see that right now you have submitted the intended solution. Cheers

If you have already submitted it then do not submit again. If you have not submitted it then please submit by clicking the late submission links.

If you have already submitted it then do not submit again.

Test will have 28-30 theory based MCQs and 10 SQL based questions. If we decide to interview you, it is expected that your code is running and you are able to explain your work.

Sure Please make individual submissions (though they will be similar). Also attempt the test individually. Cheers

- Same street address can be in different postcodes so a street address is not determined by postcode (nor vice versa). E.g., 1 Other street Nedlands 6009 and 1 Other street Perth 6000. - Phone numbers Email Follow the rules from the lecture )

Hi, This was likely a glitch. You can access it now

Thanks Mia.

I delved into that particular part in the video, because it was going to be in the mid-term. That video was released before the mid-term.

At the beginning you can include DROP statements for all the tables in your database. This to ensure that when I am going to run your database, I do not have any existing tables with the same name Cheers

Hi, If the vehicles were picked and dropped at the same location, there was no need for two relationships. In reality, one can pick and drop the vehicles to separate depots. Also, this sample ERD is one way of solving the project. Students can offer ...

Hi, The standard approach has been discussed in the lecture under logical modeling. However, it is also possible to deviate from the standard approach. You need to look at the connections between the subclasses superclass with rest of the ER model. I...

Time duration Some students made a valid argument about issues with the internet during this week and were wondering if the situation continues next week, then that may impact their performance. Just to put everyone at ease, I have extended window f...

Time duration Some students made a valid argument about issues with the internet during this week and were wondering if the situation continues next week, then that may impact their performance. Just to put everyone at ease, I have extended window f...

Hi, Yes triggers and views are included. You need them for the project so please practice them. Cheers

Hi, I followed up on the form. The answer for Q7 is c. You have been given a mark for that. For Q18, the answers were either A or E. That was not a guess game. As far writing the correct answer on question paper is concerned, it will not be accepted ...

ANONYMOUS wrote Sorry, it is off by 60 seconds. It is 03 Oct 11 59 pm. If you want, you can put a screenshot, but it is not required. No videos please ). We are going to invite about 10 students for an interview. If you have a thorough submission, ...

Hi, You cannot submit a .db file because in a .db file we cannot see your code. Please create either a .sql or a .txt file to run your queries. Eventually, the final submission will be in .txt file. You can simple rename your .sql file. Cheers

Date and ClientID, together may work, but you can also create a new ID attribute.

Please follow the instructions mentioned in the title for that recording.

Thanks for pointing out the issues. Let me answer these one by one. This was a human error. I missed it, however, just follow what is there in the ERD. You can use any data type. Yes, there is an extra tab. I'll update that in a while. Sure. You can ...

Why are you lobbying for Q18? Those who selected A, did so because they saw a missing semi-colon in iii. Those who selected E, they looked at the query in whole (iii), which was syntactically correct, except for a missing semi-colon. That is why both ...

Hi, Yes please practice some views and triggers on your data. In the take home test there will be at least one question on each of these. We are going to study these topics on Monday 30th Sept. Cheers

Hi, It was a public holiday. Some videos have been provided in the Lecture notes section.

Please check your marks now. cheers

c is the right answer

Hi, It was a public holiday. Some videos have been provided in the Lecture notes section.

Imagine a database and I ask you to find information on room "1234" in the past two years. That room is supposed to be on multiple lease documents in the database to get information about who leased that room. This is the same as leasing a house. A h...

Hi, Yes as discussed in the logical modeling, you may need to create new relations. Cheers

Further to my last reply, I request students not to run their imaginations wild while trying to guess the answers they filled-in during the exam D The scanners are pretty good at UWA. There could be other issues, such as the scanner not recognizing ...

Thanks for letting me know. Can you please fill out the form? Please mention in the description what you have mentioned here. cheers Mehwish

Hi, I did put those attributes under Vehicle type. No you should not need the capitalisation. Cheers

Hi, Subclass is actually a special type of the superclasse. Whereas, a weak entity may be dependent for its existance on another entity, it may still be identified as an entity on its own, in combination of the attributes of another entity.

That's a good idea. I'll post the answers this week and then in the class we can discuss each question )

There was no lecture on Monday. The time-table shows that the lecture was on 18th september. You should be able to find the recording now. Cheers

We resolve many to many relationships usually by create a new relation (table). However, that is part of the logical modeling.

The first part of the unit outline show indicative weights that are in the handbook and do not change. From semester to semester, we change the weights slightly depending upon various factors (student feedback, performance of students, chatGPT etc.)....

Hi, As we discussed in the lecture that you can do the project all by yourself. Please start asap as this is not a project that you can do at the last minute. Cheers

Just replied in that thread.

Hi James, Sorry that we missed this. In the first part of the project, we are focusing on the conceptual design. Now that you have started logical modeling, we are going to create a new table where we see a relationship. While dealing with concept...

It was a server issue. Please check now. Cheers Mehwish

Ideally you should get the notification for both as that is what I have set in the system. Please try to submit again, and if you do not get the notification then let us know here. Cheers

Yes, that is a very good point Though you do not have to include invoice right now, in the second part, I'll show that business requirements can change and suddenly the client realises that they have missed some requirements. Invoice is coming in pa...

If I have understood your question correctly, then I am afraid your interpretation is not correct. Multiplicity means how many times an entity can participate in a relationship. In the class we did an example on newspapers and propertyForRent as two ...

Hi, Please check now. Cheers

No, please do not mention foreign keys in the data dictionaries. Basically what you are going to write in the data dicitionaries will be carried to your ERD. Cheers

"has" can be a relationship name.

No not an issue since it was school administered test. Cheers

Final exam will be closed book. Cheers

It is called UML (unified modeling language). Yes a ternary relationship is represented by a diamond. However, entities are represented by rectangles. Please also make sure you know how multiplicities are represented. Cheers. ANONYMOUS wrote

Hi, First of all I did not create this question, but let's try to solve it together. Please see slides 33 if the lecture. The number of tuples in the resulting relation (after cartesian product is applied) are number of tuples in the first relation t...

You can check now under week 6. Cheers

Hi, 1. While using sqlite, boolean datatypes are converted to integers. For this question you could have instead used an integer. 2. Pi underscore (column names), indicates which columns to display. Just writing the name of the relation without Pi mea...

Hi Tim, Please check your mailbox. An email was sent to you. Regards Mehwish

Hi, In principle the AND and OR should not give the same result, however, given the tiny amount of data the sample file has, it may give you the same result. You can add more test data to test your queries on your own computer. The where clause will ...

)

Already answered on forums Content - Theory Everything that we will cover till the Lecture in week 6 (26 Aug 2024). Topics include Introduction to Databases Relational Model Relational Algebra ER Modeling (Wk 4) Enhanced ER Modeling (Wk 5-6) - SQL Eve...

Did I not emphasize enough yesterday that logical or physical database design was not part of the exam? We did not study anything related to those phases. We just did an intro. Mehwish

Try not to add extra columns or attributes. Only do that if there is no other way out.

Yes, we'll discuss them in the class tomorrow. I'll also upload the solution before the class. The solutions for the first two worksheets are uploaded (ref left pane). Cheers

Hi, We are going to do a case study on Monday 26th August, please watch that. In short description is a summary about entity attribute relationship. Occurrence is an example (a hypothetical one). Aliases It is alternative-name for entity attribute r...

Yes, there's no penalty on multiple attempts. This is to encourage students to try the solution without worrying about losing marks.

Hi, I have opened the registration. You can still attempt lab 2 and 3. Cheers

Hi, Did you try to find a project partner in the lecture hall? I am sure there are many other students who are looking for project partners. Cheers Mehwish

Hi, Thanks for pointing out the two typos. Moodle does not normally allows to correct the typos once the quiz is released. But we will try to fix it. I have updated the description of the lab, just in case we cannot update the text of the original qu...

Very good suggestion ) I have upload a file on moodle as well as one under week 4. You need to create all your tables first before you attempt to load data. Once you have created the tables, use the following command to load the data .read printing...

Hi, Format MCQs (I will guide you in the lecture how to fill an MCQs sheet). There will NOT be any short-answer long answer questions. Content - Theory Everything that we will cover till the Lecture in week 6 (26 Aug 2024). Topics include Introdu...

May be )

Hi James, Thanks for the document. We are taking a top-down approach in this unit and the topic of functional dependencies will come a bit later in the unit, around week 8 when we are going to study normalisation. However, I am impressed that you are...

Hi, The highest grade will be counted. Cheers Mehwish

Hi, The project is scoped in a way that it can be done individually as well. However, besides technical skills, I would like to teach our students some soft skills that have proven to improve critical thinking. Working in a team is therefore useful. ...

Hi, Had you watched Monday's lecture, you would have never looked for Wednesday's lecture ) There is only one lecture i.e., on Monday. Please refer to unit outline and welcome page. However, on 16th Sept (Monday) the lecture hall is not available, h...

Welcome to CITS1402. Please note, the key for enrolling to the moodle server (https quiz.jinhong.org ) should work now. cheers Mehwish