answersLogoWhite

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 piece of hardware do EIDE cables connect to?

Typically EIDE cables connect to IDE Hard-drives and optical drives such as CD and DVD Drives.

The cable connects between the motherboard of the computer and the hard-drive or optical drive.

Normally most motherboards have two idea buses. You can have to drives per cable. So a total of 4 drives.

What can you do with this phpmyadmin info?

phpMyAdmin is an application written in the PHP language that provides a web-based interface for the administration of MySQL databases.

Does Apple offer a database?

Filemaker, a well known database program, is now owned by Apple.

Filemaker, a well known database program, is now owned by Apple.

Filemaker, a well known database program, is now owned by Apple.

Filemaker, a well known database program, is now owned by Apple.

Filemaker, a well known database program, is now owned by Apple.

Filemaker, a well known database program, is now owned by Apple.

Filemaker, a well known database program, is now owned by Apple.

Filemaker, a well known database program, is now owned by Apple.

Filemaker, a well known database program, is now owned by Apple.

Filemaker, a well known database program, is now owned by Apple.

Filemaker, a well known database program, is now owned by Apple.

Explain the first 3 normal forms in dbms?

First Normal Form: Remove the repeating groups in a table

Second Normal Form: Remove partial dependencies

Third Normal Form: Remove transitive depedencies

What is the difference between a repository and a database?

The Metasafe Repository is a (DMBS) Database Management System. There are many types of DMBS with different core models: Oracles, SQLServer, MySQL are based on the "relational model" which is constructed from tables. IMS the database from IBM is based on a hierachical model. Etc.

Metasafe is based on an entity-relationship model, which means that is handles "entities" and "relationships between entities". This is the difference.

What do they have in common? A (proper) database can be used by many users in parallel. It guarantees that a set of changes (a transaction) is processed completely or not all to make sure that the database is allways in a consistent state. A DMBS has also an access language (in case of Metasafe erSQL) and an API to access the data in the database.

Last update on 04.11.2011 by Patrick Landolt.

How can you connect to sql server through sas?

By using the remote connection, or OPEN DATABASE CONNECTION are useful to connect the sas with sql server, to give the connection mention the server name and it path of the datasource name with DSN. and end of the statement close the connection.

Why is anomalies required in database?

Anomalies are not required in a database. An anomaly is a inconsistency or a problem. A well designed database should not have any anomalies. If there are some, they can cause problems for the users and for the reliability and efficiency of the database.

What is the advantage of openoffice to others?

OpenOffice has several advantages to other office suites.

1. Unlike Microsoft Office or iWork, OpenOffice is available free of charge.

2. Unlike Microsoft Office or iWork, OpenOffice is open-source, and free to modify.

3. Unlike GNOME Office, KOffice, or Siag Office, OpenOffice is written in Java. This means that it does not need to be ported to other operating systems; it should run out-of-the-box on any system with a Java runtime.

What is the difference between oracle 10g and 11g?

In SOA10g suite Oracle fell somewhere in the middle of these two, they attempted to get the best of breed products together and also tried to make integration between each product smooth and flowing. Keeping in mind this was one of the first iterations of the SOA suite I think they did a great job. However I was always left with a feeling that I felt that there was no clear cut line between what each product does, as well as integration between each product could have been more seamless.

Then came SOA11g Fusion this product is hands down one of the most comprehensive SOA suite products on the market. Oracle's Acquisition of BEA was one of the best they could have made. The product is well integrated as well as each product within the stack has its very own purpose. Not only do the products integrate well, but they perform exceptionally well.

What is the difference between Oracle 8.0 and Oracle 8i?

Database versions are incremented based on the number of changes in the new release. For instance. Oracle 5 to Oracle 6. There is a significant amount of differrences/updates between those two versions. However, Oracle 8.0 to 8i--there are only minor updates because they are both within "8". If I remember correctly, the main difference between these two was that 8i incorporated "internet" options. (hence where the I came from) i=internet.

Which management information system KFC use?

The KFC uses the management information system. The KFC uses the management information system in accounting because they understand that it is very important in production.

What is definition by operation support system?

When monitoring and controlling its activities a business can make immediate use of the information from its operational support system to make its minute-by-minute or hour-by-hour decisions. For a restaurant, for example, some of their products are freshly prepared, while others are cooked in batches or need time to defrost. If customer orders are recorded on an EPOS system, then an operational support system can alert the restaurant management as to when they need to cook or defrost more bulk products.

What is the Definition of application control?

By definition, application control refers to the transactions and data relating to computer-based application systems. These controls are specific to each application.

Comparison of FCFS SJF round robin algos?

FCFS = First Come First Serve SJF = Shortest Job First Round Robin = Skip from one job to the next giving each job an equal amount of processing time. (up to you or given)

In an example: You have 4 jobs ahead of you. JobC, JobA, JobB, JobD and they were handed in to you, in that order. JobA will take 2 hours to do, JobB will take 1 hour, JobC will take 5 hours, and JobD will take 9 hours. FCFS, basically would mean you finish JobC first, since it came to you first. Then when JobC was done, you would work on JobA and so on. SJF, you would finish JobB first, then JobA, then JobC and then JobD. Round Robin, you would work on JobC for 1 hour, then JobA for 1 hour, then JobB for 1 hour and then JobD for 1 hour, and repeat.

Describe ansi sparc 3 level architecture of dbms and details of languages associated at differentlevels plusthe level of data independence?

The ANSI-SPARC Architecture (American National Standards Institute, Standards Planning And Requirements Committee) is an abstract design standard for a DBMS, first proposed in 1975. Most modern commercial DBMS are based on this system. The ANSI-SPARC model never became a formal standard. The objective of the three-level architecture is to separate the users' view(s) of the database from the way that it is physically represented. This is desirable since: * It allows independent customised user views. ** Each user should be able to access the same data, but have a different customised view of the data. These should be independent: changes to one view should not affect others. * It hides the physical storage details from users.

** Users should not have to deal with physical database storage details. They should be allowed to work with the data itself, without concern for how it is physically stored. * The database administrator should be able to change the database storage structures without affecting the users' views. ** From time to time rationalisations or otherchanges to the structure of an organisation's data will be required. * The internal structure of the database should be unaffected by changes to the physical aspects of the storage. ** For example, a changeover to a new disk. * The database administrator should be able to change the conceptual or global structure of the database without affecting the users.

** This should be possible while still maintaining the desired individual users' views. with kind regards M I K

Why do computers use base 2?

Computers use base 2 because a transistor only has two states, on and off and these are best represented by a 0 and a 1. Transistors are the building blocks of a computer's ICs.

Does a systems analyst's responsibilities include data people process interfaces and networks?

1. Assists current or potential application users in identifying and describing problems or opportunities that might be addressed either: a) by implementing a new (automated or manual) system, or b) by changing an existing application system. 2. Investigates such problems and opportunities to determine the feasibility of a system solution and to identify the general kinds of system solution that appear appropriate. 3. Analyzes users' business requirements in detail and, where appropriate, prepares functional specifications1 for a proposed new (or changed) system. 4. Assists and guides prospective users of a proposed new or changed system in: a) quantifying the benefits of having the system (or the penalties for not having it), and b) assessing the impact of the system on their organization and on the operation of their business. 5. Obtains rough estimates of the cost of operating and maintaining a proposed new or changed system, assuming use of appropriate technology, tools, and methods. 6. Assists the project manager3 in identifying the skills and resources needed to implement a new system or to modify an existing system, and in preparing rough estimates of: a) the cost of developing or changing the system, b) the duration of a project to do so. c) prepare the DFDs for the system.

7. Assists the sponsoring users in: a) analyzing the costs, benefits, risks, and return-on-investment of the proposed new system, b) understanding the exact nature of the proposed system, c) deciding whether to proceed with the implementation. 8. Designs and develops users' manuals4 and corresponding training programs for a system being developed. 9. Prepares, in consultation with users, implementers, and operations representatives, the acceptance (or parallel) test plan for any new or changed system. 10. Assists the users in preparing for the installation and start-up of any new system being implemented.

Why is the function key on your laptop stuck?

One reason the Fn key may appear stuck is if you recently plugged a full-size keyboard into your laptop and pressed the NumLock key. This key activates the Fn key on the laptop. To return the Fn key to its original state, plug in the keyboard and disengage the NumLock key. Remove the keyboard and test out any of the Fn assigned keys. They should return to normal working status. If it doesn't however, you may require further troubleshooting.

You can find out if its the numlock by holding the fn key to type normally. if it types normally then and oposite when released then that's the problem. you can turn it off by holding the fn key and presing either the blue "num <arrow down>" or the blue numlock key. (both are numlock just look different on some laptops.

When was factorization-based encryption first introduced?

Went for 1990s but don't know if this is right. Had to pick something. Directly from wikipedia: * 1994 - Peter Shor devises an algorithm which lets quantum computers determine the factorization of large integers quickly. This is the first interesting problem for which quantum computers promise a significant speed-up, and it therefore generates a lot of interest in quantum computers. So looks like 1990's is correct.

In which layer of OSI model does GTP protocol stand?

There are actually two different GTP protocols.

GTP (Go Text Protocol) is basically an application layer protocol, although the definition is a bit fuzzy.

GTP (GPRS Tunneling Protocol) is a transport layer protocol that is used in conjunction with another transport layer protocol (TCP or UDP).

How data will store in DBMS?

Databases store data using any of the robust data structures for efficient management of data. They can use any of the record based logical models to represent the data. Hierarchical, Network or Relational data models.