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

Examples of open system?

An Open System is a computing platform that uses Open Source softwares rather than Closed Source/Proprietary softwares.

Closed source software may charge for their software, but might not.

If a development firm releases software for free, but does not release the source code to the public, this is called "Freeware."

Proprietary software generally does not distribute their software for free, and it follows that the owners do not distribute the source code either.

An few examples of proprietary software are Microsoft Windows (Operating system), Microsoft Office (Office Software Suite), Nero (CD/DVD Burning Software), and WinRAR (Archiving Tool).

The point of an Open System is to break away from the use of software that you have to pay for. Some people also go a step further and refuse to use software that the owners do not release the source code of.

This principle is especially useful in business, where a company can save a lot of money making their employees use Free and Open Source software rather than paying licensing fees to use one product on multiple machines.

A few examples of Free and Open Source softwares that do the same job as the Proprietary softwares cites above are:

Debian Linux (Operating System), Open Office (Office Software Suite), K3b (CD/DVD Buring Software), PeaZip (Archiving Tool).

Are there software that can manage Stock in a shop?

There are lots of options depending on how complex you want to get. One is Microsoft Retail management System which can connect multiple stores together. The key parts to a system are the inventory management, point of sale (POS) which interfaces with the inventory database and handles customer transactions and a module to connect with credit card payment vendors. Other important functions involve order processing, transfers of stock, reports and some have built in accounting modules.

What are the advantages of database management system?

management is a system of authority. infact management won't exist without proper and appropriate authority.Authority is power to get the work done by others and compel them to work systematically.Management cannot perform in absence of authority.Authority and responsibility generally depends upon the position of the managers ( viz. general manager , sales manager , departmental manager , finanace manager ) in the organization.

Which tags are used to add rows to your tables?

Inset Into your_table ( fileld1, field2,.....,fieldn) values (value1,value2,.....,value n)

What is the difference between sql and pl-sql?

  • Platform dependency-

The primary difference is with respect to platform dependency, SQL is basically limited to the Windows platform where as Oracle is operable on multiple platforms such as Windows, UNIX and Linux etc. This multi-platform compatibility of Oracle makes it a universal enterprise solution, which makes it mandatory for the Oracle DBA to be acquainted with the different platforms where as the Sql DBA just needs to be familiar with the windows platform..

  • Clustering technology-

Oracle is significantly ahead of its opponent when it comes to clustering technology, Oracle makes use of RAC technology which enables two instances to act on the same data in active-active configurations.

  • Locking and concurrency -

Oracle had a multi-version consistency model which means that "readers don't block writers and writers don't block readers." Sql on the other hand has a very simple locking mechanism which follows the rule that "writers block readers and readers block writers."

  • File system-

Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database.

  • Replication -

SQL Server provides a far more simple and flexible system for replication and synchronizing of data when compared to Oracle, it involves a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.

  • Administration-

SQL server GUI is simple and easy to work with where as the Oracle server is not very user friendly as most of it command line is based.

by....... Sankar

Three main types of database applications and briefly explain them with suitable example?

A collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications:

  • computerized library systems
  • automated teller machines
  • flight reservation systems
  • computerized parts inventory systems

From a technical standpoint, DBMSs can differ widely. The terms relational, network, flat, and hierarchical all refer to the way a DBMS organizes information internally. The internal organization can affect how quickly and flexibly you can extract information.

What is bytes of data?

I believe the question you are trying to ask is, "What are bytes" or "What is a byte." Simply put, a byte is a basic unit of measurement of information storage in computer science. The term "byte" comes from "bite," as in the smallest amount of data a computer could "bite" at once. The term byte was coined by Dr. Werner Buchholz in July 1956, during the early design phase for the IBM Stretch computer. Originally it was defined in instructions by a 4-bit byte-size field, allowing from one to sixteen bits. A fixed eight-bit byte size was later adopted and promulgated as a standard by the System/360.

Why some of computer programmers write virus?

There are hundreds of thousands of viruses out there (if not millions) and they often designed for different objectives. Most of them fall under the following categories:

*To take control of a computer and use it for specific tasks

*To generate money

*To steal sensitive information (credit card numbers, passwords, personal details, data etc.)

*To prove a point, to prove it can be done, to prove ones skill or for revenge purposes

*To cripple a computer or network By: Tasmanian Devil & Angel

Deactivate rediffmail account?

A rediffmail account is deactivated when it has not been used for 90 days. Once that has happened, any emails that were sent to the account will be permanently deleted.

Master reset code for samsung sgh-480v?

*2767*JAVA# Java Reset and (Deletes all Java Midlets)

*2767*MEDIA# Reset Media (Deletes All Sounds and Pics)

*2767*WAP# Wap Reset

*2767*CUST# Reset Custom EEPR0M

*2767*FULL# Reset Full EEPR0M (Caution)

For example : *2767*JAVA# would be keyed in as *2767*5282#

Note : Not all codes will work with SGH-C100

password

What does access fmm stand for?

ACCESS FMM stands for:

Aesthetics

Cost

Customer

Environment

Safety

Size

Function

Material

Manufacturing

Difference between dimensional modeling and ER modeling?

E-R modelling basically deals with Entities and their relationships to capture the overall process of the system. While Dimensional model/Muti-Dimensional Modelling deals with Dimensions (point of analysis) for decision making and not to capture the process.

Examples of applicaton software?

These are the computer software which can be run after the computer gets boot up. It is used for specific tasks like image processing,word processing,spreadsheet,etc. Some of the examples are

1) Adobe Photoshop

2) Microsoft Office package(MS Word,Access,Base,PowerPoint)

3) MS Paint

4) Notepad

5) Calculator

What are the responsibilities of database administrators and database designers?

It depends on the nature of the job. Supposing you are the database manager in cancer research, then you will have to organise the patient's data with respect to a particular treatment, say for example radiation treatment. It will be more like a retrospective study. Or your job might be to enter the data in tables, organise using Microsoft access or Excel and you may also have to perform simple data analysis. Your job might also include writing reports and contributing to publications etc. I guess the responsibilties are diverse and entail many areas. Hope this helps Thank you Good luck

Er diagram for hospital management system?

An ER diagram is an entity-relationship diagram they show individuals and their links to each other. An ER diagram for a hospital management system would be a flow chart showing hospital staff, equipment, patients, records and more.

Explaine different types of vouchers in Tally?

Vouchers types

  1. Payments
  2. Receipts
  3. Sales
  4. Purchases
  5. Journals
  6. Debit Notes
  7. Credit Notes
  8. Delivery Challans
  9. Goods Inward
  10. Goods Outward
  11. Stock Journals
  12. Physical Stock Vouchers
  13. Contras
  14. Memos
  15. Sales Orders
  16. Purchase Orders
  17. Rejection Notes
  18. Reversing Journal

Where are databases used mostly?

Databases are used to store data also providing modification & retrieval of data in an efficient manner. Databases is used everywhere like in Railways, Airports, Schools, Hospitals, Business , Shopping Malls etc. Database helps us to manage the data efficiently and in a easy manner.

What is an example of Raw Data is Converted into Information?

A list of date of births is raw data. If you looked through that list you could do things like find how many people were born in April or who is the oldest or who was born between the 10th and 20th of the month and so on. All of those things are information that can be got from the data. All that you can see is a list of dates of births. Nowhere in that list does it explicity say something like "There were 14 people born in April", but you could find that information by looking through the data. So data can be used to get information.

What software do you need in order to view a webpage?

A web browser (Internet Explorer, Firefox, Safari, Opera, etc...) is the most commonly used application for viewing web pages. However, offline viewers for HTML pages that you have previously downloaded or created are also available.

How does a computer convert data into information?

A computer performs certain operations on the data. Suppose we give any input to the computer . The computer then process the data . Finally it gives the information to us as an output that is nothing but the processed data.

What is the importance of querying a database?

A query can be used to do things with the data. Mostly it is to extract information from the database, but they can also be used to delete, edit and update a database. Queries are very important and powerful aspect of a database.