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 do you mean by Referential Integrity?

Referential integrity is a database concept that ensures relationships between tables are maintained. It ensures that a foreign key in one table points to a valid, existing primary key in another table, preventing orphaned records or invalid data relationships. This helps maintain data consistency and accuracy within the database.

Definition of manual database?

A manual database is a system for storing and organizing data using physical documentation such as papers, files, or books instead of using digital software or electronic devices. Users enter, retrieve, and manage data manually by writing or typing into the physical records.

What is database reflection?

Database reflection is the ability of a system to examine the structure and properties of its own database at runtime. It allows applications to dynamically interact with and modify database schemas without hardcoding specific details, providing flexibility and adaptability in database operations. Reflection is commonly used in ORM (Object-Relational Mapping) tools to map database tables to object-oriented classes.

What is Hanging indent?

One of the general rules of reference list in APA citation is the indention of the entry should be a hanging indent. If the source should take up more than one line, a hanging indent should be applied to the second line by pressing the TAB key.

What is a library database?

A library database is a system on which every library owned item is listed. Is this day and age it is usually a computerised database. It enables library staff to know exactly what stock is in the county/area and whether it is on loan or missing or whatever.

You wants to print a single record in crystal report using vb6 but you don't where and how you write query to retreive single from database?

As you enter Visual Basics select windows form applications. Name form, select single or multiple. After selecting what sort of form you like to create proceed to link your contacts page or table to database. Apply filter query and select printer action.

In Access text data type contain maximum character of?

In Access, the Text data type can hold up to 255 characters. If you need to store more characters, you can use the Memo data type, which can store up to 65,535 characters.

What is the application appropriate for an object-oriented database that contains text links to other types of documents?

An object-oriented database with text links could be used for managing a knowledge base system. Users can easily navigate between different types of documents through the text links, facilitating information retrieval and organization. This could be particularly useful in content management systems, digital libraries, or collaborative research platforms.

What happens if you convert memo data type to text?

When you convert a memo data type to text, any text stored in the memo field will be converted to plain text format. Any formatting, such as line breaks or special characters, may be lost during this conversion.

Why is some data coded for storage as text in database?

Storing data as text in a database allows for easy manipulation and querying using text-based functions and tools. It also provides flexibility in terms of accommodating different data formats and structures. Additionally, text data is human-readable, making it accessible for analysis and reporting purposes.

What types of data can be stored in a text data type field?

A text data type field can store alphanumeric characters, such as letters, numbers, and special symbols. It is suitable for storing large amounts of text data, such as descriptions, comments, or notes. Text data types can hold variable lengths of text, depending on the database system used.

What is the relationship between tables in library management system?

In a library management system, tables represent different entities such as books, users, transactions, etc. The relationship between these tables is established through keys like primary keys and foreign keys. For example, the books table may have a primary key "book_id" which is referenced as a foreign key in the transactions table to link books with users.

How many characters are allowed in a data type of text?

The maximum number of characters allowed in a text data type varies depending on the database system being used. For example, in MySQL, the maximum length is 65,535 characters, while in PostgreSQL, it is unlimited (1GB). It's important to check the specific documentation of the database system to determine the exact limits.

Is text an access data type?

No, "text" is not an access data type. In Microsoft Access, commonly used data types include Text, Number, Date/Time, Memo, and Yes/No among others. Text is used to store alphanumeric data such as names or descriptions.

The coding system for text base data?

The coding system for text-based data refers to the character encoding used to represent text characters as binary data in computers. Examples of coding systems include ASCII, Unicode, and UTF-8, each with its own set of characters and encoding rules. By using a specific coding system, text data can be stored, processed, and displayed correctly across different platforms and devices.

Objective of library system in database system?

To provide for the information needs of the students and teachers.

To provide for the leisure reading needs of the students.

To support instruction with information and audio-visual resources.

To provide instruction in research and literacy skills.

To originate and support literacy initiatives and activities in the school.

--Okay - we're getting more into the "role of the school librarian," but I think those objectives are worth mentioning as well.

A library media specialist consults with teachers about the curriculum, and serves as the school's information specialist.

Object oriented database pdf for airline system?

I'm not able to provide direct links to specific PDFs, but you can search for "object oriented database design for airline system" on academic databases or search engines like Google Scholar to find relevant research papers or articles. Additionally, you may find textbooks or academic resources on object-oriented database systems that may provide examples or case studies related to airline systems.

Importance of text in a multimedia presentation?

Text is the most widely used and flexible means of presenting information on screen and conveying ideas. The designer should not necessarily try to replace textual elements with pictures or sound, but should consider how to present text in an acceptable way and supplementing it with other media. For a public system, where the eyesight of its users will vary considerably, a clear reasonably large font should be used. Users will also be put off by the display of large amounts of text and will find it hard to scan. To present tourist information about a hotel, for example, information should be presented concisely under clear separate headings such as location, services available, prices, contact details etc.

What is octodecimal?

The octodecimal positional numeral system is an 18-base counting system that was utilized as a cycle in the Mesoamerican Long Count calendar.

See the related Wikipedia link listed below for more information:

How can you create your own database without using any DBMS but using text file as already aforementioned?

You do not need a DBMS to store data to the computer's harddrive. Rather than using a DBMS, look into using files, or file managment system in the computer language you are using. Most computer languages allow you to find, open, and edit text files directly, but that code is very language specific.

What format can you convert a Brio Query file ext of BQY in to a readable text format?

Using the Hyperion/Brio Client, a Brio Query File (.bqy) can be exported (File > Export > Section) to either an HTML (.htm), Lotus 1-2-3 (.wks), Text Tab Delimited (.txt), jpeg (.jpg), pdf (.pdf) or Excel (.xls).

What is the difference between procedures and functions?

Functions return a value.

NoteThere are no procedures in C, only functions with no return value (type void is used to indicate that).

In general a function is the purpose or what a system actually does( what output it returns) and a procedure is how that output is returned.

What is nominant data?

It is qualitative data such as male or female, red hair or black.

This different than quantitative data such as inches of rain or gallons of milk.

What is vpn hard token?

This is very tuff to find wat is vpn hard token, kindly discuss if some 1 knows better