Update operations tablecreate table customers int not null

Midterm Review



➢	Data redundancy and inconsistency
■		Multiple files, duplication of information in different files
➢
■
➢
➢
■		Integrity constraints (e.g. account balance > 0) become part
of program code
■

Transaction
❖	A transaction is a collection of operations that performs a single

remains in a consistent (correct) state despite system failures (e.g.,

concurrent transactions, to ensure the consistency of the database.


❖	Database Administrator (DBA) – coordinates all the activities of the database

❖	enterprise’s information resources and needs. Application programmers – write application programs. They interact with the

➢

accommodate per day.

➢

A staff member has an id, a given name, a phone number, and whether

➢

and time.

➢

The appointment has the status (if the patient presents at the specific date

Has

Date/Time		(1, 1)		History of
		(1, 1)		D

	Appointment
SID	Vaccine	Status	Phone	Smoker
id			Phone
id			No

❖


❖	Create Table


❖


❖	Insert into a table

VALUES (“202”, 10, "LG Screen 55inch ", 4000.00);

VALUES (201, 10, "LG Screen 55inch ", “four thousands”);

INSERT INTO order (OrderID, customer_id, item, price) VALUES (201, 10, "LG Screen 55inch ", 4000.00);

INSERT INTO order (OrderID, customer_id, item, price) VALUES (201, 10, "LG Screen 55inch ", 4000.00);


❖

SET Price = 5000

SQL


❖	Delete a row in a table