Week 4
Melissa Maxwell
Assignment

Chapter 8
1. CREATE TABLE CUSTOMER
CUST_NUM NUMBER PRIMARY KEY,
CUST_LNAME VARCHAR
CUST_FNAME VARCHAR
CUST_BALANCE NUMBER;

CREATE TABLE CUSTOMER_2
CUST_NUM NUMBER PRIMARY KEY,
CUST_LNAME VARCHAR,
CUST_FNAME VARCHAR

CREATE TABLE INVOICE
INV_NUM NUMBER PRIMARY KEY,
CUST_NUM NUMBER,
INV_DATE DATE,
INV_AMOUNT NUMBER);

2. INSERT INTO CUSTOMER VALUES (1000, ‘SMITH’, JEANNE’ 11050.11);
INSERT INTO CUSTOMER VALUES(1001, ‘ORTEGA’, ‘JUAN’ 840.92);

INSERT INTO CUSTOMER_2 VALUES(2000, ‘MCPHERSON’ ANNE’);
INSERT INTO CUSTOMER_2 VALUES(2001, ‘ORTEGA’ ‘JUAN’);
INSERT INTO CUSTOMER_2 VALUES(2002, ‘KOWALSKI’ ‘JAN’);
INSERT INTO CUSTOMER_2 VALUES(2003, ‘CHEN’ ‘GEORGE’);

INSERT INTO INVOICE VALUES(8000, 1000, ’23-APR-2008’ 235.89); …show more content…
Information system is a system that provides the conditions for data collection, storage, and retrieval. The information system helps transform data into information and allows for the management of both data and information. The purpose of information system is making good decisions to decision makers.

3 Web Links
DATABASE JOURNAL
This article talked about the 4 Vs: variety, volume, velocity, and veracity. These 4 V’s are known as Big Data. On the cloud, there are various ways to store the data. Azure Data Lake I a storage to store data as is and is a native form in the cloud. Azure Data can store data from all disparate sources and any existing IT system can easily interface with data store in Data Lake. Awesome article to learn about the 4 V’s and the Azure Data Lake.
CONCURRENCY CONTROL
In this article, I researched the FROM clause. The FROM clause derives a table from one or more other tables given in a comma-separated table reference list. A table reference can be a table named a JOIN construct, or complex combinations of these. The result of the FROM list is a virtual table that can be subject to transformations by the WHERE, GROUP BY, and HAVING clauses.
OPTIMISTIC LOCKING WITH CONCURRENCY IN