Normalization Report
Admin
3NF
Admin ( #admin_id, username,password)
Attraction
1NF
Attraction( #attraction_id, #admin_id, name, type, location, website, admission, hours, description)
2NF
Attraction( #attraction_id, #admin_id)
Attraction_info( #attraction_id, name, type, location, website, XXXXXXXXX, XXXXX, description)
XXX
Attraction( #attraction_id, #XXXXXXXX)
Attraction_info( #attraction_id, XXXX, XXXX, location, XXXXXXX, XXXXXXXXX, XXXXX, XXXXXXXXXXX)
XXXXX
1NF
XXXXX(#XXXXXXXX,#admin_id, XXXX, type, XXXXX, XXXXXXXX, XXXXXXXXX, from_date, XXXXXXX, XXXXXXXX, XXXXXXXXXXX)
XXX
XXXXX(#event_id,#XXXXXXXX)
XXXXXXXXXX(#XXXXXXXX, name, type, XXXXX, location, admission, XXXXXXXXX, XXXXXXX, XXXXXXXX, description)
XXX
XXXXX(#XXXXXXXX,#admin_id)
Event_info(#event_id, name, XXXX, image, XXXXXXXX, admission, XXXXXXXXX, to_date, op_hours, description)
Movies
0NF
XXXXXX (#XXXXXXXX,#XXXXXXXX, XXXX, rating, language, XXXXXXXX, XXXX, XXXXX, XXXXXXXX,cast )
1NF
Movies (#XXXXXXXX,#XXXXXXXX, name, rating, language, director, year, genre, showtime )
Cast_Info (#movie_id,XXXX)
2NF
XXXXXX (#XXXXXXXX,#XXXXXXXX)
XXXXXXXXXXX (#XXXXXXXX, name, XXXXXX, XXXXXXXX, director, XXXX, XXXXX, XXXXXXXX )
XXXXXXXXX (#XXXXXXXX,name)
3NF
Movies (#XXXXXXXX,#admin_id)
XXXXXXXXXXX (#movie_id, name, XXXXXX, language, XXXXXXXX, XXXX, XXXXX, XXXXXXXX )
XXXXXXXXX (#movie_id,name)
Restaurant
XXX
Restaurant(#restaurant_id,#admin_id, XXXX, XXXXXXXX, XXXXXXXXXXX, website, price_range)
2NF
XXXXXXXXXX(#restaurant_id,#XXXXXXXX)
XXXXXXXXXXXXXXX(#restaurant_id, XXXX, location, XXXXXXXXXXX, website, XXXXXXXXXXX)
3NF
XXXXXXXXXX(#XXXXXXXXXXXXX,#admin_id)
Restaurant_info(#XXXXXXXXXXXXX, XXXX, XXXXXXXX, XXXXXXXXX, XXXXXXX)
XXXXXX(#cusine_id,cusine_type, XXXXXXXXXXX)
XXXXXXX
3NF
XXXXXXX(#XXXXXXXXX,#XXXXXXXXXXXXX,#XXXXXXXX,#user_id, heading, XXXXXX, XXXXXXXX, likes, description)
XXXX
XXX
User(#user_id, username, XXXXXXXX)
Theatre
2NF
Theatre(#XXXXXXXXXX, name, location, XXXXXXXX, map)
3NF
XXXXXXX( #XXXXXXXXXX, name,#XXXXXXXXXXX)
XXXXXXXXXXX(#location_id, XXXXXXXX, diatance, XXX)
XXXXX-XXXXXXX
3NF
Movie-Theatre(#XXXXXXXX,#XXXXXXXXXX)
">