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.

500 Questions

If you log into your own blog does Google analytics count that as a visit?

User Avatar

Asked by Wiki User

yes dear the google do analytics count that as a visit get it.

Can the FirstName column be a primary key?

User Avatar

Asked by Wiki User

Yes, the FirstName column can be a primary key as long as it satisfies the requirements of a primary key, which include being unique and not null. However, it is generally not recommended to use a person's first name as a primary key as it may not be unique and could lead to data integrity issues.

Why is database normalisation necessary?

User Avatar

Asked by Wiki User

Database normalization is necessary to eliminate data redundancy and ensure data integrity and consistency. By organizing data into multiple related tables and reducing duplication, normalization helps to save storage space and improve the efficiency of data retrieval and update operations. It also prevents anomalies, such as update anomalies and insertion anomalies, by ensuring that each piece of data is stored in only one place.

What is a structural independence?

User Avatar

Asked by Wiki User

Structural independence refers to a situation where two or more components or elements within a system are not dependent on each other for their functioning or operation. In other words, changes or failures in one component do not directly affect or impact the functioning of other components. This characteristic ensures that the system remains stable and resilient even when certain components are altered or fail.

What are the examples of fields in a database?

User Avatar

Asked by Wiki User

You could have a text field called Name. You could have a date field called Date of Birth.

Which database is closest to the user?

User Avatar

Asked by Wiki User

sql server database is more reliable and user friendly and easy to handle. As a member of hosting provider of mywindowshosting.com I used this database for my project since one year.

What if you delete a database table?

User Avatar

Asked by Wiki User

click undo to restore the table

How much does it cost to create a database project?

User Avatar

Asked by Wiki User

The cost of creating database base project will nearly cost you approximately $600.

Or you can charge an hourly rate. Or, you can figure out what hourly rate you would charge, estimate the time required, and charge a set fee based on that math.

What data validation can be used in a database?

User Avatar

Asked by Wiki User

A database is only as useful as the data it contains. Validation helps prevent invalid or inconsistent data from getting stored. At the most elementary level, it could be as simple are requiring a given element to only contain numerical data. More complex validation rules might entail a list of valid values, cross-field edits (if field A contains "xyz", then field B cannot contain "abc") and various more complex rules known as constraints (such as foreign key and NOT NULL rules.)

What are the objectives in enrollment system?

User Avatar

Asked by Wiki User

An enrollment system automated system in place by a college or school that allows the user to enroll in classes. The purpose of the system is to make the process easier for the student and the school.

How does the process of decantation work?

User Avatar

Asked by Wiki User

The process of decantation works by allowing solids to settle at the bottom of the mixture. This is a process that is used to separate mixtures.

Why is NaCl not called ClNa?

User Avatar

Asked by Wiki User

This is a conventional system, the most used today; but for data bases is used the old Hill system where the formula is writed ClNa.

Why would a form be used in a database?

User Avatar

Asked by Wiki User

Forms are very crucial in daily life, it helps us to fill the details of particular matter and it is also an evidence.

What is the use of null in database?

User Avatar

Asked by Wiki User

Sometimes, a particular field in a database row has a value that is either unknown or undefined. An example might be the termination date of an employee who is still employed by the company. A date field would not accept any value that was not a valid date but no date has been determined for the field as yet. A null would indicate that.

What is in-house software development vs. outsourced packaged sofware?

User Avatar

Asked by Wiki User

In-House development means that a company has programmers on its staff and develops software internally. Outsourced development is when a company hires a firm to develop a custom applicaation Packaged software is what you purchase when you goto a store and purchase software off-the-shelf.

What is the meaning of MS-DOS?

User Avatar

Asked by Wiki User

MS-DOS is an operating system designed for the IBM PC by Microsoft in 1981. MS DOS is Microsoft Disk Operating System. It was a command-line interface, meaning the user had to type in commands to use it, unlike Windows which is a Graphical User Interface. MS DOS was released on IBM PCs when they came out in the 1980s and continued in popular use until the mid 1990s, by which time the first of the Windows operating systems, Windows 95, began to take over.

MS DOS commands were either stored as individual programs, known as external commands, or in a file called Command.com, which stored more commonly used commands. These were called internal commands. Included in these would have been commands like COPY, DEL, DIR, CD and RD.

COPY enabled the copying of files.

DEL deleted files.

DIR gave a listing of files in a directory (now called a folder).

CD changed from one directory to another.

RD removed a directory.

How do you design a database management system for stock exchange?

User Avatar

Asked by Wiki User

You would need at the very least 3 tables.

1. TblCompany

Assign them a unique ID.

Ticker (Symbol)

CompanyName

Industry

Sector

2. tblDate

OpenedStockDays

...

...

3. TransactionTable

Ticker

OpenedStockDays

Open

High

Low

Close

Volume

make sure to link them properly and to always set a primary key for each table.

What is the purpose of shunt reactor?

User Avatar

Asked by Wiki User

Shunt reactor are generally employed at the end of long transmission line. During charging of line due to ferranti effect receiving end voltage increases dangerously to control this shunt reactors are used.

Will hardsextube.com give you a virus?

User Avatar

Asked by Wiki User

No, according to this webpage:

http://safeweb.norton.com/report/show?url=hardsextube.com

Advantages and disadvantages of object oriented?

User Avatar

Asked by Wiki User

Not too much if you are a one man/very small shop. Any kind of organized programming method works in this environment if you are competent in the language(s) you are using and have a good knowlege of the business/science side of the project. You have to understand the subject before you can write the code...

For large shops (more than 5 people), it is an effective way to design/specify projects so that:

1) Components (programs, data types, etc.) can be defined consistently.

2) Programmers and Project Managers can actually communicate and understand each other. (this should probable 1 instead of 2).

3) Partially complete modules/programs/whatever can be passed to another person when necessary. (With some expectations of getting it done without a complete rewrite).

4) The project estimates can be a bit more accurate when somebody asks how far along something is. (Management only has to double their estimates instead of quadrupling them.)

Note: Every 3 to 5 years, another development method is born - always better than the last one. In my opinion, OOSDLC is just another attempt to tame the wild, barely manageable programmer. No better and no worse than the old Modular Programming philosophy for Assembler 360.

What is a general-purpose software?

User Avatar

Asked by Wiki User

It is a general piece of software that anyone could use, such as a word processor or spreadsheet etc. You can go into a shop and buy it. The developers would make lots of copies and sell it as all sorts of people would want it. You also have specialist software which may be written for a specific group of people or a specific company or individual and which would be no use to anyone else. Only one or a few copies might be made as it is for a very specific client.

Does a database have to be computerized?

User Avatar

Asked by Wiki User

No. A database can be manual, like a phone book or a shopping list. For it to be a database it needs to be structured or organised. If you take a phone book, although there are thousands of names in it, you can usually find a phone number you are looking for very quickly. This is because the phone book is structured and organised. So it does not have to be on a computer to be a database. A manual database can be computerised. The data would be entered into a computer.