Thoughts on exam?

[lala1911]

Thoughts on the exam?
I found it more difficult compared to the prcious years. Same content examines again like usual.
Question 12 was my only major struggle apart from a few MCQ.

[AndreF23]

I found it to be surprisingly easier than the other years, only struggled on a couple of MC questions.

[JohnJohn]

How did yo

[JohnJohn]

How did you guys went on the normalisation question? I struggled ...

[RakiZtahX123]

what was the answer for question 2 multiple choice,,,, was it project-based or knowledge-sharing?

[Aaron]

Good work guys, another one done and dusted. Good luck to all.

Anyone have a copy of the exam booklet? Curious to see the type of questions on there.

[nosuperstar]

what was the answer for question 2 multiple choice,,,, was it project-based or knowledge-sharing?

I put down knowledge sharing, not too sure though, I was contemplating between project based and knowledge sharing too.

Overall I found it relatively easy, very good exam, parts of q12 were a bit complicated but still, quite decent.

[lala1911]

The problem with Q1 is that those questions are so ambiguous. Oh.. and normalisation was so hard. That was what I struggled with most. I had a rote learnt answer for b), but a) im hoping for 1 mark.. Brb scanning my exam.

[Ruzzah112]

I found the exam had been dumbed down quite a bit, I didn't understand why we had to make only two tables for the normalisation because pay shouldn't be in the captain or boat table :/

Answer to mc 2 was project based because viewers can only see progress and can't contribute or socialise.

How'd everyone do? I finished with 45 minutes to spare and went through and fixed 3-4 mistakes.

[lala1911]

45 mins to spare as well. I just really struggled with normalisation and Q12.
Ruzzah, what tables did you do?

[Ruzzah112]

45 mins to spare as well. I just really struggled with normalisation and Q12.
Ruzzah, what tables did you do?

Since it stated split it into two tables, I made boats and captains

Boats: BoatID, BoatName, BoatLocation, BoatRate
Captains: FirstName, LastName, Mobile, BoatID, BoatHours, Pay

I drew a line from BoatID to BoatID and labeled the one at captains an infinite sign and 1 next to the boat line. 1 to many relationship, I hope I did it right :/

[nosuperstar]

Since it stated split it into two tables, I made boats and captains

Boats: BoatID, BoatName, BoatLocation, BoatRate
Captains: FirstName, LastName, Mobile, BoatID, Pay

I drew a line from BoatID to BoatID and labeled the one at captains an infinite sign and 1 next to the boat line. 1 to many relationship, I hope I did it right :/

I don't think you needed to put the relationships, I didn't at least, with 2NF and the question, I assumed you needed to make 2 tables.

I did Captains: Firstname, Lastname, Mobile
Boats: BoatID, BoatName, Boat Location, BoatRate, Hours, Total

Although the rate, hours and total should be in a 3rd order table, that isn't one of the requirements of 2NF, it's a requirement of 3NF, and from there you create relationships.

[Ruzzah112]

I don't think you needed to put the relationships, I didn't at least, with 2NF and the question, I assumed you needed to make 2 tables.

I did Captains: Firstname, Lastname, Mobile
Boats: BoatID, BoatName, Boat Location, BoatRate, Hours, Total

Although the rate, hours and total should be in a 3rd order table, that isn't one of the requirements of 2NF, it's a requirement of 3NF, and from there you create relationships.

I know that it isn't a requirement to make a relationship for only 3NF, there's no documentation stating that, at first I made a third table with hours and total separate and started highlighting information when I noticed it stated two tables, biggest wtf

[nosuperstar]

I know that it isn't a requirement to make a relationship for only 3NF, there's no documentation stating that, at first I made a third table with hours and total separate and started highlighting information when I noticed it stated two tables, biggest wtf

Ah I see. I felt like doing 3NF since it's easier but thought to stick to what was asked ahah. Starting to question whether I was meant to make a relationship now, opps.

[MJRomeo81]

If someone could upload the exam paper I can take a look at this normalisation question.