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 the 3 articles in this topic

Showing 3 of 684 articles.
Currently 57 other people reading this forum.

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

mid semester Q9 (all 3)

5:13pm Tue 1st Oct, ANONYMOUS

Staff ------ StaffID Name Salary BranchID P100 Bluey 5000 A100 P200 Peppa Pig 10000 D200 null DanielTiger 8000 A200 In the above table, can BranchID be candidate key given StaffID as primary key?

mid semester Q9 (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.

> Staff > ------ > StaffID Name Salary BranchID > P100 Bluey 5000 A100 > P200 Peppa Pig 10000 D200 > null DanielTiger 8000 A200 > > In the above table, can BranchID be candidate key given StaffID as primary key?

mid semester Q9 (all 3)

11:50pm Thu 3rd Oct, Kundan J.

But when we consider only above dataset, it can be considered as candidate key as all the datapoints are different. Is my understanding correct?

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