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
Say S1 is the number of boys in the dorm, and S2 is the number of students receiving financial aid. Then, S1 not in S2 would be students that do not receive financial aid. If M1 < M2, then a lower proportion of boys than girls receive financial aid. Say that S1 is the number of boys in the dorm, and S2 is the number of students receiving financial aid then, S1 not in S2 would be students that do not receive financial aid. If M1 < M2, then a lower proportion of boys than girls receive financial aid.
What is advantage of using an rdbms over dbms through practical example?
It can be used for storing large amounts of data. entities are related to each other which makes it easy and quick to access results. from Parikshit
What is constraints in database management system?
Constraints are sort of restrictions, which restrict the data that can be stored in a relation (Table). or
Constraints are mostly a collection of indexes and triggers that restrict certain actions on a table. There are four types of constraints:
Primary Key ConstraintsUnique ConstraintsCheck ConstraintsForeign Key (FK) Constraints.
- chandrabhan
Write Procedure to implement highlight as a blinking operation?
Blinking text in DOS, compiled with Turbo C #include
int main()
{
int color;
textattr(128 + 10);
cprintf("This is blinking text\n");
return 0;
}
Eight bits form a byte. 1000 bytes = 1 kilobyte, 1000 kilobytes = 1 megabyte, 1000 megabytes = 1 gigabyte, and so on.
Advantages of RDMBS
1. Data Structure:
The table format is simple and easy for database users to understand and use. RDBMSs provide data access using a natural structure and organization of the data. Database queries can search any column for matching entries.
2. Multi-User Access:
RDBMSs allow multiple database users to access a database simultaneously. Built-in locking and transactions management functionality allow users to access data as it is being changed, prevents collisions between two users updating the data, and keeps users from accessing partially updated records.
3. Privileges:
Authorization and privilege control features in an RDBMS allow the database administrator to restrict access to authorized users, and grant privileges to individual users based on the types of database tasks they need to perform. Authorization can be defined based on the remote client IP address in combination with user authorization, restricting access to specific external computer systems.
4. Network Access:
RDBMSs provide access to the database through a server daemon, a specialized software program that listens for requests on a network, and allows database clients to connect to and use the database. Users do not need to be able to log in to the physical computer system to use the database, providing convenience for the users and a layer of security for the database. Network access allows developers to build desktop tools and Web applications to interact with databases.
5. Speed:
The relational database model is not the fastest data structure. RDBMS advantages, such as simplicity, make the slower speed a fair trade-off. Optimizations built into an RDBMS, and the design of the databases, enhance performance, allowing RDBMSs to perform more than fast enough for most applications and data sets. Improvements in technology, increasing processor speeds and decreasing memory and storage costs allow systems administrators to build incredibly fast systems that can overcome any database performance shortcomings.
6. Maintenance:
RDBMSs feature maintenance utilities that provide database administrators with tools to easily maintain, test, repair and back up the databases housed in the system. Many of the functions can be automated using built-in automation in the RDBMS, or automation tools available on the operating system.
7. Language:
RDBMSs support a generic language called "Structured Query Language" (SQL). The SQL syntax is simple, and the language uses standard English language keywords and phrasing, making it fairly intuitive and easy to learn. Many RDBMSs add non-SQL, database-specific keywords, functions and features to the SQL language.
What are the Costs and risks of the database approach?
The costs and risks are of DB approach are categorised into 5 factors . They are * New specialized Personal * Installation and management cost and complexity * conversion costs * Need for explicit backup and recovery * organizational conflict
In a new information system, on a directinstallation, the new system is installed and quickly made operational, and any overlapping systems are turned off. It is also know as immediate cutover.
What may the drawbacks be of not upgrading?
the drawbacks of upgrading become official like everything else is on our computer systems
In a database files are called?
A database holds records in files that are called tables. Each table has a specific key that defines that table and each master key is unique.
What are the disadvantages of normalization?
Queries run slower because of the "joins".
It is necessary to assign relationships to interact with different tables
Data will lose when dinormalising.
Some disadvantages of normalization are that it creates an average, it is not precise, and takes away from the true results. This is helpful when determining overall results across many samples.
System are Integrated with the increase in quality of cloud software package and apps, businesses have begun taking associate degree integrated approach to IT business systems together with potential issues that occur with it. Thus, our consulting and system integration services will assist you synchronize all of your systems and processes to work seamlessly along therefore you get the foremost productivity and potency out of your digital ecosystem.
visit us-:
reliableinfotechsolutions
Will Adabas only run on a server or mainframe?
As far as I know,ADABAS C will run on Mainframe and Unix platoforms; ADABAS D will run on PC. O.
What size for a picture is '1mb'?
Usually pictures of JPEG or BMP occupy more space than the GIF which occupies the low space. In JPEG and BMP there is space for the background also.
A database record is a row of data. The row contains fields that are arranged in columns. Each field contains a single piece of information.
What are the examples of word processing?
There are many application specific platforms for word processing. Microsoft (MS) Windows (XP and later) operating systems came preinstalled with Notepad. The industry and global standard suite using MS Office remains with the 2015 edition soon to be released. Open source and free word processing programs include Open Office and Android Office. Due to standardization .doc and .docx are fairly universal word processing files that can be opened and edited across multiple platforms.
Control: this is an example of the item you experimented on before any changes
:) have fun...
What are the Types of database schema architecture?
The Star & Snowflake are two common type of database Schema.
What are the disadvantages of a periodic inventory system?
The perpetual inventory system is more complicated, requires more accounting entries and is more costly the periodic inventory system does.
What is the difference between setup and configure?
The difference is that setup mainly involves functional tasks, installation, etc. To configure is to further customize options and setting.
What is economic feasibility How do you know if a project is economically feasible?
Economic feasibility is the analysis of a project's benefits and costs. The purpose is to help management decide whether or not they should continue. If the future benefits outweigh the estimated cost of developing or acquiring the new system then it is economically feasible.
