answersLogoWhite

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

What is the data schema in a database?

Logical Structure of database is know as database schema. All database entities are defined and relation between then is represented in structured way. It includes all constraints to be apply on each identity.

Er diagram of online railway reservation system?

try www.wikipedia.com which will help you for making ER - Diagram ....

and copy past given link below in your browser for detailed description about ER - Diagram :

http://www.infocom.cqu.edu.au/Courses/spr2000/95169/Extra_Examples/ERD.htm

What is a semi-custom ASIC?

Semi-custom ASICs is a classification of ASICs that are are customized in only one or two areas.

What is fuzzy clip?

it is when you eat out a girl when they are on their period while someone is bum screwing them at the same time while crapping on her chest and she licks it up and kisses you

Can a having clause and a where clause be used together in a SQL query?

Yes, you can use a having clause and a where clause together in an SQL query. select emp_dept, sum(value) total_value, count(1) sales

from all_sales

where emp_dept in ('fashions','stereos','cosmetics')

group by emp_dept

having sum(value) > 125000

What is mm4.inphomatch?

Headquartered in Chantilly, Virginia, InphoMatch is the leading provider of mobile messaging services and global messaging interoperability. The company delivers messages, premium content, and value-added services for global mobile carriers, content providers, mobile marketing partners, and entertainment companies. InphoMatch's carrier-grade, private IP network spans four major regions -- North America, Latin America, Asia and Europe. Major carrier customers include AT&T Wireless, Dobson Communications, Leap Wireless, T-Mobile, Telefonica, Verizon Wireless and Vodafone. More information about the company can be found at www.inphomatch.com.

What is the algorithm and flowchart for finding the prime numbers between 1 and 20?

The algorithm is fairly straightforward. For any integer i greater than or equal to zero:

  1. i is non-prime if i is less than 2.
  2. otherwise, i is prime if i is 2.
  3. otherwise, i is non-prime if i is greater than 2 but is divisible by 2.
  4. otherwise, i is non-prime if it has any prime factors less than or equal to its square root.
  5. otherwise, i is prime.

Step 4 is easier to implement by testing all odd divisors from 3 to the square root of i.

What is Sand-Box-Testing?

Sandbox testing is basically the ability to submit and process transactions, data, ect within an application that is not in a 'live' state. These transactions are not ONLINE, or real so they have no effect. Basically this is a TESTING mode, training mode for an application. Usually used in a development cycle.

What is the best description of a database management system?

Database Management System is a software package with computer programs that control the creation, maintenance, and the use of a database. It allows organizations to conveniently develop databases for various applications by database administrators and other specialists. A database is an integrated collection of data records, files, and other database objects. A DBMS allows different user application programs to concurrently access the same database.

Does standard SQL allow built in functions to be used in a WHERE clause?

Yes.

Example: Select `Id`,`Name` From `Order` Where `OrderDate` = CURDATE() And `IsShipped` = False

What is general purpose software?

it is a big juicy mongy apple pie from mcdonalds

Well the answer that the person left above to me was STUPID but anyways general purpose software is like a software you use at home or school like a word processor or spreadsheets and stuff like that.

What is an example of a open system?

Open systems refer to systems that interact with other systems or the outside environment

Open-systems theory originated in the natural sciences and subsequently spread to fields as diverse as computer science, ecology, engineering, management, and psychotherapy. In contrast to closed-systems, the open-system perspective views an organization as an entity that takes inputs from the environment, transforms them, and releases them as outputs in tandem with reciprocal effects on the organization itself along with the environment in which the organization operates. That is, the organization becomes part and parcel of the environment in which it is situated. Returning for a moment to the example of biological systems as open-systems, billions of individual cells in the human body, themselves composed of thousands of individual parts and processes, are essential for the viability of the larger body in which they are a part. In turn, "macro-level" processes such as eating and breathing make the survival of individual cells contingent on these larger processes. In much the same way, open-systems of organizations accept that organizations are contingent on their environments and these environments are also contingent on organizations.

POSIX is an example of open systems.

When computer users a document they change its appearance?

In computer using software like ms word we can format a document. After formatting ,the document will appear different . Thus formatting changes the appearance of a document.

When users FORMAT a document they can change its appearance.

How databases generate sales or profits?

In database each row have some fields or attributes . In a shop database there is a field for sales and using the data of sales field, profit can be calculated.

What two conditions must be met before an entity can be classified as a weak entity?

In contrast to the strong or regular entity, a weak entity is one that meets two conditions:

1. The entity is existence-dependent; that is, it cannot exist without the entity with which it has a relationship.

2. The entity has a primary key that is partially or totally derived from the parent entity in the relationship.

When would you use division in real life?

You and your 4 friends rent a beach house for spring break. At the end of the week, your total bill comes to $2800. You all decide to split the cost equally. How much does each person pay?

You drove 475 miles on 18 gallons of gas. What is your fuel economy (mpg)

Those are 2 of many scenarios where you would need division. Most people use calculators nowadays anyway and there are few "life or death" situations where you would need to learn division, but it's something you shouldn't take for granted. Every piece of technology that you use relies on mathematics at some level whether it be on the research level, the design level, or the manufacturing level and on.

Difference between dataflow diagram and sequence diagram?

The purpose of a data flow diagram is to show you how the data flows through an information system. A sequence diagram shows you information regarding how the processes work together and in what order they operate.

What is a non numeric character?

Any character except numbers. So letters, punctuation symbols etc. are non-numeric.

Differentiate manual database to a computerized database?

A manual database is a paper based database. A computerized database is one which is held on a computer in an organised manner. A computerized database is more advantageous than manual database in terms of speed, flexibility, and ease.

A manual database would normally be data held on paper. So this could be things like a phone book or address book, or files held in a filing cabinet. A computerised database is held on a computer in an organised and structured form. Usually this is done using a database application such as Oracle or Access etc. It is easy to manipulate and extract data, so far more efficient than a manual database.

What is difference between interquery parallelism and intraquery parallelism.Explain with an example?

Inter-query parallelism results from the ability to execute multiple queries at the same time while intra-query parallelism is achieved by breaking up a single query into a number of subqueries each of which is executed at a different site, accessing a different part of the distributed database.

If the user access to the distributed database consisted only of querying (i.e.,

read-only access), then provision of inter-query and intra-query parallelism would

imply that as much of the database as possible should be replicated. However, since most database accesses are not read-only, the mixing of read and update operations requires the implementation of elaborate concurrency control and commit protocols.

What are the example of clamping and holding tools?

bench voice, voice grip, g clamp, c clamp, hand clamp, jumper cable.

these are only hand tools

What is an important step to take before entering your first data into you database?

First you must make a reasonable effort to make sure that your database is structured correctly.