Database normilization help (1 Viewer)

S

ShavedCloaca

New member

Local time

Today, 06:17

Joined

Aug 16, 2016

Messages

2

• Aug 16, 2016

• #1

Hi I was wondering if anyoine could give me a hand with a problem i have, im doing some coursework and they have tasked us to normilize data to 3NF but the data we have been given to normilize doesnt seem like its possible.

Platform, Catalogue No. and Title
Number of disks
Synopsis and Review(s?)
Category, Genre, Age Rating, Release Date
Screenshots
User Rating

these are the atributes we have been given, if anyone could help that would be amazing.
Thanks Shaved Cloaca

 

P

plog

Banishment Pending

Local time

Today, 00:17

Joined

May 11, 2011

Messages

11,646

• Aug 16, 2016

• #2

Open ended requests for homework help don't go over to well here. We are happy to help and guide, but not happy to do.

So, how about you post what you have attempted and ask specific questions.

 

jdraw

Super Moderator

Staff member

Local time

Today, 01:17

Joined

Jan 23, 2006

Messages

15,379

• Aug 16, 2016

• #3

What exactly were the requirements given to you?
You have some words, but not in context.

See these links for more insight
http://rogersaccessblog.blogspot.ca/2011/03/problem-of-repeated-columns.html
http://rogersaccessblog.blogspot.ca/2008/12/what-is-normalization-part-i.html

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 06:17

Joined

Jul 9, 2003

Messages

16,280

• Aug 16, 2016

• #4

ShavedCloaca said:

they have tasked us to normilize data to 3NF but the data we have been given to normilize doesnt seem like its possible.

Click to expand...

If it's an exam question then you can be certain you are wrong and it is possible.



Sent from my SM-G925F using Tapatalk

 

Frothingslosh

Premier Pale Stale Ale

Local time

Today, 01:17

Joined

Oct 17, 2012

Messages

3,276

• Aug 17, 2016

• #5

Gotta go with Gizmo on this one - looking at the attributes you have provided, that is absolutely capable of being normalized to 3NF.

 

S

ShavedCloaca

New member

Local time

Today, 06:17

Joined

Aug 16, 2016

Messages

2

• Aug 17, 2016

• #6

would anyone be able to help me get started, i just need to get to 1NF and i should be good from there, im not asking for anyone to do it for me just some hints would be great

 

Frothingslosh

Premier Pale Stale Ale

Local time

Today, 01:17

Joined

Oct 17, 2012

Messages

3,276

• Aug 17, 2016

• #7

If you have to, draw out the relationships on paper.

Assuming that is for software or games, I see more than 5 potential tables.

Try to think about what every object descends from - there is one field in your list that is the ultimate source; it's what the database is ABOUT. Everything else flows from that.