The Student Room Group
Competition - post a photo you've taken of nature >>
Competition - post a photo you've taken of nature >>
Competition - post a photo you've taken of nature >>

ICT AS Level 9626 May/June 2019

Pretty easy paper. Simple Movie Maker/Audacity exercises. Very little Excel and a huge 42 mark Access exercise which required normalisation to 3NF.

Scroll to see replies

Reply 1
Avatar for Lumosz
Lumosz
1
How did you do the 3NF, what were your fields and tables?
How many tables did u create when putting it into 3NF
Original post by Jacob2468
How many tables did u create when putting it into 3NF


Hey! I got 3 tables and I feel I'm definitely wrong. How many did you get?
Reply 4
Avatar for Unkonwn
Unkonwn
5
yea thats wrong you should be having 4 tables.
I got 4 as well. Most of my classmates however got 3. Not sure right now though because some even got 5 table. Also what was the answer to the last question. The one that asked an alternative if you did not use a database.
Original post by Unkonwn
yea thats wrong you should be having 4 tables.
Reply 6
Avatar for Unkonwn
Unkonwn
5
i guess the answer was to use spreadsheet.

Original post by apple7171
I got 4 as well. Most of my classmates however got 3. Not sure right now though because some even got 5 table. Also what was the answer to the last question. The one that asked an alternative if you did not use a database.
It was 4 tables, I believe and I realized that after doing the exam.

Yeah it is speeadsheet
Reply 8
Avatar for Unkonwn
Unkonwn
5
how long was the video clip?
Original post by Luciferrr
It was 4 tables, I believe and I realized that after doing the exam.

Yeah it is speeadsheet
what were the 4 tables made up of?
Original post by Unkonwn
yea thats wrong you should be having 4 tables.
Original post by Unkonwn
how long was the video clip?


It was supposed to be around 42 seconds. I don't remember the exact time.. ✌🏼
Original post by lailaelsarky
what were the 4 tables made up of?

I'm guessing it.
But it should have been
-Employees
-Venues
-Jobs
-Addresses
yeah that’s what i also got
Original post by Luciferrr
It was supposed to be around 42 seconds. I don't remember the exact time.. ✌🏼
that’s what i did but i split the venue table into two because venue types had a partial key dependency to venue types code. so in total i had 5 tables :frown:
Original post by Luciferrr
I'm guessing it.
But it should have been
-Employees
-Venues
-Jobs
-Addresses
Original post by lailaelsarky
that’s what i did but i split the venue table into two because venue types had a partial key dependency to venue types code. so in total i had 5 tables :frown:


That's still better than having 3 tables like me :frown:
Was it something like this:

EMPLOYEES
-For name
-Surname
-Venue code
-Job code

JOBS
-job code
-job description


ADDRESSES
-Venue code
-Name
-address1
-address2
-Venue type code

VENUE TYPE
-Venue type code
-Venue type
Original post by Luciferrr
I'm guessing it.
But it should have been
-Employees
-Venues
-Jobs
-Addresses
Mine was exactly 42 seconds

Original post by Unkonwn
how long was the video clip?
Not really sure. But I find you right! It makes so much sense compared to my answer. I got 3 tables..
Original post by apple7171
Was it something like this:

EMPLOYEES
-For name
-Surname
-Venue code
-Job code

JOBS
-job code
-job description


ADDRESSES
-Venue code
-Name
-address1
-address2
-Venue type code

VENUE TYPE
-Venue type code
-Venue type
I don't how people got that. Coz won't the transitions change the time?
Original post by apple7171
Mine was exactly 42 seconds
Not really cuz there was only 1 transition we had to add and they had mentioned that the transition had to be 2 seconds long.

Quick Reply

Related discussions

Latest

Trending

Trending

Articles for you