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, 1 Day 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 24 Dec 2017 My Price 10.00

change propose destroys current way of working

Question:Hello, I want to revise my assignment to meet the teacher's requirement. Please see the assignment attached.

Below is the teachers comment.

 

 

Feedback to Learner

2/28/17 8:31 AM(a) okay

 

(b) The diagram you show is incomplete because it does not list the verb on each relationship line. The reader has to guess at the writer's intended meaning.

 

     The change you propose destroys current way of working of the business. So, it is unacceptable. You lost which building each apartment is in. You lost that the renters must sign a contract to rent an apartment. You lost that furniture is part of the rental contract agreement.

     Please review carefully the discussion on Redundancy in the Discussion Board.

 

(c) You have a reasonable idea of the business situation, but you did not say what part of the given E-R model enforces that situation. What in the model requires an apartment to be deleted?

 

(d) None of your proposed key will work.  RenterID cannot be in the key because of symbol A. Since there can be many renters on a single contract, we do not know which one to use n the key. Not unique enough.

    You still need to give 3 good candidate keys.

 

(e) Your statement is only true if the relationships around Renter support it. What is the symbols on the relationship lines apply to prospective renters? What is the symbols on the relationship lines apply to former renters?

(f) You came up with 2 of the 3. You forgot that the rental contract will also have an identifier.

 

(g) Your answer to (g) is wrong. We must NOT remove the includes reln (EFGH) between Furniture and Rental Contract. Given that, what is the answer on adding a proposed "used by" reln?

 

(h) No, the apartment WILL be rented. It will be rented by the person who happens also to own the building. There will be a rental contract for that person.

 

(i) Your answer is inconsistent. You said that there need to be four instances of rental contract. But you said that A means the four students can sign one contract. Which is your answer?

 

(j) The answer about furniture is wrong. Look at the question again and carefully review all relationships in the E-R model.

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 24 Dec 2017 12:12 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)