help1402

It's UWAweek 42 (2nd semester, week 12)

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

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.

How do I ask a good question?

Displaying the 2 articles in this topic

Showing 2 of 612 articles.
Currently 120 other people reading this forum.

UWA week 40 (2nd semester, week 10) ↓

insert a new hire - depotID (returned to) (both)

2:44pm Thu 3rd Oct, ANONYMOUS

Hi, When we insert a new hire to HiredVehicle, what value should we put into the foreign key depotID(returned to)?

>From the relationship, it cannot be NULL.

Am I understanding correctly? - the value (DepotID for returned to) will be updated when client returns hired vehicle. So what is the initial value? Can we put a space? Thanks.

insert a new hire - depotID (returned to) (both)

7:29pm Sun 6th Oct, Mehwish N.

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

help1402 articles all ANNOUNCEMENTS recent articles login to post a new article help1402 topics from today and yesterday from the past week from the past two weeks ALL topics, most recent first	login chapter0 unitinfo research projects csforum csse-feedback csbreakdown cssubmit csmarks 2nd semester help fora Algebra Advanced Algorithms Cloud Computing High Performance Computing Intelligent Agents Professional Computing Relational Database Management Systems Systems Programming