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 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.
Difference between data dependence and data independence?
data dependance mean the data is dependance upon application programme. when we change in data so also change in application program which we use
Data independance mean data is indpendant on applicaton programme or vice versa . if we change in data so there is no change in application programme
What is a Brio Query File used for?
A brio query file - file extension bqy - is typically an sql query that can be connected to a RDBMS and return an answer or result set. A brio query file is created using Brio explorer or designer software. This sofware creates SQL queries using a graphic interface to render database objects that can be dragged and dropped on to the designer space. Query design is similar to MS Access.
What are the advantages of database systems over paper based systems?
A paper-based system can only be organized in a single way, cannot be easily searched, cannot be easily modified, cannot be accessed remotely, cannot be conveniently cross-referenced, maintained and updated, protected, and cannot be expanded without considerable effort.
Computerized databases solve nearly all of these problems.
Whereas a paper-based system would need extensive labor and reorganization in order to change the sequence and order of data, a digital database could be re-ordered instantly with a single click; thus, data could immediately be re-sorted based on (for example) a customer's name, address, age, average order size, credit rating, etc. Then, the digital version could be re-sorted by another criteria... and then another, all in just a few seconds.
A paper system would require extensive time and man-power to search for a given piece of information, whereas a digital database could instantly find the required data in any field, instantly. Further, a database system could cross-reference data, finding matches within multiple fields, correlate them, perform arithmetic processes on them, and retrieve only the data that matches every single criteria. For example, it could find a list of every customer in a database with an 'A' credit rating who is engaged in heavy construction projects, who has spent more than $40,000 with your company within the past year, and whose current fleet of bulldozers is more than 15 years old... perhaps the perfect lead for your bulldozer sales representatives. To find, analyze and correlate this data by hand would take nearly a lifetime.
A paper system cannot be easily modified and expanded. Updating data requires removing each record's card or file, erasing the old data (or waiting while white-out dries because a former employee violated the 'pencil only' rule), and then carefully entering it again. For bulk updates and batch changes, every single record must be found and updated individually. If the original filing system wasn't conceived to take new fields into consideration, you'll resort to writing on the backs of cards, or meticulously writing in margins, or adding pages to filing systems that were designed for a single page per record. Not so with computer-based databases. Batch updates take seconds, with a click-and-drag function. Need to expand data? No problem, just add a field to the entire database with a single click. Did the law recently change, prohibiting certain information from being maintained on clients? Or does the law now require new accountability for record keeping? Examples could include the FOIA (Freedom of Information Act), or the HIPAA (Healthcare Information Privacy and Accountability Act), or any number of ever-changing state and federal regulations for nearly any industry. With a paper database, you may well be out of business, but with a digital database, you're instantly back in compliance with just a few clicks.
A paper system requires massive amounts of space, climate control, fire protection, lighting, etc. These all add overhead to your operation, whether in the home environment, or a high-level corporate record keeping firm. The paper is a risk, in and of itself, to life and safety due to accidental fire concerns. Paper files are subject to damage from temperature, water (floods, hurricanes), fire, theft, accidental loss and mis-ordering (which, depending on the size of the filing system, could be catastrophic and impossible to correct), and are almost impossible to back-up completely, requiring that an entire new system be duplicated from scratch, perhaps by hand. This dilemma is what prompted the now-obsolete technologies of microfilm and microfiche (essentially condensed photographic slides of files) -- so that data could be archived to save space and backup valuable data. On the other hand, a digital database of nearly any size could reside on a single computer or small network. Perfect digital backups of data can be made instantly to protect against any loss. With a small amount of care and diligent and frequent archiving (perhaps even automatically), there is no reason that there should ever be data loss; these convenient backups can survive and maintain an office's operations, regardless of any threat to the original data, up to and including catastrophes and acts of God. Further, data in a computer database could be encrypted during storage, to prevent any theft or unauthorized copying of information.
Further, whereas an old-fashioned paper file must be visited to be used, for example the card catalogs that are disappearing from libraries everywhere, a digital database, if appropriate and desirable, can be accessed remotely from anywhere, either securely by authorized users, or publicly by anyone connected to the internet. Digital databases fuel internet revenue, essentially allowing buyers to check a business's current stock of merchandise, then automatically edit the inventory sheets when they make their purchase. That sure beats counting items manually, or risking embarassing cancellations for orders when a surprise glitch in the paper filing system shows inventory that doesn't exist, or has been sold.
A business's paper-based system could even be discontinued, and proprietary-sized paper, forms, or storage could become impossible to obtain. The advantages of digital databasing systems over a paper system are innumerable.
Advantages and disadvantages of relational database system?
A pivotal setup in designing a relation database is to design the relations making up the database. Although this might appear to be a simple task, many subtleties are waiting to trap the unwary designer. The Advantages to using a relational database system:
You use tables to create the relation. Inside the tables are primary and alternative keys.
The primary keys create the relation between the tables with the alternative keys. The disadvantage: You can lose information if the keys over lap in the requests made by the creator. Sometimes this is true and sometimes it is not. SQL is a type of database, is called structure query language. Which commonly is know to form the structure of the backbone for most relations database query systems. The popularity of this language is because the American Standard Institute standardized it. Another reason is that it was originally developed and marketed by IBM and has thus benefited from a high level of exposure.
What are the different views of data in a database management systems?
In a database management system, data can be viewed in three main ways:
- Conceptual view: Represents the overall framework or structure of the entire database.
- External view: Shows a subset of the database and is tailored to meet individual user requirements.
- Physical view: Describes how data is stored on the physical storage media.
What are the advantages and disadvantages of information systems?
· Cost effectiveness
· Employment
· Process time
· Access to up-to-date information
· Globalization - IT has not only brought the world closer together, but it has allowed the world's economy to become a single interdependent system.
· Communication - With the help of information technology, communication has also become cheaper, quicker, and more efficient.
· Bridging the cultural gap - Information technology has helped to bridge the cultural gap by helping people from different cultures to communicate with one another.
· More time - IT has made it possible for businesses to be open 24 x7 all over the globe. This means that a business can be open anytime anywhere.
· Creation of new jobs - Probably the best advantage of information technology is the creation of new and interesting jobs. Computer programmers, Systems analysers, Hardware and Software developers.
Disadvantages
· Unemployment - While information technology may have streamlined the business process it has also crated job redundancies, downsizing and outsourcing.
· Privacy - Though information technology may have made communication quicker, easier and more convenient, it has also bought along privacy issues.
· Lack of job security - Industry experts believe that the internet has made job security a big issue as since technology keeps on changing with each day.
· Dominant culture - While information technology may have made the world a global village, it has also contributed to one culture dominating another weaker one. For example it is now argued that US influences how most young teenagers all over the world now act, dress and behave.
The full form of CID can stand for either "Criminal Investigation Department" or "Critical Infrastructure Protection."
Some disadvantages of Management Information Systems (MIS) include high initial setup costs, potential for data security breaches, and the need for ongoing maintenance and upgrades, which can be resource-intensive. Additionally, MIS may lead to information overload if not managed effectively, impacting decision-making processes.
