SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 04 Jan 2018 My Price 10.00

solution to meet the teacher's requirement according

I would like to revise my solution to meet the teacher's requirement according to his comments. Please see the attached assignment and see my solution attached also. Also, read the teachers comment to come out with a solution that meets his requirement.

My Solution Was based on Assignment F solution what is below

Teachers comments:

Your commentary and the lists of data items are in the way of the reader seeing your logical data model clearly. Best to show only the completed entities and relationships statements. Put any other commentary after the data model is shown.

Why do you not have an Actor entity listing each actor name?

The Movie_Actors entity appears to be an associative entity between actor and movie. Why is this needed? In this problem, there are no non-key fields that need to be stored in such an entity. An M:N between Actor and Movie would suffice.

MovieName should not be in the key of Showing. Look at the published solution for Assignment F.

Prices should not be in the Showing entity. Fails 2NF test,so your model is only 1NF. Look at the published solution for Assignment F.

The Acts-in reln is not correct.

The Shows-in reln says that any showing occurs in more that one place. Not true. It also says that any theatre can only hold one showing ever. Not true.

You appear to have included a diagram generated from Microsoft Access. That is not a valid E-R diagram.

Please correct and resubmit.

Please see the Assignment Solution F Below provided by the teacher, which my problem should be based on.

Please see both my solution and the assignment itself. Apparently, the teacher does not like my solution. So according to his comment I want to revise it to meet his requirement.

A solution to the Film Showings problem (not necessary the only solution)
Verify for yourself that this solution handles all requirements A-K of the problem.
DIRECTOR ( Director(K) )
ACTOR ( Actor(K) )
FILM ( Movie-name(K), Review, Rating )
PRICE ( ( Date, Time, Theatre )(K), Adult-Price, Child-Price,
Student-Price, Senior-Price )
SHOWING ( ( Date, Time, Theatre, Screen# )(K), Adult-Count,
Child-Count, Student-Count, Senior-Count )
THEATRE ( Theatre(K), Number-of-Screens, Address, Phone )
TOWN ( Town(K) )
contains: TOWN 1:M THEATRE
directs: DIRECTOR 1:M FILM
stars-in: ACTOR M:N FILM
shown-at: FILM M:N SHOWING
price-for: PRICE 1:M SHOWING
shows: THEATRE 1:M SHOWING
charges: THEATRE 1:M PRICE

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 04 Jan 2018 01:01 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)