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?

6 articles posted by this person

Showing 6 of 684 articles.
Currently 51 other people reading this forum.

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

Is Relational Algebra part of Final Exam? (all 3)

9:29am Wed 23rd Oct, Hafiz A.

Thanks. My question was mainly regarding learning relational algebra notations (like ) and practising writing expressions? The sample paper doesn't include such questions. If the final exam is like the sample, can we skip these notations and focus...

Is Relational Algebra part of Final Exam? 👍x1 (all 3)

1:42pm Tue 22nd Oct, Hafiz A.

Hi Do we need to prepare relational algebra for the final exam? will there be any question to write any expression in relational algebra for any statement scenario?

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

Splitting Table Depot (both)

11:56pm Tue 1st Oct, Hafiz A.

while checking Depot table for normalization, have following questions - Postcode depends on street address. and street address is linked to DepotID. does this mean there is a transitive dependency here? should I move address to a new table and then l...

Translating super/subclass into sql (all 4)

11:33pm Tue 1st Oct, Hafiz A.

considering practicality of implementation, i would have a combined table with following attributes OwnerNo OwnerType OwnerName 001 Private Joe D 002 Business XYZ PTY LTD 003 Private James and will use OwnerNo as foreign k...

Can we merge / split tables or move items (both)

10:59pm Tue 1st Oct, Hafiz A.

while I was putting dummy data in each of the table to verify - if the table is in 3NF - if the Primary Key need to be changed; for Vehicle Type table, I can see Make Model are taken as composite primary keys, but I can use duplicate values in each of...

mid semester Q9 👍x1 (all 3)

9:48pm Tue 1st Oct, Hafiz A.

ANONYMOUS wrote BranchID wont be unique in some cases. so this alone cannot be a candidate key. imagine having multiple people from same branch appearing in this table of yours.

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