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

Why does every interaction diagram need a written description?

Diagrams need written descriptions to inform viewers of each interaction on the diagram. It explains to the reason for the diagram and what each section represents.

Is a primary key only one field?

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

Usually it is, but it can be a combination of two or more fields. In those situations it is referred to as a composite primary key.

How can you write the text on progress bar?

Writing text on a progress bar depends on the programming language you are using and whether you have access to the source code of the progress bar widget.

What factors should you consider when deciding how often to back up a database?

How often it changes, your ability to reconstruct data in case of a casualty, the cost of backups vs. rebuilding the data and the overall importance of the data.

Who designs a database?

A database or systems designer will do it. They could also have other roles like being an analyst or a database administrator. Whoever is designing a database may work with people in some of those other jobs, particularly when it is a very large system. If it is a small database, then it is easy to design and somebody with a bit of knowledge of databases can design and create one.

What are benefits of data warehouse?

One of the biggest benefits is that you can archive your data to a data warehouse. This can keep your main "production" database smaller which can provide some performance benefits. Also you can use the data warehouse to run complex queries and data-mining without adverse effects on the performance of your "production" application.

Can I use 4026ic insted of 4033ic in same circuit?

It depends on the circuit design, and on the intended use. The 4033 is the same as the 4026, except that it has a ripple blank feature that allows leading zero blanking, while the 4026 has a similar (but subtly different) display blanking feature.

What functionality does a database provide?

There are a number of functionalities that a database provides. Some of the functionalities that database provide are : security of data, reduced redundancy also ease of accessing data.

What is MSDAORA?

msdaora.dll. What is it? The msdaora.dll is a Microsoft Data Access - OLE DB Provider for Oracle. Sometimes it's called OLE DB Provider for Oracle. This file is part of Microsoft® Windows® Operating System. Msdaora.dll is developed by Microsoft Corporation. It's a system and hidden file. Msdaora.dll is usually located in the %PROGRAM_FILES_COMMON% sub-folder and its usual size is 233,472 bytes. Recommendation The msdaora.dll process is safe and disabling it can be dangerous, because programs on your computer need it to work correctly.

What is the meaning of concurent access?

Concurrent access in databases means two or more sessions accessing the database at the same time. Note that a session does not necessarily mean a user is physically infront of a terminal, it could also mean two or more processes accessing the database.

Can you use the program photoscape even without internet connection?

Of course you can as long as the program is installed on you hard drive, you just obviously will not be able to upload photos.

How could you alter the format of employee id numbers to make them difficult to guess?

If the employee number is a numeric field, you could randomly generate a number in a range and use it as a replacement for the original number. Keep in mind though that if the employee number is a primary key, you must generate unique replacements and that gets tricky. If the idea is to protect identity, you may want to look at masking other attributes like first name, last name, address, email, phone number, etc., By masking many attributes you make it harder for anyone to know the original identity.

What do you mean by Infer implicit relationships across data?

I think this type of inference is by looking at the data, i.e., there is no real relationship between the tables (through Primary and Foreign keys), but when you analyze the data in a table you are able to infer that there is a relationship.

What house hold equipment can you use to spy on your parents?

You could always put a cup to the door and listen hard to their private conversations

What is secondary sorting?

If you sort on two things, the second one is secondary sorting. This is done when after sorting some values are equal and need a further element to sort them. A classic example is sorting names. In a phone book, names are listed in surname order, and within each surname people are then listed in first name order. The surname is the primary sort and the first name is the secondary sort.

WHERE statement is used to define a filter expression?

Yes. For example, using a database containing a table clients:

SELECT clients.Name

FROM clients

WHERE clients.city='New York'

would show ONLY the clients from New York

What is origin country of Intel?

Intel is an American company founded in 1968 at Santa Clara in California. You can find more details on the history of Intel in their website.

What is integrity and its types?

Integrity

Database integrity means the correctness and consistency of data. It is another form of database protection. Security means that the data must be protected from unauthorized operations.

Integrity is related to the quality of data. Integrity is maintained with the help of integrity constraints. These constraints are the rules that are designed to keep data consistent and correct. They act like acheck on the incoming data. It is very important that a database maintains the quality of the data stored in it.DBMS provides several mechanisms to enforce integrity of the data.

Types of Integrity

Two types of data integrity are as follows:

Entity Integrity

The entity integrity is a constraint on primary key value. It states that any attribute of a primary keycannot contain null value. If primary key contains null value, it is not possible to uniquely identify a record in a relation. Entity integrity ensures that it should be easy to identify each entity in the database.

Referential Integrity

The referential integrity is a constraint on foreign key value. It states that if a foreign key exists in a relation, the foreign key value match the primary key value of some tuple in its parent relation. Otherwise the foreign key value must be completely null.