Thoughts on exam?

[Ruzzah112]

Oh, right, didn't think about that. Anyway it specifies that it is a data table. I was hesitant to write a spreadsheet formula, even though I was dying to..

did you like the sketch/annotation question? I thought it was good.
For dotpoint two I had payments through secure payment systems e.g PayPal and through https, and dotpoint three as members need to register to be part of the community which would reduce phishing/spamming bots.

For the annotation I literally drew atarnotes design with books instead of tutors at the top with price tags and link to shop, hope it was good enough

[lala1911]

For the annotation I literally drew atarnotes design with books instead of tutors at the top with price tags and link to shop, hope it was good enough

Wow, same here.

[MJRomeo81]

Another dodgy question from VCAA imo.

Wish I had more time to really sit down and look at this question, but if we had to fully normalise the relation it would look like this:

CAPTAIN (CaptainID, CFirstName, CLastName, CPhone)

BOAT (BoatID, BoatName, BoatLocation, BoatRate, CaptainID) --- A boat has a captain. A captain can be the captain of many boats. 1:M relationship

BOATHIRE (BoatID, BoatHours, CPay)  --- By knowing the BoatID, we know the captain due to the implied relationship.

But the question only asks for 2NF.

For a relation to be in 2NF:

*Must be in 1NF (no repeating groups, atomic values only, PKs defined)

*No partial dependencies (every non-key atttribute must be fully dependent on the entire key)

1NF:

BOATHIRE (BoatID, CaptainID, BoatName, BoatLocation, CLastName, CFirstName, CPhone, BoatRate, BoatHours, CPay)

(atomic values, no repeating groups, PKs defined)

2NF:

BoatName, BoatRate and BoatLocation are not dependent on the entire key. Same as how CLastName, CFirstName, and CPhone are ONLY dependent on CaptainID, and NOT BoatID.

BOAT (BoatID, BoatName, BoatLocation, BoatRate, BoatHours, CPay, CaptainID )

CAPTAIN (CaptainID, CLastName, CFirstName, CPhone)


I THINK this satisfies 2NF. Only had a quick look at the question (my apologies).

Now the question doesn't state 3NF but it's VERY CLEAR this relation isn't 3NF due to the transitive dependency (a non key depending on another non key). In this case, CPay depends on BoatHours. (BoatHours -> CPay). Every time you need to create a new insert of Boat, you need to provide BoatHours and CPay (insert anomaly).

Then we would get:

BOATHIRE (BoatID, BoatHours, CPay)  --- Please note the question doesn't ask about 3NF.


In summary I THINK this is 2NF:

BOAT (BoatID, BoatName, BoatLocation, BoatRate, BoatHours, CPay, CaptainID )

CAPTAIN (CaptainID, CLastName, CFirstName, CPhone)

[LaternBall]

Reckon anybody will post up the solutions for the multiple choice?

During the wait, how about we share what we answered and then compare them?

Spoiler

Mine were:
1.C
2.C
3.A
4.B
5.A
6.B
7.C
8.A
9.D
10.B
11.C (not sure)
12.A
13.D (not sure)
14.D
15.A
16.D (Guessed)
17.C
18.B (Got too confused with this one)
19.C
20.B

@MJRomeo81
When I read the question, had somewhat the same situation. I could not figure out where CaptainsPay and BoatHours goes, after all, it is asking to only create two tables; if it was 3NF, now that would be a completely different story.

I just shoved CaptainsPay into CaptainInfo Table and BoatHours into BoatInfo. 

Hopefully I can still scab some decent marks off that. 

[lala1911]

11 was C I think. You would use a dropdown box but I don't think its a method of validation.
12 was A.. unfortunately I misread the question lol.
16 was D.. pretty sure.
18 was C I think.. they only 'deleted' instead of damaging or overwriting the HDD.

For question 10.. what would be the most suitable graph? I thought scatterplots depict trends best.. but then you aren't given data over a period of time, so that would be useless. Would a pie graph be suitable?

[nosuperstar]

During the wait, how about we share what we answered and then compare them?

Spoiler

Mine were:
1.C
2.C
3.A
4.B
5.A
6.B
7.C
8.A
9.D
10.B
11.C (not sure)
12.A
13.D (not sure)
14.D
15.A
16.D (Guessed)
17.C
18.B (Got too confused with this one)
19.C
20.B

Alright~
Mine were:

Spoiler

1.D (know i stuffed this one up)
2.C
3.A
4.B
5.A
6.B
7.C
8.A
9.D
10.B
11.C
12.A
13.D
14.B (unsure)
15.A
16.D
17.C
18.C
19.A (know i got this one wrong)
20.B

I sent Mark Kelly the copy of the exam uploaded here previously so he can give us some suggested solutions.

[Jandrews1]

Getting technical here, with the 2NF question i dont believe we needed a BoatID Field. As the name is like a licence plate, only one boat can be registered too a name.

[nosuperstar]

Getting technical here, with the 2NF question i dont believe we needed a BoatID Field. As the name is like a licence plate, only one boat can be registered too a name.

I didn't do the IDs for 2NF, the Swinburne IT lecture I watched mentioned IDs as part of 3NF so I didn't do it.

[MJRomeo81]

My suggested solutions:

1:   D
2:   C
3:   A
4:   B
5:   A
6:   B
7:   C
8:   A
9:   D
10: B
11: C
12: A
13: D
14: B (it could be D, but I remember determining evaluation criteria falls under the 'Design' stage in PSM. Dodgy question).
15: A
16: D
17: C
18: C ("select and delete"...this does not remove the data from the disk.)
19: C (This years WTF question...what are they thinking? A legend would be nice to indicate what the shaded areas represent and the non-shaded).
20: B

You won't be penalised for not having BoatID. However, what is the unique identifier for captain? CaptainID is far more appropriate than a composite key of LastName and FirstName (since there are many John Smith's, etc.). It's fine to assume boatName is unique.

PK being identified is part of 1NF.

[MJRomeo81]

As for Q12,

a) Text data is sorted alphabetically, not numerically.

b) Sorting numerically would help.

How to test: Insert new chapters (pick some sample values)

c) Two parameters to the search. 1) Sort by GIF file format. 2) Size <50kb

[lala1911]

Also, I can't be the only one who initially read PINES wrong for Question 9.

[nosuperstar]

Hey everyone, Mark Kelly has put up suggested solutions for the multiple choice.

http://vceit.com/p/postmortem-2013i.htm

[RakiZtahX123]

I put pin but all of them clearly were not a physical measure.

My teacher is an assessor, is gonna argue that everyone who answered it should get a mark as it didn't have a legit answer.

Swipe card is right because it was asking for a physical 'device'

[lala1911]

11 is C I am pretty sure. I don't think dropdown box is a validation technique. It's more of an option. Whenever I forgot to fill in the country when purchasing something online, it says * Required Field.

[LaternBall]

Hey everyone, Mark Kelly has put up suggested solutions for the multiple choice.

http://vceit.com/p/postmortem-2013i.htm

Thanks 

Seems like he isn't quite happy with Q18 and Q19. I do hope VCAA will give free marks to those who answered after actually carefully examining the dodgy questions, as the same thing has happened in previous years.

11 is C I am pretty sure. I don't think dropdown box is a validation technique. It's more of an option. Whenever I forgot to fill in the country when purchasing something online, it says * Required Field.

Well, after reading Mark's explanation, D does seems like the most plausible answer. You can enter anything into the required field as opposed to a dropbox where you can select acceptable options.