...used to understand the design of the database. This conceptual model is the rough diagram and is not sufficient to identify the datatypes, primary keys, foreign keys, composite keys or compound keys. The entities that are mentioned in this conceptual model are apartment manager, corporate manager, business partner, maintenance, apartment complex, administrator, tenant, apartment, and database. Business rules: * Corporate managers or business managers choose the apartment managers * Apartment managers has to send the daily reports to the headquarters to manage and develop new business strategies * Quarterly generated report should consists of revenue, maintenance, occupancy rate and expenses * Managers has the ability to track tenant information * Managers are responsible for maintenance * Managers should provide lease to new tenants and get rents from existing tenants * Managers should store the tenant information, rental information and maintenance issues * Every tenant need to sign the lease by accepting the terms and conditions * Grace period of five days should be given with a penalty of $100.00 * Administrator has the capacity to take any decisions regarding the apartment complexes (Conger, Hands-On Database, 2012) LOGICAL MODEL: Logical model is more detailed representation of the conceptual model. It includes all entities and attributes that are shown in conceptual model. In addition to these entities, it consists of...
Words: 378 - Pages: 2
...Database Major Topics: • Occupancy rate • Total Revenues in rent • Total expenses in maintenance and repairs • Deposits • Lease Forms • Rent Payment Forms A. History/Introduction: Wild Woods Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. Each apartment complex contains anywhere from 10 to 60 separate apartments of varying sizes. All apartments are leased with a six-month or on-year lease. B. Scope of Work: Creation of centralized database system using SQL to allow Wild Wood apartment complex managers to improve the ease and efficiency with which the apartment managers conduct their daily business. C. Constraints: Primary Key Constraints – Lessee Name, Lease Number Foreign Key Constraints – Lessee Name Check Key Constraint – State Column D. Objectives: To develop a centralized database that the managers of Wild Wood Apartments complexes can use to track the daily business of their apartment building and to prepare their reports. E. Tasks and Timeline: o Gathering Data: Obtain all information regarding Wild Wood Apartments Quarterly reports, Rent payment forms, Maintenance request forms, and Lease forms. 14 days from signing of contract Possession of all data documents from project coordinator o Analyzing Data: Summarizing of all obtained data 20 days from receive date of gathered data Summarization of analyzed data in word document given to project manager.(Signed Document) o Normalization: Organization...
Words: 381 - Pages: 2
...the database are: Lease Form (tracks leases of one apartment complex); Rent Payment Form (tracks rent payment of one apartment complex); Maintenance Request Form (tracks requests for maintenance and apartment manager’s resolution); Sample Quarterly Report (shows revenues and expenses of a particular building, address). STATEMENT OF WORK Project Name: Wild Wood Apartments June 21, 2014 • History: The Wild Wood Apartments are made up of 20 different complexes in Washington, Oregon, California and Idaho with each complex containing from 10 to 60 separate apartments. Leases are from 6 months to a year and the company’s practice is to hire one of the tenants to run the complex, collecting rent, conducting repairs, etc. The company requires a quarterly report to track the lease occupancy, rent payment, maintenance, and revenue and expenses; all of which is done in paper form. The forms are considered time consuming by the property managers, and the corporate office has concerns over their accuracy. A centralized database is being considered to simplify and better manage this data. • Scope: The contractor will include hardware, website, software and data storage support for the headquarters and all property offices that belong to Wild Wood Apartments. The main storage for the data will be offsite and the contractor is responsible for maintaining it. • Constraints: The contractor and the headquarters office of Wild Wood Apartments would have access to all the data, individual managers...
Words: 706 - Pages: 3
...Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. Each apartment complex contains anywhere from 10 to 60 separate apartments of varying sizes. All apartments are leased with a six-month or one-year lease. It is the company’s practice to hire one of the tenants to manage each apartment complex. As managers, they need to admit new tenants to the building, collect rents from existing tenants, and close out leases. The manager also needs to maintain the apartments, conducting any repairs, replacements, or renovations. These can be billed back to the parent company. For acting as manager, the tenant gets free rent and a stipend. The stipend varies depending on the size of the apartment building. Each manager is expected to send a report to the Wild Wood Apartments company headquarters in San Francisco every quarter. This report summarizes the occupancy rate, the total revenues in rent, the total expenses in maintenance and repairs, etc. Currently managers fill out a paper form and mail it back to headquarters. Many apartment managers have complained that preparing this report is a very difficult and time-consuming process. Also, the managers at corporate headquarters have expressed concerns about the accuracy and verifiability of the reports. To allay these concerns and to improve the ease and efficiency with which the apartment managers conduct their daily business, the company is proposing the development of a centralized...
Words: 1360 - Pages: 6
...• History: Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. Each apartment complex contains anywhere from 10 to 60 separate apartments of varying sizes. Each manager is expected to send a report to the Wild Wood Apartments company headquarters in San Francisco every quarter. This report summarizes the occupancy rate, the total revenues in rent, the total expenses in maintenance and repairs, etc. Currently managers fill out a paper form and mail it back to headquarters. • Scope: This report summarizes the occupancy rate, the total revenues in rent, the total expenses in maintenance and repairs. The company is proposing the development of a centralized database that the managers can use to track the daily business of their apartment building and to prepare their reports. • Constraints: None • Objectives: Create a database to assist in the apartment managers to keep track of records and create an accurate report to send to headquarters. • Tasks and Timeline: o Gathering Data: Collect information needed for quarterly reports Time allotted: 1 week Deliverable: Gathered all data needed from coordinator o Analyzing Data: Collected data will be reviewed to create the appropriate database Time allotted: 2 weeks Deliverable: Mapped out plan of action given to the coordinator o Normalization: Organizing all data received, disposing of duplicated and unneeded data. Time allotted: 2 weeks Deliverable: Coordinator...
Words: 283 - Pages: 2
...Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. Each apartment complex contains anywhere from 10 to 60 separate apartments of varying sizes. All apartments are leased with a six-month or one-year lease. It is the company’s practice to hire one of the tenants to manage each apartment complex. As managers, they need to admit new tenants to the building, collect rents from existing tenants, and close out leases. The manager also needs to maintain the apartments, conducting any repairs, replacements, or renovations. These can be billed back to the parent company. For acting as manager, the tenant gets free rent and a stipend. The stipend varies depending on the size of the apartment building. Each manager is expected to send a report to the Wild Wood Apartments company headquarters in San Francisco every quarter. This report summarizes the occupancy rate, the total revenues in rent, the total expenses in maintenance and repairs, etc. Currently managers fill out a paper form and mail it back to headquarters. Many apartment managers have complained that preparing this report is a very difficult and time-consuming process. Also, the managers at corporate headquarters have expressed concerns about the accuracy and verifiability of the reports. To allay these concerns and to improve the ease and efficiency with which the apartment managers conduct their daily business, the company is proposing the development of a centralized...
Words: 681 - Pages: 3
...determine if it will fulfil all your needs of your database. While reviewing the four different databases such as the Oracle 11G, MySQL, IBM DB2, and Microsoft Sql Server 2008 which are all impressive databases, I chose to implement the IBM DB2 database system for Wildwood apartments. The key features that IBM DB2 has are table partitioning, database portioning, massively parallel processing (MPP), Continuous Ingest, Multidimensional clustering (MDC), Aggregates, Multi-Temperature Data Management, Mixed Workload Management, and Control over Workloads. DB2 has a number of performance optimization capabilities that give you the insight and ability to optimize workload execution. (DB2 for Linux, UNIX, and Windows) IBM DB2 meets the requirements for Wild Wood Apartments database so the managers can input the lease information, rent payment, maintenance request and with ease complete there quarterly reports. These capabilities can save you money and lower your risks by helping you to do more work with your existing hardware, ensure Service Level Agreements (SLAs) are met or exceeded and increase DBA productivity. (DB2 for Linux, UNIX, and Windows) The database is user friendly and the apartment managers should have no problem navigating through the system to input the information. This is essential DB2 transparently splits the database across multiple partitions and uses the power of multiple servers to satisfy requests for large amounts of information. (DB2 for Linux...
Words: 628 - Pages: 3
...of Work * History: Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. It is very important to keep track of the activities involved in running the apartment complexes, such as maintenance issues, which apartments are vacant and which are occupied, whether rent is being paid and the like. There is a vast amount of information involved in running a successful apartment complex. The current method of keeping track of this information is outdated and difficult to use. A new database would create a more accurate and user friendly method of keeping track of important business aspects. * Scope: The Wild Wood Apartments tracking database will track necessary business aspects involved in running the apartment complex. The database will track basic information such as apartment complex addresses, revenues, tenants, salaries paid to employees, total revenues and expenses as well as apartment occupancies and vacancies. It will track the leases on file, including when they begin and end, the lease contract number, names of the tenants, the amount of deposits paid and the monthly rent amounts. The database will also track monthly rent payments, including the amount that was paid, the date it was paid, whether or not the tenant was late making payment along with the tenants lease contract number and apartment number. Finally the database will track maintenance reports including which apartment required maintenance, what...
Words: 537 - Pages: 3
...* History: Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. Each apartment complex contains anywhere from 10 to 60 separate apartments of varying sizes. All apartments are leased with a six-month or one-year lease. * Scope: To allay these concerns and to improve the ease and efficiency with which the apartment managers conduct their daily business, the company is proposing the development of a centralized database that the managers can use to track the daily business of their apartment building and to prepare their reports * Constraints: The database will contain only lease, rent payment, and Maintenance Request. Any others will have to be built at extra cost. * Objectives: Create a database that will encompass all of Wildwood Apartment managers requirement for Quarterly reporting * Tasks and Timeline: * Gathering Data: Initial Interviews. * Time allotted: 3 Weeks * Deliverable: A list of scheduled interviews and observations, text of the questionnaires * Analyzing Data: The data gathered will be analyzed to determine business rules and preliminary data modeling. * Time allotted: 2 weeks * Deliverable: List of business rules to be reviewed, basic entities and attributes * Normalization: The data model will be completed with entities and relationships normalized. * Time allotted: 1 week * Deliverable: Entity Relation Diagram...
Words: 334 - Pages: 2
...| Oracle 11G | MySQL | IBM DB2 | Microsoft SQL Server 2008 | Operating Systems Supported | Windows Server 2000, 2003, 2003RT, Windows XP Professional, Windows Vista 64 bit and 32 Bit | Oracle Linux, Oracle Solaris, Red Hat, Canonical, Suse, Debian, Windows 8, 7 Vista, XP, Server 2012, 2008, 2003 | Linux, Unix, Windows | Windows Xp, Vista SP2 Windows 7 both 32bit and 64bit | Interface Supported | Oracle Call Interface | Workbench, Navicat, Sequel Pro, HeidiSQL, phpMyAdmin | Control Center, DOS-like interface, Eclipse-based database developers workbench | Multilingual user interface | Stored Procedures | Single ResultOne Result SetTwo Result Set | Single ResultOne Result SetTwo Result Set | Single ResultOne Result SetTwo Result Set | Output parameters, Return codes, A global cursor | Latest Stable Version and Year of Release | 11g Release 2 (11.2.0.4) 2014 | MySQL 5.6.22 2014 | DB2 10 2014 | SQL 2008 R2 SP2 2014 | Advantages | Ability to group several transactions into the same batch. The Real Application Cluster allows multiple servers to work on the same database. | Free open source relation database, active development team. Database-driven application for the internet | Low Cost Platform Per User, Rapid application and warehouse deployment for business growth | Reduce Cost with Virtualization, Simplify Datacenter Management, Improved Datacenter Security | Disadvantages | Cost, difficult to learn and operate | Dose not support a very large database. Does not support ROLE...
Words: 479 - Pages: 2
...Name: Organization: Age: Qualification: Lateral thinking puzzles that challenge your preconceptions. 1. You are driving down the road in your car on a wild, stormy night, when you pass by a bus stop and you see three people waiting for the bus |An old lady who looks as if she is about to die. | |An old friend who once saved your life. | |The perfect partner you have been dreaming about. | |Knowing that there can be only one passenger in your car,whom would you choose? | 2. Acting on an anonymous phone call, the police raid a house to arrest a suspected murderer. They don't know what he looks like but they know his name is John and that he is inside the house. The police bust in on a carpenter, a lorry driver, a mechanic and a fireman all playing poker. Without hesitation or communication of any kind, they immediately arrest the fireman. How do they know they've got their man? 3. A man lives in the penthouse of an apartment building. Every morning he takes the elevator down to the lobby and leaves the building. Upon his return, however, he can only travel halfway up in the lift and has to walk the rest of the way - unless it's raining. What is the explanation for...
Words: 699 - Pages: 3
...Chapter 2 Solution Manual Outcomes * Review documents to discover relevant entities and attributes for database * Prepare interview questions and follow up * Prepare questionnaires * Observe work flow for process and exceptions Outline I. Gathering Information A. Initial Interviews with Chief Stakeholders B. Review of Business Documents C. Interviews with Stakeholders D. Questionnaires E. Job Shadowing II. Review of Business Documents A. Reasons for Review B. Forms C. Reports D. Other Business Documents III. Types of Databases A. Transaction Database B. Management Information Systems C. Business Intelligence Systems D. Cloud Databases IV. Interviews with Stakeholders A. Preparing for the Interview B. Conducting the Interview C. Note Taking and Evaluating the Interview V. Questionnaires A. When to Use Questionnaires B. Advantages and Disadvantages C. Comparison with Interviews VI. Work Shadowing A. Reasons to Observe Stakeholders at Work B. Looking for Exceptions VII. Documentation A. Business Documents B. Interview Questions and Answer Summaries C. Questionnaires and Summaries Vocabulary 1. Closed-Ended Question | g. A multiple choice question | 2. Domain | o. The purpose or subject of a database | 3. Business Intelligence | g. A Set of tools for analyzing business trends | 4. Exception | j. An Alternate way of doing a process | 5. Form | b. A document for gathering input | 6. Transaction...
Words: 6806 - Pages: 28
...Wild Wood Faculty Farahan Habib Zinnia 4/12/2015 Group project principles of marketing Spring 2015 Team Fantastic 5 ------------------------------------------------- WILDWood Furniture Group project Principles of Marketing MKT202, Section: 14 Faculty FARHANA HABIB ZINNIA (FHZ) FANTASTIC 5 The team members NAME ID Fuad Bin Saif 1411722630 Hossain Ahmed Shuvo 1420947030 Mithila Israt Amey 1411488630 Sohel Rana 1420318030 Ipshita Tasneem Fariha 1410155630 ACKNOWLEDGEMENT The most pleasant part of submitting the report is to get the opportunity. We would like to thank those who have contributed to it a lot. Unfortunately, the list of expression of thanks- no matter how extensive is always incomplete and inadequate. These acknowledgements are no exception. First and foremost we would like to thank almighty Allah for bestowing us the patience and courage to finish this huge task within its deadline. Thanks must go to the team members, whose unflagging patience and astounding capacity...
Words: 3256 - Pages: 14
...The desirability of Whistler Blackcomb and Sochi as winter and summer destination resorts. We can think of Whistler Blackcomb and Sochi as winter and summer destination resorts by having in our mind one historical event for the year 2010 when the Vancouver Olympic Winter Games started in the westernmost province of British Columbia and recently launched the Sochi 2014 Winter Olympics. It makes sense to organize Olympic Games on the territories that can serve as winter and summer destination resorts. Why? To answer this question let’s consider the geography and all necessary infrastructures needed and designed to carry out the whole bunch of sport venues. Host country’s Organizing Committees are responsible for installing necessary infrastructures for organizing the Olympic Games such as Olympic Villages, air-supported domes, stadiums, training ice rinks and other facilities for competing during the games. It also assists with medical services, lodging facilities, means of transportation for the athletes and officials. For organizing Winter Olympic Games which includes alpine skiing, luge, ski jumping host county’s geography should provide mountain chains, and for Summer Olympics that include canoe sprint, canoe slalom or sailing, geographically the country needs ocean, seas and lakes. As it is mentioned in our case, Whistler is a resort town with nearly 10,000 permanent residents and has two million visitors annually. It served as the designated site of Olympic events. To attract...
Words: 848 - Pages: 4
...After a brief research of the latest versions of the following database management systems (DBMSs) on the market: Oracle 11G, Microsoft SQL Server, MySQL, and IBM DB2. I found the following information about each DBMS’s. Oracle 11G The biggest advantage Oracle 11G has is that it can help you create customized database applications. Instead of getting a standardized database program out of the box, you get a program that can be customized to fit your needs. This makes it possible to create a database that only has the features you need. Another advantage is Data Mining. It makes it possible to find relationships in data that would otherwise be difficult to find on your own. As good as the above sounds it also comes with a couple of BIG disadvantages. The biggest would be the cost, if you plan on using the program on multiple computers, you will need to buy licenses for each computer. If you plan on making the software available on many computers, these costs can really add up. Another big disadvantage is it comes with a learning curve; this is not something that you can pick up in a short period of time. Microsoft SQL Server MS SQL Server is a Client-server relational database system, with no UI development tools built in. Some of it advantages are, Maintenance its has lots of tools for maintenance, can do most of it with users in DB. It is user friendly, great security, it minimizes redundancy, and it is very consistent. It also works great on an enterprise scale it is designed...
Words: 758 - Pages: 4
