preview

ASSIGNMENT 06

Decent Essays

Student ID: 1312311 Full name: Hùynh Văn Lâm ASSIGNMENT 06 1). Exercises 6.5.1: Write the following database modifications, based on the database schema Product (maker , model , type) PC (model , speed , ram , hd , rd , price) Laptop (model , speed , ram , hd , screen , price) Printer (model , color , type , price) of Exercise 5.2.1. Describe the effect of the modifications on the data of that exercise. a)Using two INSERT statements store in the database the fact that PC model 1100 is made by manufacturer C, has speed 1800, RAM 256, hard disk 80, a 20x DVD, and sells for $2499. ! INSERT INTO PC VALUES (1100, 1800, 256, 80, ‘20x DVD’, 2499) c) Delete all PC 's with less than 20 gigabytes of hard disk. DELETE FROM PC WHERE HD < …show more content…

UPDATE Classes SET bore = bore * 2.5, displacement = displacement/1.1 e) Delete all classes with fewer than three ships. DELETE FROM Classes WHERE class IN (SELECT class FROM Ships GROUP BY class HAVING COUNT(name) < 3) 2). Exercises 6.7.1: From the following base tables of our running example

Get Access