Questions and answers: Data base management system

Answer A: Following are the functional dependencies that could be defined from the above-mentioned data:

  • Property Name à Property Type
  • (Property Name, Street) à (Property Type, City, Zip)
  • (Property Name, City) à (Property Type, Street, Zip)
  • (Property Name, Zip) à (Property Type, Street, City)
  • (Property Name, Description, Service Date) à Amount

            These assumptions appear to be coincidence. Hence, it can be ascertain that “Elm ST Apts” could be present in more than one city. There is large number of cities with Elm Street. That is why there is not enough information available to respond. It is better that there should be available one ID column with surrogate key for better functionality. In present situation, it seems that given service could be assigned to same dates with properties. Last functional dependency would be true if it is regarded as good determinant of property. Hence, following functional dependencies are applicable.

  • Property ID à (Property Name, Property Type, Street, City, Zip)
  • (Property ID, Description, Service Date) à Amount

Answer B:

  1. Not good
  • Property name is not capable to determine service date
  1. Not good
  • There is more than one service on a given name
  1. Not good
  • There is more than one service on a property given name
  1. Not good
  • Service date is not determined by property ID
  1. Not good
  • Description is not determined
  1. Better
  • Service date is properly set up as a foreign key
  1. Not good
  • Service date looks foreign property
  1. Not good
  • There cannot be same foreign keys
  1. Better
  • Relationship is not setup correctly

Answer C: This the best design

  • PROPERTY(Property ID, Property Name, Property Type, Street, City, Zip)
  • SERVICE(Service ID, Service Date, Description, Amount, Property ID)

Addition:

Assignment on Questions and answers: Data base management system By Date: Answer A: Following are the functional dependencies that could be defined from the above-mentioned data: Property Name Property Type (Property Name, Street) (Property Type, City, Zip) (Property Name, City) (Property Type, Street, Zip) (Property Name, Zip) (Property Type, Street, City) (Property Name, Description, Service Date) Amount These assumptions appear to be coincidence. Hence, it can be ascertain that “Elm ST Apts” could be present in more than one city. There is large number of cities with Elm Street. That is why there is not enough information available to respond. It is better that there should be available one ID column with surrogate key for better functionality. In present situation, it seems that given service could be assigned to same dates with properties. Last functional dependency would be true if it is regarded as good determinant of property. Hence, following functional dependencies are applicable. Property ID (Property Name, Property Type, Street, City, Zip) (Property ID, Description, Service Date) Amount Answer B: Not good Property name is not capable to determine service date Not good There is more than one service on a given name Not good There is more than one service on a property given name Not good Service date is not determined by property ID Not good Description is not determined Better Service date is properly set up as a foreign key Not good Service date looks foreign property Not good There cannot be same foreign keys Better Relationship is not setup correctly Answer C: This the best design PROPERTY(Property ID, Property Name, Property Type, Street, City, Zip) SERVICE(Service ID, Service Date, Description, Amount, Property ID) Addition: SERVICE-FEE (Property ID, Service ID, Service Date, Amount) This implies that we need three additional things, which are out of service amount, service date and property ID. Therefore, we need following serves for property. PROPERTY (Property ID, Property Name, Property Type, Street, City, Zip) SERVICE (Service ID, Description) SERVICE-FEE (Property ID, Service ID, Service Date, Amount) This implies that service can be applied to different but multiple dates and property could have service son the same date. It means that applied multiple but different properties required on the same date.

Get Rewriting & Paraphrasing Help!

We have more than 1500 academic writers and we promise 0% plagiarism in your paper.

Paper's Detail

Category Marketing Research
Paper Type APA
Reference Type Article
Words 385

Our Online Writers

Mathematics & Physics

237 Homework Orders Completed

5.0

online

Study Table

Australia

Dear respected Client, I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. …

Mathematics & Physics

207 Homework Orders Completed

5.0

online

Helping Door

Pakistan

Dear respected Client, I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. …

Business & Management

237 Homework Orders Completed

5.0

online

Homework Specialist

United Kingdom

I am an admired writer in all fields of writing with over 5 years of …

Order Your Homework Today!

We have over 1500 academic writers ready and waiting to help you achieve academic success

Private and Confidential

Yours all information is private and confidential; it is not shared with any other party. So, no one will know that you have taken help for your Academic paper from us.

Our Customers Rating

Order Now

Frequently Asked Questions

Private and Confidential

Client’s all information is private and confidential; it is not shared with any other party. Even, we don’t ask client name and give user name to his/her profile. So, no one will know that you have taken help for your Academic paper from us.

Payment Safeguard

We only accept PayPal as our payment method. It is 100% secure. As, We don’t take and store any Credit/Debit card information.

Plagiarism Free

It is guaranteed all your Homework/Assignments Solutions are plagiarism free and original. Writers here charge for their efforts not for Copy/Paste work and TOS management takes strict action against those writers.

Guaranteed Quality

All the writers working here are recruited and chosen after taking strict evaluation of their Academic degrees, Experience and background. Then, they are allowed to work here as providing quality homework solution is our first priority.

24/7 online Writers

Our website is worldwide forum, where 100s of experts all over the world remain online round a clock, so, you can come at anytime and get the help from any of your homework. Even Urgent within 1 hour!

Prices at TutorsOnSpot.com

Prices at tutorsonspot.com are very competitive and low. As, tutorsonspot.com is marketplace so, all the writers bid for getting the work and competition among the writers lowers the price and you get your work done at low minimal prices.

Guarantees

  • Our service provides you with original content that does not have plagiarism in it. We are renowned for providing our customers with customized content that is written specifically for them. If you are thinking, can someone help me with my research paper? You can depend on us to help you out.
  • Our motto is to meet deadlines and deliver your solution right on time.We understand that you want to save your time and we respect it. Regardless of the difficulty, we deliver an unparalleled solution without any delay. Moreover, you get a money back guarantee in case you are not satisfied with our service. To understand this guarantee, check our terms and conditions related to it.
  • We perform a detailed research when writing your paper. With all of our services, we ensure to perform extensive research before creating your solution. Furthermore, if you have any questions, just reach out to our customer service team that is available all the day.
  • It is our primary goal to satisfy you. Thus, if you are thinking: can someone write my research paper? Just contact us and get the best services that you can get.

Homework Questions in Business & Management

Best Service for the Struggling Students

Services For All Subjects

We have experienced tutors and assignment experts from all over the world for all subjects.

24/7 Live Writers

100's of qualified phd tutors round the clock.

Best Price Guarantee

Compare our price. Our services are of highest quality and lowest price, Guaranteed.

Plagiarism Free Work

Your information including personal details are safe with us.We have strict privacy policy.

Safe Payment Options

Pay using paypal though verified gateway for maximum safety, No risk.

100% Privacy Guaranteed

Scan our work with all plagiarism checking tools, Result will always be 0%.

Guarantee Your Academic Success!

Place an Order