help1402

It's UWAweek 47

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 selected article

Showing 1 of 684 articles.
Currently 111 other people reading this forum.

UWA week 43 (2nd semester, study break) ↓

Practise Exam_ part 2 (all 3)

2:54pm Sun 27th Oct, Mehwish N.

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). You can if you want to. However, make sure to define the primary keys. 3. Regarding "Not NULL". You do need to mention primary keys (also note in sqlite, you specifically need to mention PK NOT NULL). Regarding FKs, it is possible in some cases to have a NULL FK . However, if there is a mandatory participation of a FK, in that case FK will be not null. Also with FKs do mention the actions for ON DELTE and ON UPDATE. 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