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 php command to be used to redirect visitotors to customized thank you page after submitting the form?

You should write this line of code before any text is sent to the browser. Remember, even the HTML tag counts. So you can type:

<?php

if (isset($_POST['submit']))

header("location:http://www.mywebsite.com/thankyou.php");

?>

Remember that if statements and other PHP statements that don't actually send output would work, but any output sent to the browser won't. Be careful of that!

What is an ID-Dependent entity?

A special case of weak entity where the identifier of the dependent entity includes the identifier of the entity upon which it depends. Example :

PART(PartNumber, PartName, SalesPrice, QuantityOnHand)
COMPANY(CompanyName, City, Country, Volumn)

QUOTATION(PartNumber, CompanyName, Price) - This entity is id-dependent on the two previous entities.

What is dBase in terms of DBMS?

dBASE is a relational database application, something like Access, FileMaker, or Alpha 5. A DataBase Management System could be used to describe these applications I think, but is generally used for larger, more complicated applications like MS SQL, MySQL, Oracle, etc.

How you delete duplicate row of table in SQL?

This can be different depending on the SQL server involved. Please specify the Database being used (ie, mysql, postgresql, oracle, ms SQL Server) I am using SQL 2005 express, what is the command, i can only get... delete... and what else? lets say i want to delete a duplicate row that is row 2.

What is the retail system?

Retail systems are the enterprise back- and front-office software solutions upon which the majority of retailers rely to manage and support their daily tasks. These systems typically record product performance, which allows the buying personnel to make accurate merchandise purchasing decisions. Moreover, retail systems have capabilities for tracking inventory, capturing sales data, and managing retail prices.

Where can one purchase sql server express?

The "SQL Server Express Editions" are available for free download (and use) on the Microsoft website. Just Google the text in quotes above, and you should find them easily.

You can buy SQL Server Express software online at any retail site that sells software. You can also get this software at general office supply stores.

What are the advantages and disadvantages of a negative database?

i would honestly ask someone who is highly skilled in computers to give you this complex answer i don't know the answer but i can say someone who knows a lot will give you the correct answer to your question

Is email connection oriented or connectionless?

Email runs SMTP (simple mail transfer protocol), where SMTP operates over TCP protocol, so it id connection oriented.

Compare and contrast sequential access storage vs direct access storage?

The terms direct access and random access describe the same concept. They mean that an element of data or instructions (such as a byte or word) can be directly stored and retrieved by selecting and using any of the locations on the storage media. They also mean that each storage position (1) has a unique address and (2) can be individually accessed in about the same length of time without having to search through other storage positions. For example, each memory cell on a microelectronic semiconductor RAM chip can be individually sensed or changed in the same length of time. Also, any data record stored on a magnetic or optical disk can be accessed directly in about the same period

Sequential access storage media such as magnetic tape do not have unique storage addresses that can be directly addressed. Instead, data must be stored and retrieved using a sequential or serial process. Data are recorded one after another in a predetermined sequence (e.g., numeric order) on a storage medium. Locating an individual item of data requires searching the recorded data on the tape until the desired item is located.

(Tha answer was got from Managment Information System book, written by James O'brien and George Marakas)

How can you get email data base of gmailcom users?

You cannot just retreive the email database. It is the private property of the Gmail users. Moreover it is guarded by the protocols of Gmail.

When do you use databases?

A library user uses databases to quickly find articles that match your search criteria. You can look articles up by keyword, subject, author and title. These search criteria are called access points. If you want to find scholarly articles on a specific topic look for a subject-specific database that corresponds to your area of interest. Databases are not all alike. Some databases focus on scholarly articles and others like Lexis-Nexis allow the user to search news articles. Bibliographic databases are more useful for academic research since you are able to find scholarly articles that are published sooner than articles that are accessed slower, such as print. Databases give you a list of multiple articles that are authored by one author or a team of authors. You can specify your search criteria to try to find almost anything you want. If you want more personalized research guidance, try to speak with a reference librarian. Elizabeth Sher, Librarian

What is the purpose of Decision Support System in MIS?

The decision support system in MIS helps the management level staff to make comparisons and alter certain processes for smooth running of the business. The system acts as a guide.

Duplicate tuples not allowed in a relation?

In a relation we have number of tuple R ={t1,t2,t3.....tn}, nd they follow integrity constraints nd each tuple has a primary key pk.if any of the d two tuple have same attribute. for instance t1=t2 then its pk wud be same too.. but this violates the key constraint..

hence duplicacy not allowed in tuple...

enjoy

Rijo Rajan

MTL stands for what in Oracle applications 11i?

In the underlying table structure, the MTL is short for 'materials'.

For example, the MTL Transaction Interface table is used to issue and receive items in an out of inventory.

What is a user database?

A user database is a system that more than 1 person can access and gain information from. Multiple users can input and store data in these database systems.

Can an application like EXCEL normally export spreadsheet data to a database application?

Yes you can. Spreadsheets are normally laid out in columns and rows with headings, like you would have fields and records in a database. With that structured layout, data in Excel can easily be exported to various database applications. There are various approaches you can take, like directly exporting them or saving the data as a text file and opening it for importing into a database.

Is the OSI model a protocol?

Answer: It's a model, not a protocol. The OSI model is a governing model of standards in which protocols are derived or fit into in the case of legacy models. The OSI model was developed by ISO(International Standards Organization). The OSI model encapsulates many popular legacy and current protocols including TCP/IP, IPX/SPX, and NetBIOs derivatives, including Microsoft's NetBEUI. The OSI model also includes specifications that allows communications engineers whos specialties are on different layers of the OSI model to communicate and accelerate delivery of better communications to the end user. So from DSL, modem, satellite to your web browser, the OSI model applies. e

Definition of closure in dbms?

In Relational algebra allows expressions to be nested, just as in

arithmetic. This property is called closure.

Do queries store data?

No. Only your tables store data. Queries, Forms, Reports and Pages can just do things like display the data and manipulate it but, the data is always stored in the tables. When you run a query, open a report or a form, the data you see is ultimately coming from underlying tables. You can do queries on queries, or reports on queries or forms on queries but the original data always comes from the tables.

Explain the OLAP and OLTP system with example?

OLTP vs. OLAP

We can divide IT systems into transactional (OLTP) and analytical (OLAP). In general we can assume that OLTP systems provide source data to data warehouses, whereas OLAP systems help to analyze it.

- OLTP (On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF).

- OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations. For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).