0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
What are the advantages of teleworking?
Telework programs benefit employees, organizations, and the environment. A few key benefits are highlighted below:
Benefits to employees:
- Improved Work/Life Balance: Teleworking reduces commuting time and offers employees flexibility to manage work/life balance. Telework Exchange research finds that the average Federal employee spends 245 hours commuting each year, but can get 98 hours of their life back by teleworking two days per week. In addition, the study finds Americans spend more time commuting than on vacation. ("Federal Telework. No Free Ride," Telework Exchange study, November 2005)
- Cost Savings: Research shows that teleworking one day per week delivers approximately $2,000 in savings to each teleworker annually. ("What We Saved; What We Learned," Telework Exchange study, September 2009)
- Improved Productivity: Teleworkers maintain performance and productivity. 66 percent of managers who manage teleworkers find that teleworkers are as productive as their in-office counterparts. ("Face to Face with Management Reality -- A Telework Research Report," Telework Exchange, January 2007)
Benefits to organizations:
- Recruitment and Retention: Teleworking can improve personnel recruitment and retention. Research finds that compressed work weeks/telework options are key job perks. ("Generation Y in the Federal IT Workplace," Telework Exchange, November 2007)
- Business Continuity: Telework is a vital part of agency Continuity of Operations (COOP) plans. During both minor events, such as a snow storm, and major events, such as when an agency building is unusable, telework can be used to continue agency operations. The OPM Planning for Pandemic Influenza includes the following: "Telework allows the Federal Government to remain responsive to the nation's needs at all times and should be an integral part of any agency's plans for COOP." (Office of Personnel Management, "Planning for Pandemic Influenza")
- Real Estate Savings: Telework programs reduce office space requirements and costs. The United States Patent and Trademark Office (USPTO) reports that telework has enabled the agency to avoid $11 million in additional office space costs. (United States Patent and Trademark Office, "2008 Telework Annual Report")
Benefits to the environment:
- Less traffic on already congested roads
- Reduced wear and tear on all modes of transportation
- Reduced pollution: If all Federal employees who are eligible to telework full time were to do so, Feds could eliminate 21.5 billion pounds of pollutants out of the environment each year. ("Telework Eligibility Profile: Feds Fit the Bill," Telework Exchange, February 2008)
For more information, resources and tips on teleworking, visit Telework Exchange at www.teleworkexchange.com. You can use the Telework Savings Calculator to determine how much you could be saving by teleworking and the Online Telework Eligibility Gizmo to determine if you are eligible for a telework program.
mortgage rate in percent
REGISTRY
Find nice answer on wikipages:
http://en.wikipedia.org/wiki/Relational_database
The CPU cycle time is the time between start up and shutdown
Kdov,bokmok,dvokmvokd,of, ook,vlk
Sweet dreams are made of cheese.
What are the advantages of merit System in Bureaucratic System?
there the children are not allowed to have sex or violence on t.v
What is the difference between database application and dbms?
A DBMS is a database management system.
A database application would be something inside the DBMS such as:
~a way to search files
~a way to pull certain information
Was Sumeria Hierarchical or Egalitarian?
Sumeria was a hierarchical society with a clear social hierarchy. The kings and ruling elite held the highest positions of power, followed by the priests and military officials. Slavery was also prevalent, further reinforcing the hierarchical structure. However, it is important to note that there may have been some level of social mobility in Sumeria, as individuals could potentially rise through the ranks based on their abilities or achievements.
Difference between relation and relational schema?
In database design a RELATION is the relationship that you build between two or more tables.
As an example lets say you have a Customer table. In this table you have lots of fields
FirstName, LastName, Address, City, State, PostalCode, StatusID; etc.......
Now StatusID is going to be a numeric value. Lets say that the value is 1
Now you will have a Status Table with multiple fields (ex)
StatusID, StatusName, Active, etc.....
Now when you display customer information you will not want to show a StatusID as nobody will know what this is. You will want to show the NAME associated with the status. To do this you will create a releationship between StatusID in the Customer table and StatusID in the Status table. In doing so you will provide for faster lookup results, a constraint that does not permit a numeric value in the StatusID field in the customer table that is NOT in the StatusID field of the Status table.
THEN... To show correct Results you would write a query something like:
SELECT FirstName, LastName, Address, City, State, PostalCode, StatusName
FROM Customers as c
JOIN Status as s on s.StatusID = c.StatusID
A relational Schema is simply a representation of your database highlighting the relationships that you have created throughout.
What is the importance of file organization?
To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. For instance, if there were to be an application that need only sequential batch processing, then the use of indexing methods would be pointless and wasteful.
There are various important consequences of an inappropriate file Organisation being used in a database. Therefore using replication would be wasteful of space besides posing the trouble of inconsistency in the data. The wrong file Organisation can also-
- Mean much larger processing time for modifying the required record or retrieving.
- Want undue disk access that could stress the hardware
Needless to say, these could have a lot of undesirable consequences at the user level, such as making some applications impractical.
Query for drop the all tables in hsql database?
use
DROP SCHEMA PUBLIC CASCADE
you may want to replace "public" with your custom schema but that one worked for me. Don't forget to refresh your tree in the database manager!
There are two kinds of databases. RDBMS and DBMS. Anything which stores data in rows and columns can be called as a database. Even a text file can be a database if it contains data in this format. XML files also can be treated as database. We can query a database using SQL (Structured Query Language) to extract information from a database. This data can be manipulated in different ways to generate reports or use in your software.
Data mining is effectively storing and analysing old pieces of data and predicting what's going to happened in future based on trends and patterns in that data.
What is one to one database relationships?
This is where you have two tables and each record on one table has one and only one corresponding record on the other. To connect them, they both have a corresponding code, that is unique in each table. So you could have a database for employees. In a table in it you could have all their personal details. On another you could have their salary details. On both tables, for each individual there would be a unique code, like an employee code. When a particular employee is found on the employee table, their code is taken and checked for on the salary table to find the details for their salary. It is then not necessary to have their name in both tables, as the code can be used to link the two parts of their data together from the two tables. The code is the only thing that will be in both tables. As every code on one table has one corresponding code on the other it is a one to one relationship. There are other types of database relationships, namely one to many and many to many.
It's between Hotmail, Yahoo, or Gmail. Some other one might include Microsoft outlook or AOL. It is really your opinion!
PATA (Parallel ATA), IDE or EIDE, is a interface used by storage and removable disk drives. Nowadays they are replaced by SATA (Serial ATA) and PCI Express.
Disadvantages of logical data modelling?
1. Database may need completely redoing if a single field in one relational table has to be changed.
2. If an ERD is resolved incorrectly then it would have to be redone.
When is the concept of weak entity used in data modelling?
A weak entity can be identified uniquely only by considering the primary key of another (owner) entity.
How do you draw an entity relationship diagram for an airline ticket reservation centre?
http://cs.senecac.on.ca/~dbs201/pages/ERD.htm
