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
How is a database view different from tables?
A database view is a dynamic table compared to the 'fixed' ones.
A view contains a select statement, which dynamically updates the table everytime the view is looked at and the data has changed. Since these queries are compiled they will be faster than normal queries.
Example:
Table A:
ID, Integer
FullName, String
Table B:
AID, Integer
Address, String
You would like to find the address for each person.
Instead of making a long select each time you want a specific address for a specific person. You could make a select, that joins the data, make it into a view, and then use the View afterwards. Like:
SELECT a.id, a.fullname, b.address FROM a, b WHERE a.id = b.aid;
This will be your view, tView. Now the data:
SELECT * FROM tView WHERE fullname = 'John Randomness'.
What is the Difference between oracle apps technical and functional consultant?
At a very high level
Oracle Apps Functional Consultant -> One who understands business flows/processes and ways to do setup/tweak in oracle application to suite business needs.
Oracle Apps Technical Consultant -> One who understands the oracle application architecture and table-relations etc.
How many database functions does excel use to evaluate numeric data in a table?
No, it has far less than that. It has 12 specialised database functions. They are DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP. In addition, it would be possible to use many other functions to manipulate data in a database. Even the total amount of functions in Excel is much less than 1000 functions.
a key is used to unlock a door or a bag...it is used for protection and is normally used to secure private stuff..
Can you surf the web by using command prompt?
I just want to know if you can surf the internet with a command prompt?.
No, there is no Internet browser built-in to Windows Command Prompt. But there is a text-only browser called Lynx that runs on CMD; after you have downloaded it, you can run it on CMD and browse the web. There is also another browser called Arachne, which also runs on CMD and supports a wide variety of images, videos and other media.
Map a Network Drive from CMD
net use x: \\SomeServer\SomeShare
Try these commands:
- net /?
- net use /?
- net help use
Who is responsible for managing user access to specific Defense Manpower Data Center applications?
Sight Security Manager or SSM.
Integrity is protecting data from unauthorized modifications and destruction?
MACKEEPER DEALS: Clario Tech Limited the UK-based company present product MacKeeper, an award-winning system utility which includes a set of powerful maintenance features for Mac Optimization, Security, Data Control and Cleaning. So it is like 911 for your Mac. visit the link: htt ps://cutt.us/Ak9oE
minicomputer are smaller than mainframe general purpose computer, and give computing power without adding the prohibitive expenses associated with larger systems.
microcomputers are even smaller than minicomputers. the computer you are using to read this is almost certainly a microcomputer.
Configuration management helps control shared information?
Yes, configuration management helps control shared information.
Configuration management provides complete information on the changes to the physical and functional configuration of a weapon system and its component parts. In addition, CM ensures that everyone requiring this information has access to updated and accurate documents.
https://learn.dau.mil/CourseWare/800840_4/media/Configuration%20Management.pdf
The Linux ext3 file system is the default system in many linux derivatives. It allows for journalling, which the ext2 system did not. It also allows in-situ upgrades without asking for a backup first.
In relational databases and flat file databases, a tableis a set of data elements (values) that is organized using a model of vertical columns (which are identified by their name) and horizontal rows. A table has a specified number of columns, but can have any number of rows[citation needed]. Each row is identified by the values appearing in a particular column subset which has been identified as a candidate key.
Table is another term for relations; although there is the difference in that a table is usually a multi-set (bag) of rows whereas a relation is a set and does not allow duplicates. Besides the actual data rows, tables generally have associated with them some meta-information, such as constraints on the table or on the values within particular columns.
The data in a table does not have to be physically stored in the database. Views are also relational tables, but their data are calculated at query time. Another example are nicknames, which represent a pointer to a table in another database
What is the difference between entity relationship diagram and extended entity relationship diagram?
Realtional databse is the type of databse which is bascially designed to store the deta on OLTP(Online transaction Processing) systems. Entity relatioship databases are basically designed for reporting perpose. It store the Data from OLAP( online Analytical Processing) systems.
Why is accurate data important?
Accurate data is important because if someone tried to go off the outcome of your experiment with incorrect results then it could harshly effect their own experiment. It creates a domino effect. If one person goes off your false data then other people could go off theirs so on and so forth...
Advantages of prototyping over sdlc?
SDLC models Advantages & disadvantages Advantages of Waterfall Model
1. Clear project objectives.
2. Stable project requirements.
3. Progress of system is measurable.
4. Strict sign-off requirements. Disadvantages of Waterfall Model
1. Time consuming
2. Never backward (Traditional)
3. Little room for iteration
4. Difficulty responding to changes Advantages of Spiral Model
1. Avoidance of Risk is enhanced.
2. Strong approval and documentation control.
3. Implementation has priority over functionality.
4. Additional Functionality can be added at a later date. Disadvantages of Spiral Model
1. Highly customized limiting re-usability
2. Applied differently for each application
3. Risk of not meeting budget or schedule
4. Possibility to end up implemented as the Waterfall framework Advantages of Prototype model
1. Strong Dialogue between users and developers
2. Missing functionality can be identified easily
3. Confusing or difficult functions can be identified
4. Requirements validation, Quick implementation of, incomplete, but
functional, application
5. May generate specifications for a production application
6. Environment to resolve unclear objectives
7. Encourages innovation and flexible designs Disadvantages of Prototype model
1. Contract may be awarded without rigorous evaluation of Prototype
2. Identifying non-functional elements difficult to document
3. Incomplete application may cause application not to be used as the
full system was designed
4. Incomplete or inadequate problem analysis
5. Client may be unknowledgeable
6. Approval process and requirement is not strict
7. Requirements may frequently change significantly
How do you design a database management system for stock exchange?
You would need at the very least 3 tables.
1. TblCompany
Assign them a unique ID.
Ticker (Symbol)
CompanyName
Industry
Sector
2. tblDate
OpenedStockDays
...
...
3. TransactionTable
Ticker
OpenedStockDays
Open
High
Low
Close
Volume
make sure to link them properly and to always set a primary key for each table.
How do you backup and restore mySQL Database using PHP scripts?
You have to create two scripts, one for export and one for import. Data you get from database don't have to be in specific format, as long as you store whole information at all times.
You will have to make an export script, that basically SELECTs all the data of all tables you want to backup. Those data can be stored for example in a TXT file. It is very important that you save all the information about a data (e.g. from which table these data come from, what is the data context, and so on).
When you need to import data to a new database, you can read a TXT file, create a database structure using SQL function CREATE TABLE and then import read data using SQL command INSERT.
It's considered the best solution to encapsulate export and import features into functions.
Example of primary key and foreign key?
primary key means unique as well as non-nullable field for a table it supposed don't have duplicate value.
foreign key means is referential field in a table meanwhile is primary key for another table.
First of all what is DBMS?
DBMS is DataBase Management System. It is a special software that manages databases.
One of features provided with DBMS is transactions that uses logging system very often.
Log is a special table (most of the time) there all activity (logging to system, removing, editing, creating, etc) inside database is logged and could be later used for other purposes. It could used by transaction mechanism in order to recover old data or for administration purposes.
It depends on the database software. General syntax is:
create table TABLENAME define columns (data type, not null)
What is the difference between sql server and ms sql 2000 database?
SQL Server is most often referred to as Microsoft SQL Server, but there is also a Sybase SQL Server which was originally created on UNIX in 1987. MS sql 2000 database, or Microsoft SQL Server 2000 is a database server product. So, when you ask what is the difference, I do not see a difference, they are one in the same. Unless your question is asking for the difference between the Sybase version and Microsoft version, or you are wanting to compare different versions of Microsoft SQL Sever. In which case, I think your question must be more specific. arnel... SQL stands for (Structured Query Language). A SQL server can cover a host of products. Oracle is a SQL server however when speaking of Oracle people usually refer to it is Oracle. The server in fact is a SQL server. Microsoft SQL server is often simply referred to as SQL Server not because they 'own' the product or anything, just because of the popularity. I can draw a parallel for you. When you own a SeaDoo watercraft (as I do) people will refer to it as a jetski, same with a Kawasaki, Polaris, or any other brand. The fact is that this name (JetSki) is used interchangable however the Kawasaki Standup model watercraft is the only true 'jetski'. Anyway there are many 'flavors' of SQL server (MYSQL, Oracle, MS SQL Server, Postgress SQL, just to name a few. You can find more information about SQL server, its history and some additional 'flavors' at this link: http://en.wikipedia.org/wiki/SQL Hope that helps. Jwilliamsoh http://jwilliamsoh.spaces.live.com/
Its is the button battery that stores the BIOS settings for your computer.
Typically forms gather two kinds of informations personal data and information?
information specifc to the fourm
What is the meaning of Database security?
Database security refers to the many steps taken by businesses to protect their databases from both internal and external threats. The database, the data it holds, the database management system, and the numerous applications that access it are all covered by database security.
To learn more about data science please visit- Learnbay.co
Why is the computerized system not effective in all situations?
* computerized system is not effective in all situation because it is newer it is not a manual system and it make it own decisions and it use in busnisses markets home etc..
