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 do you need to think about when changing the presentation's audience?
You need to think about:
# the layout # the pictures # consistency # design # pictures # animation
What is function of floppy disk?
The floppy disk stores data. Before the days of large hard drives, flash disks, cds, and dvds this was the primary media for transporting data.
For example if you wanted to install the old Windows 3.1x it came on a bundle of floppy disks. If you wanted to take a project from work or school back home, you used a floppy disk.
What sql platform does quickbooks enterprise use?
To improve performance in multi-user mode, Enterprise Solutions has upgraded to the Sybase 10 SQL database. Get fewer "company file in use" messages, run queries faster, and save transactions while reports are running. http://enterprisesuite.intuit.com/products/enterprise-solutions/?qbes_features=performance&qbes_info=features#multi_user
Database programming language?
Depends upon the database you are talking about MS SQL Server uses SQL and T-SQL programming languages. Oracle is also a SQl based language usings its own 'flavor' PSQL
true
In Greek mythology, Hades was the god of the Underworld. Hades had control over the dead and protected his control fiercely, but was otherwise mostly passive.
What is Armstrong inference rules?
Armstrong's Inference Rules
- Specify rules for reasoning about dependency functions:
- Reflexive rule:
{Y 1,...,Y n}⊆{X1,...,Xm}
implies {X1,...,Xm}→{Y 1,...,Y n} {Name,Sex}→{Name} - Augmentation Rule:
{X1,...,Xm}→{Y 1,...,Y n}
implies {X1,...,Xm,Z}→{Y 1,...,Y n,Z} {Name,Sex}→{Name}
implies {Name,Sex,Age}→{Name,Age} - Transitive rule:
{X1,...,Xm}→{Y 1,...,Y n},
{Y 1,...,Y n}→{Z1,...,Zs}
imply {X1,...,Xm}→{Z1,...,Zs} {Number}→{Name}
{Name}→{Sex}
imply{Number}→{Sex}
- Reflexive rule:
- Armstrong inference rules are sound Produce only functional dependencies belonging to the closure complete Produce all the functional dependencies in the closure
Want to look at the RID allocation table for a DC What do you do?
1.install support tools from OS disk(OS Inst: Disk=>support=>tools=>suptools.msi) 2.In Command prompt type dcdiag /test:ridmanager /s:system1 /v (system1 is the name of our DC)
What are the pitfalls in developing a management information system?
Pitfalls in MIS Development
• Organization does not have a reliable management system
• Organization has not defined its mission clearly
• Organization's objectives have not been specified
• Management lacks interest in MIS development process &
relies solely on MIS development's specification.
• Communication gap exists between MIS development team and the management
• MIS development team is incompetent
Example for relational data model?
here is a good website for that.
http://www.databaseanswers.org/data_models/index.htm
Depending on how much in depth multimedia your getting into, windows works fine for most basic to intermediate video, and graphics editing. If your getting into extremely large video projects, MacIntosh is better suited for those types of work loads.
Describe the approach taken to handlin of data in the early file based system?
Focus was on applications for which programs would be written, and all the data required would be stored in a file or files owned by the programs.
Clearly, each program was responsible for only its own data, which could be repeated in other program's data files. Different programs could be written in different languages, and would not be able to access another program's files. This would be true even for those programs written in the same language, because a program needs to know the file structure before it can access it.
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.
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
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.
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.
