TEC 5323 Advanced Database Technology

Discussion of Week 7

 

Please use the discussion guidelines in Course Policy to formulate your response! The grading scale in the policy will be used for the discussions starting this week.

Discussion Topic:

The following SQL statements were used for a database session:

INSERT INTO parts (id, description, unitprice, onhand, reorder)
VALUES (6, 'Mouse', 49, 1200, 500);

INSERT INTO orders
VALUES (15, 3, '23-JUN-02', '23-JUN-02', NULL, 'F');

ROLLBACK;

COMMIT;

INSERT INTO items
VALUES (15, 1, 4,1);

INSERT INTO items
VALUES (15, 2, 5, 1);

COMMIT;

ROLLBACK;

 

Please explain what changes are made to the data tables? Note that there is only one correct answer.

 

When you are ready, please click Discussion Board to login.

Class Index

School of Technology
College of Business & Applied Sciences
Eastern Illinois University