You will do the same exercise in MySQL and PostgreSQL

1. Create the table Student and Transcript

Student: studid, name, address, status

Primary key: studid

Transcript: studid, crscode, semester, grade

Primary key: studid, crscode, semester

Do not use foreign keys!

MySQL	PostgreSQL

2. Populate each table with at least 3 rows using INSERT INTO.

Provide the code and screenshots to support your work. Integrate the screenshots here.

MySQL	PostgreSQL

Exercise 6. Integrity Constraints and Transactions

A reservation transaction in an airline reservation system makes a reservation on a flight, reserves a seat on the plane, issues a ticket, and debits the appropriate credit card account. Assume that one of the integrity constraints of the reservation database is that the number of reservations on each flight does not exceed the number of seats on the plane. (Of course, many airlines purposely overbook and so do not use this integrity constraint).

Explain how transactions running on this system might violate each of the following properties. Provide an example for each property.

Atomicity

Consistency

Isolation

Durability

Atomicity
Consistency
Isolation
Durability