Database Programming

No, Delete queries are ran before the queries which adds the data to history table. This is to avoid duplicacy.

Foreign dependency is when a country relies on another country, for example for money, jobs, food etc.

Round robin play involves each entry playing all other entries. For example if you have 4 teams entered, each team plays all the other teams or 3 games each for a total of 12 games played.

If you have larger number of teams, split them up into pools. Ie. 12 teams 3 pools of 4 each team playing 3 games. You then can take the top 2 best records from each pool and put them into a championship pool so you would have 6 teams playing 5 games each and the eventual winner would be team with best record.

No, it can in fact be stored in a file outside of a computer...what boff wants to know that!?

if the computer crashes you can't use it.

A database is a collection of data. It should be integrated , consistent , non- redundant , durable and atomic in nature.

holidays!

-Jersey

-Mama Rush

-Todd

-Leza

draw an er diagram on attendance management system

the compexity of linear search in worst case is f(n) = n+1

Keyed and sequential refer to two different methods of data access in computing. Keyed access allows data to be retrieved using a specific identifier or key, enabling direct access to a particular record. In contrast, sequential access requires reading through data in a specific order, typically from the beginning to the end, making it less efficient for finding specific records. Keyed access is often used in databases, while sequential access is common in file systems and data streams.

it was the first method used to store data in a computerized database here each field or dataitem is stored in a disk sequencily in one large file.

art by mvs

1. Abstraction : model is described using universal principles and properties- reusable across situations, hides complexity.

2. Transparency : close representation to real world-intuitively clear and understandable from any point of view.

3. Effectiveness : readily translated into actual information systems that are durable, reliable, and extensible.

The insert problem by denormalized design is caused because all records must have a primary key set before it can be stored.

We designate one of the candidate key of a relation to be a primary key because that primary key is use for any foreign key references.

to implement operations on binary heap in c

Following are the roles of a DBA.

1) Secures data

2) Configures and maintains user profile

3) Assigns previleges for access

4) Maintain database statistics and plans expansions in hardware and software

5) Continuous system development

A database trigger is an action that the database management software will perform automatically when a preset list of conditions are met. Different database vendors have different mechanisms in place for the declaration of triggers, but the principles remain the same.

data dictionary

procedure- to tell what you did step by step for your project

A mathematical technique for dealing with imprecise data and problems that have many solutions rather than one. Although it is implemented in digital computers which ultimately make only yes-no decisions, fuzzy logic works with ranges of values, solving problems in a way that more resembles human logic. Fuzzy logic is used for solving problems with expert systems and real-time systems that must react to an imperfect environment of highly variable, volatile or unpredictable conditions. It "smoothes the edges" so to speak, circumventing abrupt changes in operation that could result from relying on traditional either-or and all-or-nothing logic.

Relational set operators in dbms uses algebra to manipulates contents in a data base. there are many different operation in Dbms ,they are :-

1.Union

2.intersect

3.Product

4.select

5.Project

6.divide

what are the advantages of line management?

I think the difference is that RMI uses AAAAAA and the procedure uses BBBB