Just your studentID and yourself (and your group member for part 2 of the project) We already have your submissions. Cheers Mehwish

Do we need to bring anything to the demonstration?

Demonstrations are only for part 2, so come with your project-part 2 partner. ANONYMOUS wrote

What do you do if you did project part 1 with someone and part 2 with someone else?

What do we have to do for the demonstration?

Hi, So if you're attempting to enforce referential integrity, you can do this without triggers. Refer to Ch 17 of the book, or look at the example provided in project description sheet. ANONYMOUS wrote

Hi, I'm trying to create a trigger that any updated attribute automatically reflects in another referred attribute. I'm wondering if this really meet the main requirement of the project?

Did you try creating the base tables first Try to go in order to avoid this problem.

Building database means that for every relation that you have created, you got to build a table, i.e., use create table statements (plus constraints). Remember, relations are tables ) We covered creating tables in Weeks 2 3 (also revised in Week 10...

Yes, the case study is from the same book. The book has been mentioned on the welcome page and the first lecture. If you like you can consult other books as well.

Any referencing style should be fine.

Hi, I've formatted my .txt file such that the order of statements is -DROP Statements -CREATE TABLE Statements -CREATE TRIGGER Statements -INSERT INTO Statements -CREATE VIEW Statements However, I've run into a problem, in which the first table I place int...

i think it's database systems thomas connolly 6th edition

Hi, Someone else also had this question but the response didn't clarify it for me. I was wondering where I can find when we learnt the content required for Project Part 2 - Question B, as I cannot find it in Week 9. Week 9 provides all the content r...

Hello. What reference citation style are students supposed to use in this unit? Is it APA 7? I would like to reference 2 of your lectures in my .pdf report for Project II, but I am not sure if APA 7 is an acceptable standard for the task.

Just looking for directions to the source of the chapters that are mentioned throughout the lectures, in particular the second logical modelling lecture references a chapter 17, but not of where to find this source. any help would be greatly appreciat...

Hi, For the first 3 questions, I suggest that you can write plausible assumptions and go ahead with the model. Also, I would encourage students to get involved in discussions on this forum as brainstorming potential issues solutions is very helpful. ...

Hi, I replied this question over email. Here is what I wrote " Some of the standard sql does not work in sqlite. In standard sql you can use the Alter table statement. In your situation, you will have to save the existing data to a temporary table, dro...

ensure both the file names have IDs of both the students. Project will be graded by us (humans), so you can use any format you like, as long as you have mentioned the IDs. Make sure it is a PDF file D

Different surgeons can have the same qualifications.