Question

In: Accounting

(Accountinf Information system) List the three DBMS "languages" and describe who uses each and for what...

(Accountinf Information system)

List the three DBMS "languages" and describe who uses each and for what purpose.

Solutions

Expert Solution

Database languages are used for read, update and store data in a database. There are several such languages that can be used for this purpose

1.Data definition language (DDL)

                     It is used by designers, the purpose of using DDL is to create the    database, describes logical view for each user, and specifies record or field security constrains.

2. Data manipulation language (DML)

                 It is used by programmers, the purpose of using it is to change database content, including data element creations, updates, insertions, and deletions.

3. Data query language (DQL)

             It is used by IT users and decision makers, the purpose of using it is to integrate database, contains powerful, easy-to-use commands that enables users to retrieve, sort, order, and display data.


Related Solutions

What is the Database Management System (DBMS)? Give example companies who are using DBMS in Saudi...
What is the Database Management System (DBMS)? Give example companies who are using DBMS in Saudi Arabia? (write max 200 words with evidence in your own words)
What are the uses of DBMS and its benefits?
What are the uses of DBMS and its benefits?
Briefly describe the function of the DBMS in a database system.
Briefly describe the function of the DBMS in a database system.
Describe fraud. What are the three categories of fraud and list an example of each. Describe...
Describe fraud. What are the three categories of fraud and list an example of each. Describe the fraud triangle. List the key requirements of the Sarbanes-Oxley Act (SOX) List the components of the framework commonly used in corporations when analyzing their internal control systems: List the five common principles of Internal Control and give an explanation and example of each Name two reasons why internal control for cash is important. What does the term “cleared the bank” mean? What are...
What are the types of 5th generation languages write code in each of those languages and...
What are the types of 5th generation languages write code in each of those languages and please provide output also thank you
Describe each of the three attributes of the transnational HRM system.
Describe each of the three attributes of the transnational HRM system.
Who uses acounting information?
Who uses acounting information?
Who uses accounting information and for what do they use it? Outside of the company, who...
Who uses accounting information and for what do they use it? Outside of the company, who might have an interest in a company’s financial situation? Why do you think this - justify your answer.
Please list and describe the THREE major parts of a VHDL program. Describe each of them...
Please list and describe the THREE major parts of a VHDL program. Describe each of them and give an example.
1. List and describe the three different uses of statistics 2.The mean value of a random...
1. List and describe the three different uses of statistics 2.The mean value of a random variable that has a standard normal probability distribution is zero. Question 6 options: True False 3.Prior to exploring possible relations we need to know the difference between independent and convergent variables 4. Describe the four levels of measurement that are needed to determine what descriptive statistics to perform on a dataset. Describe when each measure is appropriate. 5.Compare and contrast the three measures of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT