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 is data base?

A data base is where it allows you to Store information about something and it also includes fields.

What are the advantages and disadvantages of using database?

Advantages It means all of the information is together. The information can be portable if on a laptop. The information is easy to access at any time. It's more easily retrievable. Many people can access the same database at the same time. Improved data security. Reduced data entry, storage, and retrieval costs.

Disadvantages Database systems are complex, difficult, and time-consuming to design. Initial training required for all programmers and users. Suitable hardware and software start-up costs. A longer running time for individual applications.

Discuss the rational individual models of decision-making What are the implications of these models to information system analysts?

Rational individual decision-making models assume individuals make decisions that maximize outcomes. Implications for information system analysts include designing systems that provide relevant information for decision-making, ensuring data accuracy and availability, and incorporating decision support tools to aid in the decision-making process. It is crucial for analysts to understand these models to develop effective and user-friendly systems that align with rational decision-making processes.

What are the techniques of data mining?

Data mining is one part of the process of Knowledge Discovery in Databases. There are many techniques within data mining that aim to accomplish different tasks. Generally tasks fall into one of two categories, predictive or descriptive. Predictive tasks look at historical data to predict what will happen in the future. Descriptive tasks will look at some given data and find patterns in it. Since data mining is a growing area, the techniques are constantly changing, as new improved methods are discovered. At present, some of the most well known predictive algorithms, known as classification algorithms include Naive Bayes, SVM, Decision Trees (such as C4.5), Artificial Neural Networks, k-Nearest Neighbour and more. Some predictive algorithms are able to perform regression, a form of prediction for non-categorical data. Some of the most well known descriptive algorithms include the Apriori and FP-tree algorithms (for finding association rules), K-Means and Hierarchical clustering algorithms, GSP and PrefixSpan for Sequential Pattern Mining and various algorithms for Outlier Detection. In 2006, at the International Conference on Data Mining (ICDM), the top algorithms were discussed (see http://www.cs.uvm.edu/~icdm/algorithms/index.shtml). This is a very limited list and many more algorithms have been and are being developed, as this area continues to grow and expand to encompass new problems and applications.

Dbms and rdbms?

A DBMS (Database Management System) is a software application that allows users to interact with a database. An RDBMS (Relational Database Management System) is a type of DBMS that organizes data into tables with rows and columns, and uses structured query language (SQL) for querying and managing data. RDBMSs are a subset of DBMSs, designed specifically for relational databases.

What is symbol table and in which part of the memory it is stored?

Symbol table is a file that Compilers / Assemblers use to store symbols and their equivalent relative memory locations, values, data types for the following steps. It's an intermediate file, so the compiler chooses where to store it. Some compilers delete the file after processing

What is difference between primary key and foreign key?

A primary key is an attribute (or combination of attributes) that uniquely identifies each row in a relation. A primary key is designated by underlining the attribute name. The primary key of an entity set allows us to distinguish among the various entities of the set. A foreign key is an attribute in a relation of database that serves as the primary key of another relation in the same database.

What is the difference between sequel and SQL?

The definition of the word Sequel is "that which follows in consequence of what has previously happened" Ie. The Godfather 2 was the sequel to The Godfather.

SQL on the other hand, was originally an acronym for Structured Query Language. SQL is a standard interactive and programming language for getting information from and updating a database.

SQL (correctly pronounced "ess cue ell,") is in slang referred to as "Sequel" as a method of pronouncing the 3 letter acronym. The 'sequel' pronunciation is a carryover from when there was actually a SEQUEL language.

What is the difference between rdbms and ordbms?

Relational Database Management System. A type of DBMS in which the database is organized and accessed according to the relationships between data values. The RDBMS was invented by a team lead by Dr. Edmund F. Codd and funded by IBM in the early 1970's. The Relational Model is based on the principles of relational algebra. Example RDBMS Systems: Oracle, SQL Server, DB2, Sybase, etc. ODBMS Object-oriented Database Management System. A special type of DBMS where data is stored in objects using object oriented techniques eg: IRIS,Orion,O2. If you find the info useful. Please vote!!!

A query language for relational databases?

SQL (Structured Query Language) is a standard language used to communicate with and manipulate relational databases. It allows users to retrieve, insert, update, and delete data from databases using specific syntax and commands. SQL is used widely by database administrators, developers, and data analysts for managing and querying relational databases efficiently.

What is the Existential and relational processes in Language analysis?

Existential processes in language analysis involve expressing existence or presence. Relational processes involve describing relationships between entities or linking them to one another. Both processes are important in interpreting and understanding the meaning conveyed in a sentence or text.

How do you type in different languages?

To type in different languages, you can enable a language keyboard on your device's settings. This allows you to switch between keyboards for various languages by pressing a key or using a keyboard shortcut. Additionally, you can use virtual keyboards or input methods to type in different languages without changing your physical keyboard.

What etchnicity lastname is saullo?

The surname Saullo is of Italian origin. It is a fairly common surname in Italy, particularly in the southern regions.

How do kids use gender schema to organize their perception and words?

Kids use gender schema to organize their perception and words by categorizing information based on stereotypes about gender roles. This can influence their beliefs about what is appropriate or expected behavior for boys and girls. They may also use gender schema to interpret and make sense of the world around them, shaping their understanding of gender identity and relationships.

In an RDBMS generic applications access data by issuing commands written in which language?

SQL (Structured Query Language) is the language used to interact with relational database management systems (RDBMS) to access and manipulate data. It is a standard language for managing databases and executing queries to retrieve information.

Can you draw a morphological tree diagram for morphology?

A morphological tree diagram is a graphical representation of how words are formed from smaller units (morphemes). It consists of a root, affixes, and inflections in a hierarchical structure to show the relationships between these morphological elements. It helps visualize how words are built, showing the order of affixation and the resulting word forms.

Why are push polls criticized by responsible scientific pollsters?

Typically a push poll is not designed to merely collect information from those polled but instead to attempt modifying the outlook of those polled or at least increase the probability of obtaining a desired response. As such, the way the poll is present inherently displays a bias and in all likelihood skews the results. For example, if a poll stated "Do you consider yourself a vegetarian or vegan?", the results would probably be far more accurate than if presented by "Do you eat foods that require animals be slaughtered?"

What are data retrieval language commands?

Data retrieval language commands are used to retrieve specific data from databases. Common commands include SELECT (to retrieve data), WHERE (to set conditions for the retrieval), ORDER BY (to sort the retrieved data), and JOIN (to combine data from multiple tables).

Is it true that third normal form removes transient dependencies?

Yes, third normal form (3NF) eliminates transitive dependencies by requiring that all non-prime attributes in a table must be determined by the primary key. This helps in reducing data redundancy and improving data integrity.

What is relational rule?

Relational rules refer to the tendency of people in relationship to "develop rules unique to a specific interaction situation and to repeat them until they become reflected in patterns of behavior" (Yerby & Buerkel-Rothfuss, 1982, p.3, cited in Brommel, Bylund & Galvin,2008) Reference: Brommel, B. J., Bylund, C. L., & Galvin, K. M. (2008). Family communication: Cohesion and change (7th ed). USA: Pearson Education.)

What are some advantages of an age-set system?

An age-set system can foster social cohesion and a sense of identity among members of the same age cohort. It also promotes solidarity, cooperation, and mutual support among individuals within the age-set. Additionally, it can serve as a mechanism for sharing knowledge, traditions, and cultural practices across generations.

Disadvantage of procedure oriented language?

One disadvantage of procedure-oriented languages is that they can make codebase maintenance and modification difficult, as changes to one part of a program may require alterations in multiple procedures. Additionally, reusability and scalability may be limited compared to object-oriented languages. Finally, procedures can lack encapsulation, leading to potential security vulnerabilities.

What are the advantages of proportional representation system?

Proportional representation promotes fair representation by translating votes into seats proportionately. It allows for greater diversity in political parties and viewpoints to be represented in government. It can also minimize wasted votes and reduce the likelihood of a party winning a majority with a minority of the popular vote.

What are the advantages and disadvantages of limited and unlimited political system?

Advantages of a limited political system include stability and consistency in governance, protection of individual rights and freedoms, and prevention of authoritarian rule. Disadvantages may include constraints on government action and responsiveness to changing circumstances.

Advantages of an unlimited political system may include flexibility and adaptability to evolving challenges, empowerment of the government to take bold actions, and potential for rapid decision-making. Disadvantages may include a greater risk of abuse of power, erosion of checks and balances, and potential for oppression of minority rights.

What does Frederick attribute the kindness of mrs. auld?

Frederick Douglass attributes the kindness of Mrs. Auld to her nature as a naturally kind person, unaffected by the corrupting influence of slavery when she first met him. He describes her initial treatment of him as compassionate and genuine before she began to conform to the racial attitudes prevalent at the time.