FInal 2015 - INF 551 Final Exam You are to work on this exam on your own You are not to share email or discuss in any way the contents of the exam prior

FInal 2015 - INF 551 Final Exam You are to work on this...

This preview shows page 1 - 3 out of 7 pages.

1 INF 551 Final Exam: You are to work on this exam on your own. You are not to share, email or discuss in any way the contents of the exam prior to Dec 15, 2015. Failure to follow these rules will result in a failing grade in the class. You can complete this exam by hand or electronically. If done by hand, please scan and generate a PDF. Remember, if its hard for me to read, it will be hard for me to grade!! Exam must be uploaded to blackboard by 11:59PM Monday evening. I will deduct 10% from your total score for every 30 minutes after 12AM that your exam is late. Some of the questions are a little open ended. I’m not looking for a long essay, but in each case there are a small number of important points that could be made. Try to make as many of these as possible, in a complete sentence that is in your own words and enough explanation to indicate you understand what the point it. Please explain your answers . If you don’t provide reasoning and you get the answer wrong, its hard to give partial credit! Sign below: I certify that I the work on this exam is only mine and agree not do discuss the contents or answers with my classmates until Dec 15th Name, Date
Image of page 1
2 Question 1: Data Warehousing Lets consider a real estate company that has an inventory of houses and apartments that is is renting or selling for its customers. Each housing unit has a category such as: House, Apt, Condo, TownHouse, Duplex. The company has a number of agents that can show the apartment, and a list of potential customers. Agents can show a house to a potential customer. They have a database that has the following information in it: OWNER(IDOwner, Name, Lastname, Address, City, Phone) UNIT(IDUnit, IDOwner, Category, Area, City, State, BedRooms, Color) CUSTOMER(IDCust, Name, Lastname, Budget, Address, City, Phone) SALESMAN(IDSales, Name, Lastname, Office, Address, City, Phone) APPOINTMENTS(IDSales, Data, Hour, IDUnit, IDCust) SHOWN(IDUnit, IDSales, IDCust, Date, Duration) SALE(IDUnit,IDSales, IDCust, Date, Price, Status) RENT(IDUnit, IDSales, IDCust, Date, Price, Status, Time)
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 7 pages?

  • Fall '14
  • Star schema, Snowflake schema, Network File System, network file, reasonable NFS performance

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes