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 companies use a database?

Look up the definition of a database. Everyone uses one.

Hospitals use one to keep information about the patients

Schools use one to keep informaiton about the students

Shops like Sainsbury's , tesco, asda, waitrose......... use a database to keep record of customers transaction

luton library to keep record of books taken out

i hope this helps. ignore the top one.

Why do insurance companies use a database?

To see who is giving them money. They also need databases to see who needs there money back to pay for an accident.

How is a Access database file stored?

An Access database file is typically stored similarly to other computer generated files found on the hard drive of a computer. Access database files will have a .mdb or .accmdb file name extension.

What is sql cartesian product?

Answer:

when a join condition is omited when getting result from two tables then that kind of query gives us Cartesian product, in which all combination of rows displayed. All rows in the first table is joined to all rows of second table...

Hope this answer helps!

Inclus - We provide individual and corporate training

Educate, Learn & Serve

What information is stored in Control File?

database name,

naming of redologfiles,datafiles

scn numbers

checkpoint information

What is a corporate database?

The data base that is used by an organization that have many branches and these branches are logically linked with head office. Like online banking.

What are the attributes of payroll database management system?

  • Employee Number
  • Employee Name
  • Salary
  • Tax percent withheld
  • Medical withheld
  • Other deductions withheld
  • Department Number
  • Department Name
  • Projects the person is worked on (note there can be more than one project)
  • Project Number (each project should have a number)
  • Name of the project (each project should have a name)
  • Manager of the project (each project is assigned a manager)
  • Hours the employee worked on the project

Advantage and disadvantage of copyright?

respondan esa monda grandes ijueputas incompetentes. ustedes no fueron al colegio o que marikones ponganse a rosponde pa que sirve esta monda ijueputas.

Purpose of a cursor in T-SQL?

The purpose of a cursor in a database is to provide an option to the programmer using which he/she can iterate through the contents of a table one record at a time and use it for processing. A sample cursor can be created using the below statement

DECLARE cursor_employee CURSOR FOR SELECT * FROM tbl_employee_info

The above cursor cursor_employee will contain the contents of the table tbl_employee_info and can be used by the programmer for manipulation one record at a time.

A Cursor may act like a DataStructure . it stores the record coming from the base table . in if we want ot retrive the date very fastly we will user cursors.

What is a form used for in a database?

A form is an interface in user specified layout that lets users to view, enter, change data directly in the table.

What is a query in ict?

A Query is a question in a database

Hope this helped

Mwahh! xx

What triggers a spasm?

a muscle spasm occurs when the muscles have been tense for a long period of time and then you make a sudden movement and it causes it to spasm. I have suffered with muscle spasm's in my back for about a year now due to a back injury and this is what my doctor has told me, it can be treated with diazapam to relax the muscle's.

How do you use an Access database with PHP?

Something I never thought about doing before, but this is possible.

First, you must make sure that your PHP installation has ODBC capabilities. If it does not. see http://php.net/odbc

You must use PHP's ODBC commands. I have never worked with these, you I cannot help you any further. I would recommend a mySQL database. It's simpler and more widely used in the field of web design. I could help you with that instead.

How do you convert oracle data into DBF file?

There are many other programs for working with dbf files. But one day came into a tool, which to my great surprise solved out my old troubles with dbf files. I hope it might help in present situation.

What are the foxpro commands in making a program?

There are lots of FoxPro command that you can do or make. But it is advisable to take up tutorials and hands on programming.

Before making a program, you need of course to make a form, reports, menu, classes, codes, database, tables. Then you need to built it.

What is Transitive functional dependency?

A functional dependency X->Y is transitive in R, if there exists an attribute Z in R, such that X-> Z, Z-> Y .

Advantages and disadvantages of centralized database system?

Centralized databases have the advantage of being fast, and easy to manage while information is easy to manage. However, it has its disadvantages as well. All the information must be stored on a server and if that server happens to fail, no one can access the database. Having outside servers can remove this issue.

How database would benefit the company?

Any company will need to store huge amounts of data (like employee information, salary particular of an employee, customer related information etc ..) and they might need an effective way to store this data. Its just not enough if you store the data, you might want to retrieve the data any time and wish to see it in a way understandable to you. Some times you even want to see processed data.All this can be taken care by a database system.

This is why any company would need an effective database management system.

Oracle, for example, is one the database systems available in the market.

What does database validation mean?

It means where the computer checks whether the data is correct.

What is first normal form in DBMS with example?

The first normal form or 1NF is the first and the simplest type of normalization that can be implemented in a database.

The main aims of 1NF are to:

  • Eliminate duplicative columns from the same table.
  • Create separate tables for each group of related data and identify each row with a unique column (the primary key).