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 a file management system?
Some of the advantages are: 1. A file management system will allow user to create and store Meta data. Meta data is data about the files. 2. A file is indexed for faster and easier retrieval. Gives structure to all your info. You will be able to manage all your information much easier.
o Interest Rate Risk: One way to measure interest rate risk is to measure the volatility of interest rates. The easiest way to do this (though not necessarily the most correct) is to look at the historic volatility of interest rates. A more complex way to do this is to use mathemtical models to forecast interest rate scenarios.
o Credit Risk: Credit risk is evaluated by credit ratings agencies, the most common being Moody's, Fitch, and Standard and Poors. These agencies assign credit rates to corporations and bonds, helping the investor and lenders understand the implicit risk of the borrower/issuer.
o Liquidity Risk: Typically the bid-offer spread (the difference between where you buy and sell a product) is a good indication of liquidity risk. For example, if you can buy a stock at $100 and sell it at $99.95, the bid-offer spread is $0.05, and getting out of the trade is considered relatively easy. However, if you could buy a bond at $100 but sell it at $80, the bid-offer spread is $20, and the bond would be considered illiquid.
o Event/Geopolitical Risk: This is a tough one to measure. Increasing global tension is generally reflected in price volatility or a runup in certain types of prices (gold, oil, US Govt bonds), but no one can predict when/where major risk-impacting events will happen.
It is a query that returns the data in a tabular form, similar to a pivot table in a spreadsheet. There are headings across the top and down the side. A typical example would be counting how many staff in each department are male and female. You could have the headings of the departments down the side and the headings for male and female across the top. Then there would be a total for each gender in each department.
The nature of tourism is closely connected with travelling. it has been a human phenomenon since the beginning of human civilization.it is a sensitive factor of the human nature in the context of moving to survive, explore, and to know the unknown. in the early times, they started travelling as nomades in search of prey and food. later, the development of the agriculture system created a base of the movement of people as a traveller. then the output of industrial revolution made travelling prominent to various destinations. it made the traveller's lifestyle easier and safer to realize their tourism activities.
Thus, the modern tourism is absolutely changed due to complete development of overall sectors of tourism components and consciousness of the people. the nature of tourism is described in the following headings:-
*tourism and service
Tourism is a service industry,which is ocmposed of those sectors of the economy that are involved in provoding service,such as accomodation,food,beverage,transportation and recreations as well as distribution and sales services.Tourism industry has been taken as the term that denotes work,productivity,employment income,economic growth,social development,etc
Two principal integrity rules for the relational model?
Integrity Rules Although integrity rules are not part of normal forms, they are definitely part of the database design process. Integrity rules are broken into two categories. They include overall integrity rules and database-specific integrity rules. == The two types of overall integrity rules are referential integrity rules and entity integrity rules. Referential integrity rules dictate that a database does not contain orphan foreign key values. This means thatEntity integrity dictates that the primary key value cannot be Null. This rule applies not only to single-column primary keys, but also to multi-column primary keys. In fact, in a multi-column primary key, no field in the primary key can be Null. This makes sense because, if any part of the primary key can be Null, the primary key can no longer act as a unique identifier for the row. Fortunately, the Access Database Engine (Access 2007's new version of the JET database engine, available with the new ACCDB file format) does not allow a field in a primary key to be Null.
Database-Specific Rules The other set of rules applied to a database are not applicable to all databases but are, instead, dictated by business rules that apply to a specific application. Database-specific rules are as important as overall integrity rules. They ensure that only valid data is entered into a database. An example of a database-specific integrity rule is that the delivery date for an order must fall after the order date.
Link is a male. But being a Hylian, he has elf-like ears and somewhat feminine features.
What are the examples of network database model?
world wide web (WWW) is such example as different pages are related to each other .
How many megabites is one gigabite?
In computers, giga is 1024 (2^10) times bigger than mega. In normal metric usage, giga is 1000 (10^3) times bigger than mega. This is due to the fact that computers use binary internally
A database is a list of records, each record contains the same information in the same format as every other record. Using a database enables the user to find one or more records quickly and efficently, and to perform some calculations on the information stored.
Whichever UTECH person this is, Stop Being lazy and go research the questions.
A fixed length record is a data structure that contains a standard amount fields, within the actual record.
- Minimal Data Redundancy
- Consistency of Data
- Integration of Data
- Sharing of Data
- Data independence
- Ease of Application Development
Log shipping is one of the failover solutions offered by SQL Server 2000. In this context, failovermeans substituting primary server with a backup (sometimes also referred to as standby) server if the primary hardware becomes unusable. Failover solutions can also be used to provide close to 100% uptime-during primary database or server maintenance and during software upgrades you could use the standby server to continue serving your customers. Failover solutions can be automatic or manual. With automatic failover, the backup server detects when the primary server is not available and takes over without any intervention from the database administrator. An example of an automatic failover solution is clustering. With manual failover, the database administrator (DBA) has to perform some steps to bring the standby server online. In SQL Server 2000, log shipping is a form of manual failover.
General tree to binary tree conversion?
The process of converting the general tree to a binary tree is as follows:
* use the root of the general tree as the root of the binary tree
* determine the first child of the root. This is the leftmost node in the
general tree at the next level
* insert this node. The child reference of the parent node refers to this
node
* continue finding the first child of each parent node and insert it below
the parent node with the child reference of the parent to this node.
* when no more first children exist in the path just used, move back to the
parent of the last node entered and repeat the above process. In other
words, determine the first sibling of the last node entered.
* complete the tree for all nodes. In order to locate where the node fits
you must search for the first child at that level and then follow the
sibling references to a nil where the next sibling can be inserted. The
children of any sibling node can be inserted by locating the parent and then
inserting the first child. Then the above process is repeated.
Unary relationship in database?
Manual vs computerized systems?
Salient Features of Computerized accounting
2.1. Fast, Powerful, Simple and Integrated
Computerized accounting is designed to automate and integrate all the business operations, such as sales, finance, purchase, inventory and manufacturing. With Computerized accounting, accurate, up-to-date business information is literally at the fingertips. The Computerized accounting combine with enhanced MIS, Multi-lingual and Data organization capabilities to help the company simplify all the business processes easily and cost-effectively.
2.2. Complete Visibility
Computerized accountings giving the company sufficient time to plan, increase the customer base, and enhance customer satisfaction. With Computerized accounting the company will have greater visibility into the day-to-day business operations and access to vital information.
2.3. Enhanced User Experience
Computerized accounting allows the company to enter data in a variety of ways which makes work a pleasure. Adapting to the specific business needs is possible.
2.4. Accuracy, Speed
Computerized accounting has User-definable templates which provides fast, accurate data entry of the transactions; thereafter all documents and reports can be generated automatically, at the press of a button.
2.5. Scalability
Computerized accounting adapts to the current and future needs of the business, irrespective of its size or style.
2.6. Power
Computerized accounting has the ability to handle huge volumes of transactions without compromising on speed or efficiency.
2.7. For Improved Business Performance
Computerized accounting is a highly integrated application that transforms the business processes with its performance enhancing features which encompass accounting, inventory, reporting and statutory processes. This helps the company access information faster, and takes quicker decisions. Computerized accounting also guarantees real-time optimization of operations and enhanced communication.
2.7. Quick Decision Making
Generates real-time, comprehensive MIS reports and ensures access to complete and critical information, instantly.
2.8. Complete Reliability
Computerized accounting makes sure
the opposit of the above will do for the manual system
