0
Database Design
Database design is the process of creating a detailed data model of a database. It is the next step after requirement gathering and before coding begins. A good database design can save a lot of time during the database development.
1,295 Questions
Availability can make security more difficult.
What are the 8 basic data types used in java?
You should find the answer you're looking for here
http://softpixel.com/~cwright/programming/datatypes.java.php
Design of enzyme electrode and their application?
THIS IS AN OVERVIEW OF ENZYME ELECTRODE:-
An enzyme electrode is the union of an enzyme, that biologic catalyst which acts sensitively and specifically with almost all organic and inorganic compounds in nature, with an
electronic sensor (an ion-selective electrode). The result is
an electrode that is useful for the assay of organic and inorganic compounds, in a manner as simple as a pH measurement with a glass electrode.
The principle of the enzyme electrode is simple: an enzyme is used which reacts with the compound to be assayed
either specifically or selectively. This enzyme, in an immobilized or insolubilized form, is placed onto a conventional ionselective electrode which measures either the decrease of one
of the reactants (i.e., O2 in the oxidation of uric acid or glucose) or a product (i.e., CO2 from an amino acid). The substance to be assayed diffuses into the layer of the enzyme in
the electrode, producing or consuming an electroactive substance; this is sensed by the base electrode. The potential or
current produced is a function of the concentration of the
substance assayed.
commercially available (or homemade) electrodes
have been used and can be used in construction of enzyme
electrodes: (1) glass electrodes-H+
and monovalent cation;
(2) gas-NH3, CO2)
and O2; (3) solid and "solid" liquid
membrane electrodes-NH4
, S~, CN~, and I"; and (4) Pt
electrodes.
Two basic techniques may be used in assay with enzyme
electrodes, kinetic and equilibrium. In the kinetic method,
the rate of change in the potential or current at the electrode
is measured, with the first 10-30 sec of response. This
change, AE or Ai/At, is then related to the content of substance to be assayed. In the equilibrium method, the steadystate current or potential, i or E, is measured and related to
the concentration. This relationship is logarithmic in the
case of potential (E) and linear in the case of current (i). The
rate method is faster and eliminates the possibility of error
due to side reactions that may consume the electroactive
substance.
Ans By-
MUSHARRAF ALI
CET-IILM-AHL
Gr. Noida
What is the difference between select into and createview command?
The SELECT INTO command creates a new table with data from an existing table whereas the CREATE VIEW command creates a view i.e., a virtual table from an existing table.
Entity-relationship diagram of banking system?
Search google for a "er diagram of a bank" and look at images , lots of great examples.
Why do you need computerized decision support system?
A decision support system (DSS) is a computer-based information system that supports business or organizational decision-making activities. DSSs serve the management, operations, and planning levels of an organization and help to make decisions, which may be rapidly changing and not easily specified in advance.
- Improves personal efficiency
- Speed up the process of decision making
- Increases organizational control
- Encourages exploration and discovery on the part of the decision maker
- Speeds up problem solving in an organization
- Facilitates interpersonal communication
- Promotes learning or training
- Generates new evidence in support of a decision
- Creates a competitive advantage over competition
- Reveals new approaches to thinking about the problem space
- Helps automate managerial processes
What is an example of flat file database?
A spreadsheet is one example. All the data is in a single table.
Number to words in Indian format in crystal report?
numbervar RmVal:=0;
numbervar Amt:=0;
numbervar pAmt:=0;
stringvar InWords :="Rupees ";
Amt := numeric value ;
if Amt > 10000000 then RmVal := truncate(Amt/10000000);
if Amt = 10000000 then RmVal := 1;
if RmVal = 1 then
InWords := InWords + " " + towords(RmVal,0) + " crore"
else
if RmVal > 1 then InWords := InWords + " " + towords(RmVal,0) + " crores";
Amt := Amt - Rmval * 10000000;
if Amt > 100000 then RmVal := truncate(Amt/100000);
if Amt = 100000 then RmVal := 1;
if Amt 1 then
InWords := InWords + " " + towords(RmVal,0) + " lakhs";
Amt := Amt - Rmval * 100000;
if Amt > 0 then InWords := InWords + " " + towords(truncate(Amt),0);
pAmt := (Amt - truncate(Amt)) * 100;
if pAmt > 0 then
InWords := InWords + " and " + towords(pAmt,0) + " paisa only"
else
InWords := InWords + " only";
UPPERCASE(InWords)
What is difference between object and entity?
A database object is represented as one of the following:
database, schema, table, column, primary key, and foreign key
A database Entity is:
An entity is a thing or object of importance about which data must be captured.
All things aren't entities - only those about which information should be captured.
Information about an entity is captured in the form of attributes and/or relationships. If something is a candidate for being an entity and it has no attributes or relationships, it isn't an entity.
Database entities appear in a data model as a box with a title. The title is the name of the entity.
Maximum length of a varchar field in SQL Server?
12,500 is the maximum length of a varchar field. The nVarchar field has the same limitation however you will use twice the data store space with an nVarchar as it is effectively the same as a varchar with the exception that it will store data required for international character sets. If you support a multi-language system then you will want to use a nVarchar character type for these fields.
What are three anomalies that are likely result to data redundancy?
The three types of anomalies likely to show up are: Insertion, Deletion, and Update anomalies.
Types of normalisation with table example?
Types of normalisation
- First Normal Form
- Second Normal Form
- Third Normal Form
- BCNF
Maths
Data conversion and loading in database?
By data conversion we mean the data is first processed. The data after processing is ready to store in database. And from the database we can retrieve it for our use.
Why the data dictionary is called the database designer's database?
1- Because it records the design decisions about tables and their structures…
2-
Why 3NF is preferred in database design?
Engineer requirements should be higher, on the application of large databases to achieve proficiency or proficiency level, so the relatively low level of development engineers database, the cost is lower. Data architects, general business needs one or two. Of employment database development engineer is the most extensive. Here are some cases for reference only. (Www.myelibrary.net)
What is operation of database system?
Operational database management systems (also referred to as OLTP On Line Transaction Processing databases), are used to manage dynamic data in real-time. These types of databases allow you to do more than simply view archived data. Operational databases allow you to modify that data (add, change or delete data), doing it in real-time. vlurn.com/course/oracle-sql-developer-training/
What is meant by binary valued quantities?
Binary-valued quantities can be 0 or 1, true or false, right or wrong. There are only 2 possible values.
What are the Different types of relationship in a database?
There are mainly three types of relationships in database . These are One to One , One to Many , Many to Many. One to one relationship can be seen as relationship between husband and wife , one to many relationship can be seen as a relationship between a college and students.
Why do you need common fields in a database?
A common field is a field of data that is shared among all forms in a database. Without them, it would be difficult and/or time-consuming to create other forms.
DO you have redundancy of records in distributed DBMS?
Redundancy means duplicacy of data or repetitive data. In distributed database case the data is stored in different systems . So the answers is yes there can be redundancy of records / data.
In distributed database , data is stored in different systems. Since the data is distributed there is redundancy of records.
What is mean by type constraint in DBMS?
A foreign key is a type of constraint. In this example the value in a field must be the same as some value in a defined field in another table.
Example in a Customer Table you might have a Column (field) named StatusID
You would define a foreign key to the table Status, field StatusID.
The value in the Customer table, StatusID column must be an entry existing in the Status Table, StatusID column.
There are many constraints. The fact that a column can not be NULL (Left blank) is a constraint. Defining what KIND of data, or range of data that can be entered in a column is a constraint.
