Premium Essay

Pt2520 Database Concepts

In: Computers and Technology

Submitted By ranniel
Words 706
Pages 3
List the major topics for this database.
The major topics of 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 of the property would only have access to their particular site’s data. The contractor is not responsible for internet connectivity beyond the boundaries of the company’s properties.
• Objectives: The objective is to simplify and improve the accuracy of the data collection as well as making the data available through a…...

Similar Documents

Free Essay

Pt2520 Unit 7 Research Assignment

...PT2520 Database Concept Unit 7 Research Assignment 1. What are the advantages of a declarative language as opposed to a procedural language? ANSWER: The advantage of declarative programming languages is mainly two-fold. The programs are concise; this makes it easy even for non-programmers to obtain solutions. In the SQL example above, an analyst or business support person can get the desired information. Similarly, laypersons can write acceptable web pages with simple HTML and CSS commands. The second advantage of the declarative programming model is that repetitive imperative code that indicates how to solve things is provided in the computer system behind the scenes. Such code can be made highly efficient and can incorporate the best ideas from computing. It can take advantage of parallelism 2. What advantages might a procedural language have over a declarative language? ANSWER: Procedural programming is used for developing simple applications. The languages that use the procedural programming methodology include Pascal and C languages. Some of the benefits of the procedural programming methodology are: (1) Easy to read program code. (2) Easy maintainable program code as various procedures can be debugged in isolation. (3) Code is more flexible as you can change a specific procedure that gets implemented across the program. 3. Why do you think cross joins are allowed as a legitimate join? What uses can you see for joins? ANSWER: I think that a cross-join......

Words: 324 - Pages: 2

Premium Essay

Unit 6 Research Assignment 1

...PT2520 Database Concepts Unit 6 Research Assignment 1: Explore the latest ANSI and ISO Standard True/False 23-Jul-2016 Tim Church Daigre ANSI- The American National Standards Institute (ANSI) oversees the creation, promulgation and use of thousands of norms and guidelines that directly impact businesses in nearly every sector: from acoustical devices to construction equipment, from dairy and livestock production to energy distribution, and many more. ANSI is also actively engaged in accreditation - assessing the competence of organizations determining conformance to standards. To enhance both the global competitiveness of U.S. business and the U.S. quality of life by promoting and facilitating voluntary consensus standards and conformity assessment systems, and safeguarding their integrity. ISO- International Organization for Standardization (ISO) is an independent, non-governmental international organization with a membership of 163 national standards bodies. Through its members, it brings together experts to share knowledge and develop voluntary, consensus-based, market relevant International Standards that support innovation and provide solutions to global challenges. Part II- The latest SQL standard was adopted in July 2003 and is often called SQL:2003. One part of the SQL standard, Part 14, SQL/XML (ISO/IEC 9075-14) was revised in 2006 and is often referenced as "SQL/XML:2006". ANSI/ISO/IEC 9075:2003, "Database Language SQL", Parts 1......

Words: 278 - Pages: 2

Free Essay

Week 4 Essay: Comparing Dbms

...PT2520: Database Concepts Week 4 Essay: Comparing DBMS Comparing DBMS What is database management system (DBMS)? Database management system is reliable mean to organize date into a single location that can be searched and updated at any time. By adding all the information in one location or in this case a server you are storing the information for later use. You can than search any information you require and update it or even remove old items from the database. Today there are several different options or providers for a DBMS server. Among the top providers you have Oracle, MySQL, IBM DB, MS SQL Server. Oracle 12C Oracle 12C is a cloud base database management system. It supports the following operating systems (OS) Microsoft Windows, Linux, Oracle Solaris and some Unix. It is a web-based interface that stores all the procedures on the Oracle Management Repository. The most recent update was released on September 30, 2014. Some of the benefits of Oracle 12c are the following. Per oracle documentation “It provided a secure multitenant application by adding a layer of abstraction or containerization. It allows you to use the cloud providers for an easy and quick mean to allocate and manage the database across multiple systems and data centers without changing the application”. It also provides a disaster recovery, backup, patching, cloning and upgrading flexibility. Oracle is able to replace or move any information while you use either of the following RMAN, Data......

Words: 917 - Pages: 4

Premium Essay

Statement of Work

...PT2520: Database Concepts ITT technical Institute Statement 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......

Words: 537 - Pages: 3

Premium Essay

Nt1230 Syllabus

...network server functions. Client-Server Networking I Syllabus Where Does This Course Belong? 1st QTR GS1140 NT1110 GS1145 Problem Solving Theory Computer Structure and Logic Strategies for the Technical Professional 2nd QTR NT1210 Introduction to Networking NT1230 Client-Server Networking I MA1210 College Mathematics I 3rd QTR NT1310 NT1330 MA1310 4th QTR PT1420 NT1430 EN1320 5th QTR PT2520 NT2580 EN1420 6th QTR NT2640 NT2670 CO2520 7th QTR NT2799 SP2750 Physical Networking Client-Server Networking II College Mathematics II Introduction to Programming Linux Networking Composition I Database Concepts Introduction to Information Security Composition II IP Networking Email and Web Services Communications Network Systems Administration Capstone Project Group Theory The follow diagram indicates how this course relates to other courses in the NSA program: 1 Date: 8/31/2012 Client-Server Networking I Syllabus NT2799 NSA Capstone Project NT2580 Introduction to Information Security NT2670 Email and Web Services NT2640 IP Networking PT2520 Database Concepts NT1330 Client-Server Networking II NT1230 Client-Server Networking I NT1430 Linux Networking PT1420 Introduction to Programming NT1110 Computer Structure and Logic NT1210 Introduction to Networking NT1310 Physical Networking CO2520 Communications SP2750 Group Theories EN1420 Composition II EN1320 Composition I GS1140 Problem Solving Theory GS1145......

Words: 1834 - Pages: 8

Premium Essay

Data Base Concepts

...Jonathan Hindman PT2520 Chapter 4 10/18/13 Cardinality: Cardinality refers to the number of allowed instances of a relationship. In the usual cardinality of one to many, for instance, each record on the one side can have zero to any number of records on the many side. Cardinality can be more specific however. Each patron at a library can have only 20 items checked out at once. This has a cardinality of 0 to 20. Composite keys: In database design, a compound key is a key that consists of 2 or more attributes that uniquely identify an entity occurrence. Each attribute that makes up the compound key is a simple key in its own right. Crow’s feet notation: A type of notation for entity relationships in entity relation diagrams that depicts the many side of a relationship with a three-pronged end called a “crows foot.” This type of notation provides more information about the cardinality of a relationship than the arrow notation for relationships. Domain entities: Those database entities that relate directly to the business problem under consideration. Entity relation diagrams: A diagram that shows entities, their attributes, and the relationships among them. Linking entity: An entity used to resolve a many-to-many relationship into two one-to-many relationships. Logical entity: The design of a database without regard to the physical implementation of the database. Lookup entity: An entity used to store lookup values such as state names or zip codes. Maximum......

Words: 1477 - Pages: 6

Free Essay

Comparing Dbms

...PT2520: Database Concepts Week 4 Essay: Comparing DBMS ITT Technical Institute – Westminster Walter Gonzales 7/12/15 Comparing DBMS What is database management system (DBMS)? Database management system is reliable mean to organize date into a single location that can be searched and updated at any time. By adding all the information in one location or in this case a server you are storing the information for later use. You can than search any information you require and update it or even remove old items from the database. Today there are several different options or providers for a DBMS server. Among the top providers you have Oracle, MySQL, IBM DB, MS SQL Server. Oracle 12C Oracle 12C is a cloud base database management system. It supports the following operating systems (OS) Microsoft Windows, Linux, Oracle Solaris and some Unix. It is a web-based interface that stores all the procedures on the Oracle Management Repository. The most recent update was released on September 30, 2014. Some of the benefits of Oracle 12c are the following. Per oracle documentation “It provided a secure multitenant application by adding a layer of abstraction or containerization. It allows you to use the cloud providers for an easy and quick mean to allocate and manage the database across multiple systems and data centers without changing the application”. It also provides a disaster recovery, backup, patching, cloning and upgrading flexibility. Oracle is able to replace or move any......

Words: 926 - Pages: 4

Premium Essay

Test

...Auditing for Compliance Countermeasures Information Security Email and Web Services      NT1230 NT1330 Client-Server Client-Server  Networking I Networking II  IS3230 IS3350 NT1230 NT1330  Issues Client-Server Client-Server  SecurityContext in Legal Access Security Networking I Networking II   NT1110  NT1210 Structure and Introduction to  ComputerLogic Networking    IS3120 IS3110 NT1210 Network  Risk Management in Introduction to General Education / General Studies NT2580 NT2799 Communications Information Technology Introduction to Information Security NSANetworking Capstone Project IS4550 NT2640 Security Policies and Implementation IP NT2640 Networking IP Networking PT2520 IS3445 PT2520 Database Concepts Security for Web Applications and Social Database Concepts Networking IS3340 NT1430 Windows Security Linux Networking NT1430 Linux Networking PT1420 Introduction to Programming IS3440 PT1420 Introduction to Linux Security Programming IS3220 NT1310 IT Infrastructure Security Physical Networking PM3110 Introduction to Project Management NT1310 NT1430 Physical Networking Linux Networking NT2640 IP Networking Infrastructure CO2520 Communications EC2555 Survey of Economics MA3110 Statistics SS3150 Research Methods EN3220 Written Analysis CO2520 Communications SP3450 Social Psychology EC2555 Survey of Economics GS1140 Problem Solving Theory HU4640 Ethics SC4730 Environmental Science EN1420 Composition......

Words: 2305 - Pages: 10

Premium Essay

Nt2640

...This course explores network design and implementation by applying the TCP/IP protocols to provide connectivity and associated services. Planning and deployment of network addressing structures, as well as router and switch configurations, are also examined. IP Networking Syllabus Where Does This Course Belong? This course is required in the associate degree program in Network Systems Administration and associate degree in Mobile Communications Technology. The following diagrams indicate how this course relates to other courses in respective programs: Network Systems Administration NT2799 NSA Capstone Project NT2580 Introduction to Information Security NT2670 Email and Web Services NT2640 IP Networking PT2520 Database Concepts NT1330 Client-Server Networking II NT1230 Client-Server Networking I NT1430 Linux Networking PT1420 Introduction to Programming NT1110 Computer Structure and Logic NT1201 Introduction to Networking NT1310 Physical Networking CO2520 Communications SP2750 Group Theories EN1420 Composition II EN1320 Composition I GS1140 Problem Solving Theory GS1145 Strategies for the Technical Professional MA1210 College Mathematics I MA1310 College Mathematics II Networking Technology Courses Programming Technology Courses General Education/ General Studies 1 Date: 7/18/2011 IP Networking Syllabus Mobile Communications Technology MC2799 MCT Capstone Project NT2640 IP......

Words: 2573 - Pages: 11

Premium Essay

Nt 1210

...Contact/Instructional hours: 56 (34 Theory Hours, 22 Lab Hours) Prerequisite(s) and/or Corequisite(s): Prerequisites: NT1110 Computer Structure and Logic or equivalent Course Description: This course serves as a foundation for the study of computer networking technologies. Concepts in data communications, such as signaling, coding and decoding, multiplexing, circuit switching and packet switching, OSI and TCP/IP models, LAN/WAN protocols, network devices and their functions, topologies and capabilities are discussed. Industry standards and the development of networking technologies are surveyed in conjunction with a basic awareness of software and hardware components used in typical networking and internetworking environments Introduction to Networking Syllabus Where Does This Course Belong? This course is required for the associate program in Network System Administration and the associate program in Electrical Engineering Technology. The following diagrams demonstrate how this course fits in each program. Associate Program in Network Systems Administration NT2799 NSA Capstone Project NT2580 Introduction to Information Security NT2670 Email and Web Services NT2640 IP Networking PT2520 Database Concepts NT1330 Client-Server Networking II NT1230 Client-Server Networking I NT1430 Linux Networking PT1420 Introduction to Programming NT1110 Computer Structure and Logic NT1210 Introduction to Networking NT1310 Physical......

Words: 4400 - Pages: 18

Premium Essay

Nt1210 Introduction to Networking Onsite Course

...Contact/Instructional hours: 56 (34 Theory Hours, 22 Lab Hours) Prerequisite(s) and/or Corequisite(s): Prerequisites: NT1110 Computer Structure and Logic or equivalent Course Description: This course serves as a foundation for the study of computer networking technologies. Concepts in data communications, such as signaling, coding and decoding, multiplexing, circuit switching and packet switching, OSI and TCP/IP models, LAN/WAN protocols, network devices and their functions, topologies and capabilities are discussed. Industry standards and the development of networking technologies are surveyed in conjunction with a basic awareness of software and hardware components used in typical networking and internetworking environments Introduction to Networking Syllabus Where Does This Course Belong? This course is required for the associate program in Network System Administration and the associate program in Electrical Engineering Technology. The following diagrams demonstrate how this course fits in each program. Associate Program in Network Systems Administration NT2799 NSA Capstone Project NT2580 Introduction to Information Security NT2670 Email and Web Services NT2640 IP Networking PT2520 Database Concepts NT1330 Client-Server Networking II NT1230 Client-Server Networking I NT1430 Linux Networking PT1420 Introduction to Programming NT1110 Computer Structure and Logic NT1210 Introduction to Networking NT1310 Physical......

Words: 4400 - Pages: 18

Premium Essay

Nothing

...equivalent Course Description: This course examines industry standards and practices involving the physical components of networking technologies (such as wiring standards and practices, various media and interconnection components), networking devices and their specifications and functions. Students will practice designing physical network solutions based on appropriate capacity planning and implementing various installation, testing and troubleshooting techniques for a computer network. Where Does This Course Belong? | | | NT2799 | | | | | | | | NSA Capstone | | | | | | | Project | | | | | NT2580 | | | NT2670 | NT2640 | | PT2520 | | Introduction to | | | | | | | | | | | Email and Web | | | | | Information | | | | IP Networking | | Database Concepts | | | | | Services | | | | | Security | | | | | | | | | | | | | | | | NT1330 | | | NT1230 | NT1430 | | PT1420 | | Client-Server | | | Client-Server | | | Introduction to | | | | | | Linux Networking | | | | Networking II | | | Networking I | | | Programming | | | | | | | | | | NT1110 | | | NT1210 | NT1310 | | | | Computer Structure | | Introduction to | Physical | | | | and Logic | | | Networking | Networking | | | | | | | CO2520 | SP2750 | | | | | | | Communications | Group Theories | | | | EN1420 | | EN1320 | GS1140 | GS1145 | MA1210 | MA1310 | | | |......

Words: 10839 - Pages: 44