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
major components of database management system are as follow.
1) Software.
2) Hardware.
3) Data.
4) Procedure.
5) Access language.
Software:
software plays an important role in the DBMS.
How do you retrieve data from database in PHP?
There are many factors that must be taken into consideration when looking to retrieve data from a database, such as 'what database management system do i posses/supported by my host?' in most cases people looking to retrieve data using php posses SQL database management systems such as MySQL in their control panel which can be used to create, delete and alter databases, along with creating multiuser access to the databases.
once the databases are created and their respected users are added and given their database privileges, one can begin adding and proccessing data to and from a database.
assuming that all the previous has been acheived and there is data in the database, below is a set of php/mysql functions that can process multiple rows of data in a database table.
$link = mysql_connect ("localhost", "USERNAME HERE", "PASSWORD HERE") or die (mysql_error());
$mysql_db = mysql_select_db ("DATABASE NAME") or die (mysql_error());
$db_search = mysql_query("SELECT * FROM `TABLE NAME`");
if (@mysql_num_rows($db_search) > 0) {
while($data = mysql_fetch_array($db_search)) {
}
}
first you connect to your host, then select the database, query a selected table, check for rows of data in the table, place the array of data into a variable, and do what you please with the data now contained within that variable.
for more information go to php.net/mysql
Data base state vs database schema?
The database schema is the description of the database. It defines how the database is set up and what data it is to contain and control. This description is given to the DBMS to manage the data. The database state is an image of how the database looks at any given time. The database schema is set unless you change how the database is structured. The database state will change whenever new data is entered into the database and the database is updated.
How to Normalization in arcgis?
In ArcGIS, normalization is typically achieved by using the Field Calculator to calculate normalized values based on a chosen formula or method. You can create a new field and populate it with normalized values by dividing the original values by a chosen factor (e.g., the sum of all values in the field) to scale the values between 0 and 1.
What is instance in peoplesoft?
In PeopleSoft, an instance refers to a separate installation of the PeopleTools software and databases, used to run a specific set of applications or modules. Each instance is usually dedicated to a specific environment, such as development, testing, or production. Instances allow for isolation and customization of settings for different purposes.
What are the disadvantages of paper databases?
Disadvantages of database:
1.Number of problems are associating with centralized data.
2.cost of hardware and software.
3.complexity of backup and recovery machanism.
by
Ankit Kumar
RM1001B36
Object-relational database management system (ORDBMS) is a type of database management system that combines characteristics of both relational database systems (RDBMS) and object-oriented database systems. ORDBMS allows the storage of complex data types like images, audio, and video in addition to traditional data types, and supports object-oriented programming concepts such as inheritance and encapsulation. This makes it suitable for applications that require handling both structured and semi-structured data.
What are the disadvantages of a paper based system?
Disadvantages of paper based communication:
There are many benefits towards this communication method but they always come at a cost!
Issues arise as cost of sending away Via. stamps and delivery, other areas are the writers hand writing quality along with the grammar and spelling mistakes.
Some paper based methods do occasionally result in typed up letters printed off and sent away but these letters can include typo's, other mistakes, Etc.
Also when you send away a letter to another destination there is always the issue of the time taken to deliver it as it can take among weeks to even months on delivery and many times, the letter is either damaged or returned which can be again a huge issue!
Hope this short explanation is helpful
What is a complete set of data about one item called?
A complete set of data about one item is called a data record. It typically includes all relevant information or attributes related to the specific item being described or analyzed.
List three types of information contained in a hard drive's partion table?
This table of information contained is,the table tells BIOS how many Partion the drive has and how each parition is divied into one or mone logical drivers and which partion contains the drive to be used for booting called the active boot and where each logical dive begins and ends
How can users access information from a companys internal database trough the web?
Users can access information from a company's internal database through the web by setting up a secure web portal that connects to the database. The portal can use authentication mechanisms to verify user identity before granting access to specific data. Employing encryption protocols and regular security updates can help safeguard sensitive information while allowing authorized users to retrieve the data they need remotely.
What are various components of a warehouse?
A warehouse is a place where items are stored.
Usually main features that make a warehouse are: four walls and a roof, lockable door, and perhaps a security system. People also like having some shelfs in their warehouse or other method for storing goods, like fridgerators, crates or barrels.
it would not hurt to have also some kind of book-keep of the items coming and going.
dbms- database management systems............ it is a collection of interrelated data and the set of programs to access those datas....... it is used to meet the disadvantages of the file systems....... there are many disadvantages of filesystems....... lik,, data redundancy and data in consistency, difficulty to access data,integrity problems, atomicity problems............. dbms is quite complicated but better than file systems
What is a database approach and what is a file-based approach?
A database approach is a method of managing and organizing data using a structured repository that allows for efficient retrieval, storage, and manipulation of information. On the other hand, a file-based approach involves storing data in separate files and organizing them manually, which can result in redundancy, data inconsistency, and limited accessibility compared to a database system.
The main types of database management systems (DBMS) are relational DBMS (RDBMS), NoSQL, and object-oriented database management systems (OODBMS). RDBMS like MySQL and PostgreSQL store data in tables with rows and columns, NoSQL databases like MongoDB offer more flexibility in data storage, and OODBMS are designed to work with object-oriented programming languages.
5 parts of information system?
- Hardware: Physical components like servers, computers, and networking devices.
- Software: Programs and applications that process data and enable user interaction.
- Data: Raw facts and figures that are processed and stored by the system.
- Procedures: Rules and guidelines for using, maintaining, and securing the system.
- People: Users, developers, administrators, and other stakeholders who interact with the information system.
What are the two commands in the usmt?
Two common commands in the User State Migration Tool (USMT) are "ScanState" and "LoadState." "ScanState" is used to collect user profiles, files, and settings from the source computer, while "LoadState" is used to restore and apply the collected data to the destination computer.
What are the two command promt commands in the USMT?
Two command prompt commands in the User State Migration Tool (USMT) are "scanstate" (used to collect user profiles, OS settings, and application settings) and "loadstate" (used to restore the user profiles and settings to a new or updated Windows installation).
Disadvantages of a paper-based database?
Paper-based database is a collection of data on paper. There are many disadvantages when using paper-based database, some of the disadvantages are: Difficulty in sorting data, changes are done manually, no security, difficulties in sorting data.
Is there any difference between integrity and correctness of data in DBMS?
Integrity refers to the structure of the data and how it matches the schema of the database.
Correctness could refer to either the integrity of the data or its accuracy (for example, a phone number being incorrect).
What are the advantages of paper based databases?
Paper-based databases are easy to understand and use, do not require electricity or technical expertise, and can be accessed without the need for internet connection. Additionally, they provide a physical backup in case of digital failures.
What are the benefits of databases?
2.centralized control
3.backup and recovery
4.shared data
5. providing multiple user interface.
6.restricting unauthorized access
7.Enforcing integraity constrainty
BY
Ankit Kumar
lpu (lit)
RM1001B36
What is called an collection of records in data processing?
In data processing, a table is a collection of records of the same type.
Often a table is stored in a file.
A collection of several tables ... well, that's another question (see below).
What is the difference between database and data warehouse?
Typically, a database versus a data warehouse, is "OLTP" (online transaction processing). That means that live inserts/updates/deletes happen to the database all the time. A data warehouse is used for statistics and trending. Nighly data feeds from stores are populated into the tables. During the day, no inserts/updates/deletes occur on the database--it is used for data gathering (queries) only.
Can you delete information off of a floppy?
Yes, information can be deleted off of a floppy disk by simply deleting the files or formatting the disk. Once the data is removed, it is not immediately visible but may still be recoverable using specialized software.
