Briefly describe four advantages of a dbms

Assignment Help Database Management System

Reference no: EM132218863

Task 1

Find, read, cite and reference several sources for each of the following: DBMS advantages, and DBMS functionality.

In your own words:

a. Briefly describe four advantages of a DBMS.

b. Briefly describe four functions of a DBMS.

Task 2

Find, read, cite and reference several sources for each of the following three SQL statements.

In your own words:

a. Briefly describe an SQL DML statement for storing new data into a table.

b. Briefly describe an SQL DML statement for changing existing data in a table.

c. Briefly describe an SQL DML statement for retrieving existing data from a table.

Task 3

For this task you need to create two original tables, i.e., the table names, column names and row data must be created by yourself. Your two tables shall be linked by a foreign key and contain several columns and rows. For example, the following two tables are linked by the foreign key WINEMAKER_ID in the WINE table.

2153_Data table.jpg

• Include your two original tables in your report. You cannot use WINEMAKER and WINE.

• Choose any 2 of the following subtasks from (a), (b), (c) and (d).

• Find, read, cite and reference several sources about your 2 chosen subtasks.

• Use your tables to assist you in answering your 2 subtasks. For example, you might like to show the contents of your tables after attempting to delete/update a record.

(a) ON DELETE RESTRICT

i. When deleting a record from a parent table, in your own words, briefly describe the consequences of specifying ON DELETE RESTRICT on a foreign key in a child table. For example, describe what happens when trying to delete the record containing Penfolds, or the one containing Barrabool Hills.

ii. When deleting a record from a parent table, in your own words, briefly describe the consequences of not specifying ON DELETE RESTRICT.

(b) ON DELETE CASCADE

i. When deleting a record from a parent table, in your own words, briefly describe the consequences of specifying ON DELETE CASCADE on a foreign key in a child table. For example, describe what happens when trying to delete the record containing Penfolds, or the one containing Barrabool Hills.

ii. When deleting a record from a parent table, in your own words, briefly describe the consequences of not specifying ON DELETE CASCADE.

i. When updating the primary key of a record in a parent table, in your own words, briefly describe the consequences of specifying ON UPDATE RESTRICT on a foreign key in a child table. For example, describe what happens when trying to update the primary key of the record containing Penfolds, or the one containing Barrabool Hills.

ii. When updating the primary key of a record in a parent table, in your own words, briefly describe the consequences of not specifying ON UPDATE RESTRICT.

(d) ON UPDATE CASCADE

i. When updating the primary key of a record in a parent table, in your own words, briefly describe the consequences of specifying ON UPDATE CASCADE on a foreign key in a child table. For example, describe what happens when trying to update the primary key of the record containing Penfolds, or the one containing Barrabool Hills.

ii. When updating the primary key of a record in a parent table, in your own words, briefly describe the consequences of not specifying ON UPDATE CASCADE.

Task 4

The Hypertext Transfer Protocol (HTTP) version 1.1 uses methods (verbs) to perform some actions. For example, your browser places theGET verb into a request packet and sends it via the internet to the Deakin web server. The web server reacts to the GET verb by sending back a response that contains the Deakin web page to your browser for rendering.

RESTful web services are becoming popular for storing and retrieving data over the internet. These REST services are based on HTTP verbs such as GET.

Explain how RESTful web services use HTTP verbs to store and retrieve data.

Reference no: EM132218863

Questions Cloud

Compare harvard architecture and von neumann architecture : Compare harvard architecture and Von Neumann architecture and also what is both architectureCompare harvard and von neumann architecture and process.

What are two risk factors for intimate partner violence : What are two risk factors for intimate partner violence? What are three community approaches to the prevention of unintentional injuries?

Explain the role of social workers in supporting clients : Consider the notion that an individual with a disability may feel primarily defined by his or her ability status. Also, consider the historical treatment.

Compare and contrast dsss and fhss : Compare and contrast DSSS and FHSS. Which one is more suitable than the other, and for what scenario?

Briefly describe four advantages of a dbms : Briefly describe four advantages of a DBMS. Briefly describe an SQL DML statement for storing new data into a table.

Briefly providing a reason for your opinion : The following are a number of different situations where there may be violations of the ethical principles. You are asked to state whether.

Is positive beta better than negative beta : A Beta factor represents risk in a financial instrument or commodity. Explain the reasons for changes in beta and explain if one should be more concerned.

Would you invest in the treasury bill or treasury note : The daily market transactions for treasury instruments are in the billions. The current average daily volume of "Treasuries" is approximately $150 billion.

Create or deploy secure solutions which prevent sniffing : Propose and test a low cost solution for small to medium sized businesses which will secure networked printer traffic.

User Account

All Pages