0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
What jobs involve using databases?
teaching at schools and car sales because they need to keep record of what they own places like schoolsand buisnesses. places like schoolsand buisnesses. car sales schools and buisnesses such as tescos, asda, and many more job centres so they know which jobs to offer to customers police need them to identify suspects who have commited a crime hotels so they know who is staying there and what rooms are spare child care
What is the difference between a method and a procedure?
A procedure is a set of prescribed actions or events that must be enacted or take place to achieve a certain result. A method is a style or set of assumptions with which one acts or achieves a goal. The scientific method, for example, is a set of actions that do not necessarily need to be followed so long as the basic assumptions behind the method are adhered. A recipe is an example of a procedure, meant to be followed exactly as prescribed.
Procedures and Methods in ProgrammingAssuming you are speaking about programming languages here. The term Method is used almost exclusively to refer to Object Oriented design. In a sense, a method is a specific type of procedure. For example, any discrete block of reusable code could be referred to as a procedure. In Object Oriented design, a Class contains Properties (essentially data elements) and Methods (procedures executed on those elements, like Get, Set, operator overloads for addition or subtraction, print, etc.) Unfortunately, every school of programming wants to have its own unique jargon. So there are way too many words to describe things that are functionally equivalent. More Information:Method refers to the way of solving a problem. Procedure on the other hand does not really refers to the way of solving a problem. There is usually a confusion here, when we say, 'the solution to this problem is to follow the procedure given'. However, we should always bear in mind that procedure only refers to a fixed pattern or way of doing things. It may involves many steps during its execution.Example: 'You must first complete A before proceeding to B and then C.'
When we say the method of solving a problem is to complete A, then follow by B and C, we are actually referring to procedure. Method thus covers the whole procedure of doing things.
Example, 'The method of solving this problem is to follow this procedure.'
From the above, we can see that method is wider in scope than procedure and procedure is only a subset of method.
Method can either be a generalized concept or a fixed way of doing things whereas procedure is always fixed and is never generalized. The following example illustrates that method can be a generalized concept.
'The only method (way) of becoming rich is to work very hard.' In this example, we cannot substitute the word method with procedure. Otherwise, it will sounds strange and does not make sense: 'The procedure of getting rich is to work very hard'.
A method may not be tried or tested before. It can be just an idea that has not been put to test. Thus, the end result of method may or may not work. Procedure on the other hand is usually formed only after being tried or tested. Procedure can be quite complicated and involves many steps of doing things. Example, the procedure of performing a surgery. The process has to be tried and tested to confirm that it can works in order to become a procedure to be followed in future practices.
What are the three uses of multimedia presentations?
- Easy to Communicate a group of people at same time
- easy to understand
- and a systematic way to represent your presentations.
What is the purpose of personal information data sheet?
Personal Information Data sheets (PID's) are commonly used as reference material by organizations and businesses to gather and store contact information for emrgency situations, mailings, billing and things of that nature. Some are quite basic wherein the information asked for is simply your name, address and phone number, whereas others are more complex, such as those used at hospitals where they might ask for a brief medical history as well as your insurance company information.
What are the trade-offs of trying to control an introduced species?
Trying to control an introduced species can keep the populations down on overpopulated creatures and keep the ecosystem stable. It can also be bad if the species gets over hunted and populations get low.
Why supermarkets use database?
Most systems have the following categories: - Barcode (which can be used as the key) - Manufacturer - Price - Cost - Quantity - Expiry date (sometimes, depending on the retailer and the product) - Some retailers maintain a separate product number, which frankly doesn't make sense. Since the Barcode is always a unique number.
How do you delete your webkinz file?
Well if your talking about on the zone you click on there name then press delete on the zone.If that's what you were talking about.
List the advantages and disadvantages of DBMS over conventional file system?
DBMS can have several advantages - I am just giving a few of them...
1. Sharing of information
2. Real time transactional processing
3. Historical track record for auditing and control
4. A good disaster recovery plan may save a business from bankruptcy
Here are some disadvantages
1. DBMS subjects a business to a risk in the loss of critical data in its electronic format it can be more readily stolen without proper security
2. The cost of a DBMS can be prohibitive for small enterprises as they struggle with cost justification for making the investment in the infrastructure
3. Improper use of the DBMS can lead to incorrect decision making as people take for granted the data is accurate as presented.
4. Datas can be stolen by careless of the password security.
What are the limitations of models?
models may look and act like the real thing but they are not...they do not function the same way as the real one does.models may look and act like the real thing but they are not...they do not function the same way as the real one does.
Is a table a collection of records for a single object?
A table in a database contains a collection of records (or rows). Each record contains one or more fields (or columns).
What is a city in the United States that starts with e?
There are no states that begin with an E, but in Colorado you can find Eagle, Edwards, Elizabeth, Englewood, Estes Park and Evergreen.
There is an Espanola in New Mexico.
Kansas has El Dorado, Emporia and Eureka.
Oklahoma has Edmond, El Reno, Elk City, Enid and Eufala.
1. Following are the different types of dbms
- MySQL
- Microsoft SQL Server
- MS Access
- Foxpro
- SAP
- dBASE
- Tibero 6
The data type of a database field determines the possible values that that field can hold. When you create a field in MS Access and assign it the Date/Time data type, than that field can only hold date and time values like 04-11-2008 17:51.
When you assign the Number data type and set the field length to "Long integer" that field can only hold whole numbers.
Text, Number and Date are the most common data types in Access. A more exotic data type is the Attachment data type, which can hold files or the Calculated data type which can hold a formula that calculates a result based on values from other fields.
What is the role of computer in scientific?
Computers have a very important role to play in research activities. It has become an essential tool for research whether it be for academic purpose or for commercial purpose. You can find all kinds of information on the Internet and you can even discuss research problems with people around the world. Computers has led the way to a globalised information portal that is the World Wide Web. By using www we can conduct primary as well as secondary research on a massive scale. Various computer programs and applications have eased our way into compiling our research process. For example MS office tools help us to organize data and handle quantitative as well as qualitative data. Inference and analysis is also easier to make by using a computer
When you might to use a slimline form factor?
When you have very little desk space, or need to tuck the computer into a tight corner or cabinet.
Or even if the computer is in plain view and you do not want everybody to see a huge PC in the middle of your living room
Queries are essentially powerful Filters. Queries allow you to decide what fields or expressions are to be shown and what information to be sought. Queries are usually based on Tables but can also be based on an existing Query. Queries allow you seek from very basic information through to much more complicated specifications. They also allow you to list information in a particular order, such as listing all the resulting records in Surname order for example.
Queries can select records that fit certain criteria. If you had a list of people and had a gender field you could use a query to select just the males or females in the database. The gender field would have a criteria set as "male" which means that when the query is run only records with "male" in the Gender field would be listed. For each record that meets the criteria the you could choose to list other fields that may be in the table like first name, surname, phone number, date of birth or whatever you may have in the database.Queries can do much more than just listing out records. It is also possible to list out totals, averages etc. from the data and do various other calculations. Queries can also be used to do other tasks, such as deleting records, updating records, adding new records, creating new tables and creating tabulated reports.
Sample DATA FLOW DIagram for inventory management system?
This is the diagram that shows where everything is going. You will need to make one up for your business to ensure accuracy.
Advantages of data communication?
1.Circutary becomes simpler than AC.
2.Highly resistive to noise as we are dealing with binary digits.
3.Highly secure.
4.Can travel long distances and can store data for long time.
5.AS we have regenerative repeaters & reconstruction filters in the receiver section we can extract original signal transmitted
6. Error correcting and detecting is easy.
7. A comman format is used for different kind of message signal such as speech signal and video signal.
8. Flexibility in configuring digital communication. digital hardware implimentation is flexible and permit the use of LSI. microprocessors anmd digital switches.
What is the difference between unary and binary operations?
UNARY AND BINARY
a unary operation is an operation with only one operand, i.e. an operation with a single input, or in other words, a function of one variable.
eg- * Increment: ++x, x++
* Decrement: −−x, x−−
* Address: &x
* Indirection: *x
* Positive: +x
* Negative: −x
* One's complement: ~x
* Logical negation: !x
* Sizeof: sizeof x, sizeof(type-name)
* Cast: (type-name) cast-expression
int i = 0;
printf (" %d \n %d ", i++, i++);
a binary operation is a calculation involving two operands.
What is data values in Microsoft Access?
A data item is an individual piece of data, such as one person's name or a price of a particular product or an account number of a particular bank account. It would be the value in one indvidual field in one individual record.
What are the drawbacks of procedure oriented programming languages?
Procedural programming is when an application executes a series of procedures.
In procedural programming, the user is unable to choose what the program does next. In OOP (Object oriented), the user can click on any button they want, but in procedural, it just executed the pre-set procedures, then ends.
How does a management information system work?
It is very important to effectively collect, process, and use information to carry out the tasks of; deciding what to stock in your shops, also producing receipts for purchased items, and to calculate pay for hourly paid employees. This is generally dealt with using a form or management information system. Management information systems (MIS) are a combination of hardware and software used to process information automatically. Commonly, MIS are used within organizations to allow many individuals to access and modify information. In most situations, the management information system mainly operates behind the scenes, and the user community is rarely involved or even aware of the processes that are handled by the system.
What is the ERA of data processing of Management Information System?
The five eras of Data processing starts with Mainframe computers, personal computers, client server, enterprise and cloud computing. Now the era goes in cloud computing.
