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 are the main function in sql?
SQL (Structured Query Language) is a language used in a SQL server to manage data (Query the data, insert, Update, Delete) as well as perform data manipulation (calculations, etc)
A trigger is executed automatically when database modification done.
pumping lemma states that any string in such a language of at least a certain length (called the pumping length), contains a section that can be removed, or repeated any number of times, with the resulting string remaining in that language.
A database stores information like names, address, dates of birth etc. When the database is being designed, headings for these things are create, to store the different parts. These are the fields. "Name" is a field, and it could have the fieldname "Name". The designer will often decide to break the name into a first name and a surname. In that case each field would need a different fieldname. They might use "Fname" and "Sname" for example. "DOB" is often used as the fieldname for the field to store Dates of Birth. When the designers are then working to do queries or other programming with the database, they will use the fieldnames to access the data.
1. DBMS Developers
2. Application Developers
3. DBA
4. End user
What does the prefix in disadvantages mean?
Zendaya and Bella thorne does not like each other they are both sellouts and losers so they suck Fail!
How can I protect my database from SQL injection attacks urgent please?
1. You need find all vulnerabilities in you appliacation, you can use a scanner such as WebCruiser - Web Vulnerability Scanner to detect it;
2. Then you need modify your application which handle the parameter, for exam, if you use the int variable id=10 , you should bind the id to a integer, if the submit parameter is not a integer, then refuse it; if you use a string variable, you need limit its length, and check if there is single quote or space in it.
3. Use scanner to Test it again.
How you can explain accounting is an information system?
Accounting is an information system for measuring, processing and communicating information that is useful in making economic decision.
Every business is conducted to make profit. Accounting knowledge is there to assist the business man to assess whether the business is making profit or loss. In accounting brings discipline on how to source money, how to spend and how much to save. Accounting ensures consistency in the treatment of various transactions. Accounting involves gathering of financial data, recording classifying, summarizing and communicate the results to the owners of the business, or to others allowed to receive this information.
Accounting should not be confused with Book keeping as Book keeping is the part of accounting concerned with recording of financial data. Book keeping is the process of recording data relating to accounting transactions in the books of accounts.
Drawing DFDs in Inventory control system?
process begins when the sales department places an order. then, the clerk in the warehouse fills up the information (number of items, delivery date and shipment details) and she filed a copy of sales order in inventory file. then she will have to check for the item availability. if there is availability, then the item is retrieved and shipment is scheduled. however, if inventory is not available, the sales department will be informed through out-of-stock notice
10 principles underlying system development database systems?
Principle 1 Get the System Users Involved, they are the most critical of the system. Not only will they give you great ideas, but this will help with buy in.
Principle 2 Use a Problem-Solving Approach, this should be the approach on all project using some variation of a problem solving approach.
Principle 3 Establish Phases and Activities
Principle 4 Document throughout Development
Principle 5 Establish Standards
Principle 6 Manage the Process and Projects
Principle 7 Justify Information Systems as Capital Investments
Principle 8 Don't be afraid to Cancel or Revise Scope
Principle 9 Divide and Conquer
Principle 10 Design systems for growth and change
What are the types of data transmission?
I) Packet Switching
II) Frame relay
iii) Fiber Disturbed Data Interference (FDDI)
iv) Asynchronous Transfer Mode (ATM)
v) Switched Hub Technology
vi) Synchronous Optical Network (SONET)
T-carrier system
What are the database answers for James river jewelry project on page 95?
suck my big balls for the answer
1)strong number
1 declare
2 n number(3);
3 fact number(3):=1;
4 rem number(3);
5 m number(3);
6 sum1 number(3):=0;
7 begin
8 dbms_output.put_line('enter a number');
9 n:=&n;
10 m:=n;
11 while(n>0) loop
12 rem:=mod(n,10);
13 for i in 1..rem loop
14 fact:=fact*i;
15 end loop;
16 sum1:=sum1+fact;
17 n:=trunc(n/10);
18 fact:=1;
19 end loop;
20 if(sum1=m) then
21 dbms_output.put_line(m' IS STRONG NUMBER');
22 else
23 dbms_output.put_line('IT IS NOT STRONG NUMBER');
24 end if;
25* end;
i want SAP shprt cuts in which web site i can get it. tell me the web address.
