Information Technology > PROJECT FINAL > Southern New Hampshire University_ IT-650-principles of database design Wild Wood Apartments Final P (All)

Southern New Hampshire University_ IT-650-principles of database design Wild Wood Apartments Final Project. Contains full project final including appendix (53 pages). Scored A

Document Content and Description Below

IT-650-principles of database design Wild Wood Apartments Final Project (Southern New Hampshire University) Contents Milestone -1 Introduction 4 Unique stake holder’s role 5 Current problems 5... Other problems 5 Challenges 6 Business Requirements 6 System Limitations 7 Impact of the Organization on other departments 7 Milestone-2 8 Introduction 8 Business Requirements 9 Use case diagram 11 Conceptual Model 11 List of Attributes and Entities 11 Keys used for the Candidate 11 Logical Model 11 Physical Model 21 Milestone-3 22 Database Research 22 DBMS 22 Responsibilities of DBMS 22 Types of DBMS 23 Database Servers 23 Similarities and Differences of used servers:Oracle,MS SQL and Microsoft Access 24 Analysis 25 Recommendation 27 Hardware and Software Requirements 28 Milestone-4 30 Data Model 30 History 311 Enterprise Data Model 311 Operating Rules 35 Rule Reflection 37 Milestone-5 39 Introduction 39 Data Management Goals 39 Legal Compliance 40 Ethical Practices 40 Standards to Ensure ethical data operations 41 Security needs of the solution 43 Database Security Management Plan 44 Refrences…………………………………………………………………………………………46 Appendix...…………………………………………………………………………………………………………………………………………48 MILESTONE – 1 Introduction The Wild Wood Apartments is an organization which deals with the leasing of apartments for rentals. It is a very large company that comprises of large buildings that are widespread in Oregon, California, Idaho, and Washington. Twenty sets of different apartments are owned by this company. There are around sixty different apartments in every complex with varied dimensions. The rented apartments have the lease duration of about 6 months to 1 year. The purpose of this project is to build a centralized database system by using SQL that helps the supervisors of Wild Wood Apartments to carry out the business with efficiency and ease regularly. By improvising the central database of wild wood apartment’s complexes, it is easy to keep a track of the daily business of every apartment and to send the daily reports. Each and every element of data for leasing and various others information’s are also controlled by central database system. This centralized database acts as a web interface, which means a connection between the users and the system. In this scenario under users, we have managers, tenants and other staff. With the help of this new system, the tenants can view their leasing agreement duration. In addition, they have the access to the rental payments which have to be made. All the reports are prepared with updated information and it gets delivered to the quarterly reports. A new central database system would make the apartment manager’s job much easier to manage all the records and reporting’s of the daily business. (Hernandez, 2000). There are three different types of individuals present in the organization who are also recognized as stakeholders or actors. They include: • The tenants of the apartment • The managers of the apartments • Wild wood apartment company Unique stakeholders’ roles The Company would take over the legal rights of the apartments and managers are appointed to take care of the management. All the revenue related issues will be taken care of by the company. The issues that are associated with the tenants will be taken care of by the manager. He will carry out the procedure of leasing the apartment to the tenants. The manager will also take care and keep a record of payments made by the tenants for rents. Further, he will also take care of the issues related to the maintenance of the apartment. The leasing procedure starts with the occupancy of the apartment by the tenant and the monthly payment of rent to him. In this entire process the apartment manager doesn’t have any direct relationship with the tenants. As such, the roles of the manager will be similar to those of a middleman. The objectives will be communicated by the heads of the departments. (hero, 2014) Current problems of the present system Since the Wild Wood Apartments are wide spread in various places, location managers have the responsibility to send all the related complaints, documents, and the various issues to the head office. The whole procedure is considered as a time-consuming process and the companies’ growth would be effected by this process. The procedure followed for the leasing policy has to be changed by extending six months contract to the one year contract. (Hernandez, 2000) Other related problems • Manual work is a time-consuming; In this case, all the entries are entered manually and stored in the present existing system. • Storage is again done in excel sheets separately. • Changes made or occurred have to be updated manually. • There is no automatic search facility so it is taking time while searching a record. • Calculation has become complex. Main challenges As the manual work is ambiguous while collecting and sending the data, the data which is gathered may not be accurate. One more challenge is that it consumes a lot of time, when this manually collected data has to be made into reports and sent to the head of the department. So the 2 major challenges in the current system is delay in data availability on time and incorrect data. Requirements of the business There is requirement of storage of all the processes of wild wood apartments in the database. They would like to store other operations also in the database. They are: • All the records of new and old tenant’s must be stored in the database. • Database includes the storage of payment details. • One of the important criteria is to handling the operation maintenance. • Should maintain a head office at each location. • Maintenance of the central data base. • Transactions made for the rents have to be handled. • Should give the managers of the apartments an entering, editing, view, and delete options of leasing details • Provide view access of all the records to the managers from the headquarters • Requirement of database which is centralized. (Hernandez, 2000) Current system limitations • The present system doesn’t seem to be effective and the main backdrop is that it consumes a lot of time. • As the present system includes the manual work and majority of it is based on the paper, it cannot produce good data and also unavailability of data at fingertips takes place. • Generating reports related to expenses would be difficult and it is also time-consuming • The major concern is all about accuracy of the data and in reports verification. • Another major issue is the inconsistency in the current system as it does not have the facility for the data update. And the consumption of large volumes of paper for report making. Impact of the organization on other departments: References: Alina. D. R. B. (2007, june 2). Conflicts between privacy and property: The discourse in personal and organizational knowledge. Retrieved from http://dl.acm.org/citation.cfm?id=1282565.1282679 Belangia, D. W. (2015, march 13). Data Breach Preparation. Retrieved from http://www.giac.org/paper/gleg/635/data-breach-preparation/140927 Chong, F. C. G., & Wolter, R. (2006, June). Multi-Tenant data architecture, Microsoft Corporation. Retrieved from https://msdn.microsoft.com/en-us/library/aa479086.aspx Dicken, C. (2015). Databases for Web Developers. Retrieved from http://www.htmlgoodies.com/primers/database/top-5-databases-for-web-developers.html Graham, A. (2012). The enterprise data model: A framework for enterprise data architecture Hatami, M. (2008, April 16). Information management: the value of an enterprise data model (Part 2 0f 2). TDWI. Retrieved from http://tdwi.org/Articles/2008/04/16/Information-Management-The-Value-of-an-Enterprise-Data-Model-Part-2-of-2.aspx?Page=1 Hernandez, M. J. (2013, Febrarury). Database Design for mere immortals A Hands-on Guide to Relational. Retrieved from http://ptgmedia.pearsoncmg.com/images/9780321884497/samplepages/0321884493.pdf Howarth, F. (2014, March 11). 5 Key Steps to Ensuring Database Security. Retrieved from http://www.dbta.com/Editorial/Think-About-It/5-Key-Steps-to-Ensuring-Database-Security-95307.aspx J., L. (2013, November 13). Oracle vs. MySQL vs. SQL Server: A Comparison of Popular RDBMS. Udemy Blog. Learn anything. Anywhere. Retrieved from https://blog.udemy.com/oracle-vs-mysql-vs-sql-server/ Joseph M. Hellerstein and Michael Stonebraker. (2005). Readings in Database Systems. (4. edition, Ed.) Retrieved from http://redbook.cs.berkeley.edu/ Levinger, J. (2002, March). Data Security Challenges. Oracle9i Security Overview. doi:https://docs.oracle.com/cd/B10501_01/network.920/a96582/overview.htm Metioned, N. (n.d.). Brief Introduction to Database Systems. Retrieved from http://www.cs.ubc.ca/nest/dbsl/intro.html McConnell, J. H. (2011). Auditing your human resources department: A step-by-step guide to assessing the key areas of your program. New York: American Management Association Modeling, d. (2015, june 14). learndata model.com. Retrieved from http://www.learndatamodeling.com/edm.php Moss, L. (2008, april 1). Enterprise Data Modeling – Is It Worth It? Retrieved from http://www.eiminstitute.org/library/eimi-archives/volume-2-issue-1-april-2008-edition/enterprise-data-modeling-2013-is-it-worth-it Moufarrege, S. (n.d.). Advantages & Disadvantages of Microsoft SQL. Retrieved from http://www.ehow.com/list_7228389_advantages-disadvantages-microsoft-sql.html Rouse, M. (2010, May). Learn IT: The power of the database, 2. what is a relational databse? Databse glossary, Techtarget. Retrieved from http://whatis.techtarget.com/reference/Learn-IT-The-Power-of-the-Database Scottwambler. (2002-2006). Data Modeling. Retrieved from http://www.agiledata.org/essays/dataModeling101.html Silverston, L. (2013). The data model resource book: A library of universal data models for all enterprises. Hoboken, N.J: Wiley Stahl, G. K., Björkman, I., & Morris, S. (2012). Handbook of research in international human resource management. Cheltenham, UK: Edward Elgar Pub Stansfield, J. (2014, march 13). Microsoft SQL Server vs. Oracle: The Same, But Different? Retrieved from http://www.seguetech.com/blog/2014/03/13/Microsoft-SQL-Server-versus-oracle Systems, B. I. (n.d.). Brief Introduction to Database Systems. Retrieved from http://www.cs.ubc.ca/nest/dbsl/intro.html [Show More]

Last updated: 1 year ago

Preview 1 out of 53 pages

Reviews( 0 )

Recommended For You

 Information Technology> PROJECT FINAL > 4-2 Final Project Milestone Two: Database Analysis and Design Westlake Research Hospital IT-650 Principles of Database Design 27 May 2020 (All)

preview
4-2 Final Project Milestone Two: Database Analysis and Design Westlake Research Hospital IT-650 Principles of Database Design 27 May 2020

4-2 Final Project Milestone Two: Database Analysis and Design Westlake Research Hospital IT-650 Principles of Database Design 27 May 2020 DATABASE ANALYSIS AND DESIGN Conceptual Design The Con...

By QuizMaster , Uploaded: Nov 03, 2020

$12

 Information Technology> PROJECT FINAL > Southern New Hampshire University - IT 650Final Project Submission - 9-2 - Law Ethics and Security Plan and Database Management System. 9-2 Final Project Submission: Law, Ethics, and Security Plan and Database Management System Westlake Research Hospital IT-650 Principles of Database Design 1 July 2020. (All)

preview
Southern New Hampshire University - IT 650Final Project Submission - 9-2 - Law Ethics and Security Plan and Database Management System. 9-2 Final Project Submission: Law, Ethics, and Security Plan and Database Management System Westlake Research Hospital IT-650 Principles of Database Design 1 July 2020.

9-2 Final Project Submission: Law, Ethics, and Security Plan and Database Management System Westlake Research Hospital IT-650 Principles of Database Design 1 July 2020 INTRODUCTION Westlake Re...

By QuizMaster , Uploaded: Nov 03, 2020

$12

 Financial Accounting> PROJECT FINAL > ACC 201 5-1 Final Project Milestone Two - Accounting Workbook (All)

preview
ACC 201 5-1 Final Project Milestone Two - Accounting Workbook

Overview In Milestone One, you completed the first part of your course project to demonstrate your ability to accurately record financial data. In Milestone Two, you will use your journal entries fro...

By ACADEMICTUTORIAL , Uploaded: Nov 29, 2021

$3.5

 Information Technology> PROJECT FINAL > IDS 403 4-2 Final Project Milestone 2 Analyzing an Issue or Event in Technology (All)

preview
IDS 403 4-2 Final Project Milestone 2 Analyzing an Issue or Event in Technology

Analyzing an Issue or Event in Technology through the Lenses of History and the Humanities

By ACADEMICTUTORIAL , Uploaded: Jan 24, 2022

$3

 *NURSING> PROJECT FINAL > NURS 420 Final Project Outline (All)

preview
NURS 420 Final Project Outline

NURS 420 Final Project Outline

By ACADEMICTUTORIAL , Uploaded: May 18, 2022

$3

 Business> PROJECT FINAL > BUS 206 5-2 Project Two Submission (All)

preview
BUS 206 5-2 Project Two Submission

BUS 206 5-2 Project Two Submission

By ACADEMICTUTORIAL , Uploaded: May 18, 2022

$3

 Health Care> PROJECT FINAL > IHP 330 7-2 Final Project (All)

preview
IHP 330 7-2 Final Project

Principles of Epidemiology IHP 330 7-2 Final Project

By ACADEMICTUTORIAL , Uploaded: May 19, 2022

$3

 Health Care> PROJECT FINAL > HSC 1531 Module 06 Course Project Full Medical Record (All)

preview
HSC 1531 Module 06 Course Project Full Medical Record

HSC 1531 Module 06 Course Project Full Medical Record

By ACADEMICTUTORIAL , Uploaded: May 20, 2022

$3

 Language Development> PROJECT FINAL > DAD 220 6-1 Project One Creating a Database and Querying Data (All)

preview
DAD 220 6-1 Project One Creating a Database and Querying Data

Completed Project One database documentation template with source code for reference.

By ACADEMICTUTORIAL , Uploaded: Feb 10, 2023

$3

 Statistics> PROJECT FINAL > IHP 525 2-3 Final Project Data Analysis Milestone One Select Health Question (All)

preview
IHP 525 2-3 Final Project Data Analysis Milestone One Select Health Question

IHP 525 Milestone One Guidelines and Rubric Overview: Final Project Data Analysis is an opportunity for you to demonstrate your ability to run basic statistical calculations. You have been provided w...

By ACADEMICTUTORIAL , Uploaded: Feb 12, 2023

$5.5

$8.50

Add to cart

Instant download

Can't find what you want? Try our AI powered Search

OR

GET ASSIGNMENT HELP
247
1

Document information


Connected school, study & course



About the document


Uploaded On

Nov 03, 2020

Number of pages

53

Written in

Seller


seller-icon
QuizMaster

Member since 4 years

1074 Documents Sold


Additional information

This document has been written for:

Uploaded

Nov 03, 2020

Downloads

 1

Views

 247

Document Keyword Tags

THE BEST STUDY GUIDES

Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students

custom preview

Avoid examination resits

Your fellow students know the appropriate material to use to deliver high quality content. With this great service and assistance from fellow students, you can become well prepared and avoid having to resits exams.

custom preview

Get the best grades

Your fellow student knows the best materials to research on and use. This guarantee you the best grades in your examination. Your fellow students use high quality materials, textbooks and notes to ensure high quality

custom preview

Earn from your notes

Get paid by selling your notes and study materials to other students. Earn alot of cash and help other students in study by providing them with appropriate and high quality study materials.

WHAT STUDENTS SAY ABOUT US


What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·