KayKayEye
Badges: 2
Rep:
?
#1
Report Thread starter 5 months ago
#1
Pretty easy paper. Simple Movie Maker/Audacity exercises. Very little Excel and a huge 42 mark Access exercise which required normalisation to 3NF.
0
reply
Lumosz
Badges: 1
Rep:
?
#2
Report 5 months ago
#2
How did you do the 3NF, what were your fields and tables?
0
reply
Jacob2468
Badges: 1
Rep:
?
#3
Report 5 months ago
#3
How many tables did u create when putting it into 3NF
0
reply
Luciferrr
Badges: 10
Rep:
?
#4
Report 5 months ago
#4
(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?
0
reply
Unkonwn
Badges: 5
Rep:
?
#5
Report 5 months ago
#5
yea thats wrong you should be having 4 tables.
0
reply
apple7171
Badges: 12
Rep:
?
#6
Report 5 months ago
#6
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.
0
reply
Unkonwn
Badges: 5
Rep:
?
#7
Report 5 months ago
#7
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.
0
reply
Luciferrr
Badges: 10
Rep:
?
#8
Report 5 months ago
#8
It was 4 tables, I believe and I realized that after doing the exam.

Yeah it is speeadsheet
0
reply
Unkonwn
Badges: 5
Rep:
?
#9
Report 5 months ago
#9
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
0
reply
lailaelsarky
Badges: 1
Rep:
?
#10
Report 5 months ago
#10
what were the 4 tables made up of?
(Original post by Unkonwn)
yea thats wrong you should be having 4 tables.
0
reply
Luciferrr
Badges: 10
Rep:
?
#11
Report 5 months ago
#11
(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.. ✌🏼
0
reply
Luciferrr
Badges: 10
Rep:
?
#12
Report 5 months ago
#12
(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
0
reply
lailaelsarky
Badges: 1
Rep:
?
#13
Report 5 months ago
#13
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.. ✌🏼
0
reply
lailaelsarky
Badges: 1
Rep:
?
#14
Report 5 months ago
#14
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
(Original post by Luciferrr)
I'm guessing it.
But it should have been
-Employees
-Venues
-Jobs
-Addresses
0
reply
Luciferrr
Badges: 10
Rep:
?
#15
Report 5 months ago
#15
(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
That's still better than having 3 tables like me
0
reply
apple7171
Badges: 12
Rep:
?
#16
Report 5 months ago
#16
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
0
reply
apple7171
Badges: 12
Rep:
?
#17
Report 5 months ago
#17
Mine was exactly 42 seconds

(Original post by Unkonwn)
how long was the video clip?
0
reply
Luciferrr
Badges: 10
Rep:
?
#18
Report 5 months ago
#18
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
0
reply
Luciferrr
Badges: 10
Rep:
?
#19
Report 5 months ago
#19
I don't how people got that. Coz won't the transitions change the time?
(Original post by apple7171)
Mine was exactly 42 seconds
0
reply
apple7171
Badges: 12
Rep:
?
#20
Report 5 months ago
#20
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.
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

University open days

  • University of Bristol
    Undergraduate Open Afternoon Undergraduate
    Wed, 23 Oct '19
  • University of Exeter
    Undergraduate Open Day - Penryn Campus Undergraduate
    Wed, 23 Oct '19
  • University of Nottingham
    Mini Open Day Undergraduate
    Wed, 23 Oct '19

Have you made up your mind on your five uni choices?

Yes I know where I'm applying (116)
65.91%
No I haven't decided yet (36)
20.45%
Yes but I might change my mind (24)
13.64%

Watched Threads

View All