ICT 2012 M/J V12 | Help about the movie database question

[wooowooowoo]

Can anyone tell me all the field name and field type for that question ?
Film's name -
Film's duration
Film's release date
Film format -

Thanks

 

[wooowooowoo]

Film's name - Text
Film's duration - Numeric
Film's release date - Date (lol -.-)
Film format (DVD or Bluray) - Boolean logical


That's what I wrote ^

 

[beewhiz997]

Film's name - Text
Film's duration - Numeric
Film's release date - Date (lol -.-)
Film format (DVD or Bluray) - Boolean logical


That's what I wrote ^

same!!

 

[wooowooowoo]

same!!

Woot! Many people said that boolean for the film's format is not possible. I wonder if they're right

 

[beewhiz997]

Woot! Many people said that boolean for the film's format is not possible. I wonder if they're right

but i think it is bcoz if someone types DVD then the reply wud be YES or NO

 

[wooowooowoo]

I had the same feeling !
Wow, thank god there is someone like me. Feels so good

 

[Hamzeh S]

boolean is right he can choose a dvd or a blueray format i wrote same answers btw

 

[Jisu]

Film Name- text
Duration-alphanumeric cuz it can be written in da form 2 hours or 2:00
Release Date-Date
Format-alphanumeric

this^ is wat i wrote n hope it is rite

 

[Hamzeh S]

i wrote ur answers in the beginning but changed the format to boolean and thought that duration well u can write all duration in hours format so no need for alphanumeric

 

[wooowooowoo]

Film Name- text
Duration-alphanumeric cuz it can be written in da form 2 hours or 2:00
Release Date-Date
Format-alphanumeric

this^ is wat i wrote n hope it is rite

Duration Alphanumeric ? :O

 

[Hamzeh S]

Duration Alphanumeric ? :O

i believe it works both way im not sure i choosed alphanumeric then changed it to numeric but if it was wrong its only a mark

 

[IGCSE O/L student]

Woot! Many people said that boolean for the film's format is not possible. I wonder if they're right

i put number in stock for the field name, and integer as the datatype, instead of DVD or Blu-ray!

 

[Mosaleh]

same!!

I believe you guys are wrong, the rest are right except film's duration, it should be date/time...

 

[beewhiz997]

I believe you guys are wrong, the rest are right except film's duration, it should be date/time...

uh no it wouldnt, its not in a date format...

 

[IGCSE O/L student]

I believe you guys are wrong, the rest are right except film's duration, it should be date/time...

da duration should be integer, i guess!

 

[beewhiz997]

da duration should be integer, i guess!

i did numeric coz it can b like dis 2:30:10

 

[Mosaleh]

no guys, time is supposed to be in date/TIME! it is not only date, there is date/time!

 

[IGCSE O/L student]

no guys, time is supposed to be in date/TIME! it is not only date, there is date/time!

y cant we use number/decimal? n use duration of movie instead of time?