What is the use of null in database?
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?
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?
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?
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?
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?
No, according to this webpage:
http://safeweb.norton.com/report/show?url=hardsextube.com
Advantages and disadvantages of object oriented?
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?
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?
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.
Which utility keeps track of where your documents spreadsheets and presentations reside?
File management is the utility that keeps track of where your documents, spreadsheets, and presentation are located. It also displays other files that are on your computer like pictures.
What is difference between data integrity and data security?
Data integrity = making sure the data is correct and not corrupt
Data security = making sure only the people who should have access to the data are the only ones who can access the data. also, keeping straight who can read the data and who can write data.
What is input mask in a database?
An input mask refers to controlling the input that a user is going to provide.
For example, if you were going to ask for a person's phone number, and you know the format of the phone number is going to be (xxx) xxx-xxxx, then you would set an input mask forcing the input to be in that format.
A zip code, for example, is 5 or 9 characters in the U.S..... either 12345 or 12345-6789.
Therefore, you would use an input mask that looked like xxxxx | xxxxx-xxxx
This controls the user's input so that less validation is required later.
Input masks are mostly used to validate input that has a strict pattern that never changes. With Access validation rules you can validate more complex patterns.
Its not this website its either your computer or a virus.
How we can develop a database?
First of all u must khow for what u want to create DBMS. you must create Mini world and select some entities and distinguish their attributes. For khowing more about entities,attributes and their relations i suggest u read this book: Fundamental of database system written by: Ramez Elmasri & shamkant B. Navathe
What are protocols and why are they introduced in network communications?
A protocol is a set of rules describing some behavior. In order to communicate in a common manner, the sender and receiver have to agree on the "language" of communication.
A protocol states what those rules are, and because they are a standard, everyone agrees and knows what to expect.
What is the difference between data model and database model?
A database is a collection of tables that is used for some purpose (typically an application of some sort). A database model is a description of that database, and describes how the tables relate to each other. Typically, a model is designed first, then the actual database is implemented using the model as a blueprint.
Contrast of database and database system?
A database is simply a collection of pieces of information (data). A text file storing names and phone numbers is a database. A database management system (DBMS) is some software that manages the data within the database such as MySQL. Both the software and the database are considered together when thinking of a DBMS.
Which of the locations represent the greatest danger in encountering misinformation?
If you wanted to look up an article from the Chicago Tribune the best place to start would be
What is an example of how a database can be queried?
In an inventory database, for example, a purchasing query could be done for all merchandise at or near the inventory minimum of the particular item.
0 + 0 = 0
0 000 0000
1 + 1 = 2
1 001 0010
2 + 2 = 4
2 010 0100
3 + 3 = 6
3 011 0110
4 + 4 = 8
4 100 1000
5 + 5 = 10
5 101 1010
6 + 6 = 12
6 110 1100
7 + 7 = 14
7 111 1110
What are the components of relational database?
Table, index, trigger and column Table, index, trigger and column
What does the term record mean in relation to databases?
Record is more a term related to databases than to spreadsheets. However, as you can do some database work using a spreadsheet, then it can be a term used in a spreadsheet. A record in a database is a row of related data, such as the name, age, address and phone number of a person. If it is done in a spreadsheet, with each set of data on a separate row, it can be regarded as being a record.
What data type should use if want a field to contain a combination of numbers and text?
A text field can contain both numbers and text, so that is what you would use.