create database FIRMA_HOTELOWA
use database FIRMA_HOTELOWA;
show FIRMA_HOTELOWA;
select FIRMA_HOTELOWA;
select darabase FIRMA_HOTELOWA;
use FIRMA_HOTELOWA
create table HOTEL( Hotel_NO int primary key not null, NAME varchar(15) unique not null, ADDRESS varchar(15) not null ); INSERT into HOTEL(HOTEL_NO, NAME, ADDRESS) VALUES('1', 'GROSVENOR HOTEL', 'LONDON'), ('2', 'MERKURY HOTEL', 'POZNAN'), ('3', 'NovoTel', 'Poznan'); create table ROOM( ROOM_NO int not null, Hotel_No int not null, TYPE enum('s','d','f') not null unique, Price DECIMAL(10,2) not null unique, Primary key('ROOM_NO','HOTEL_NO') ); INSERT into ROOM(HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
create table HOTEL( Hotel_NO int primary key not null, NAME varchar(15) unique not null, ADDRESS varchar(15) not null ); INSERT into HOTEL(HOTEL_NO, NAME, ADDRESS) VALUES('1', 'GROSVENOR HOTEL', 'LONDON'), ('2', 'MERKURY HOTEL', 'POZNAN'), ('3', 'NovoTel', 'Poznan'); create table ROOM( ROOM_NO int not null, Hotel_No int not null, TYPE enum('s','d','f') not null unique, Price DECIMAL(10,2) not null unique, Primary key('ROOM_NO','HOTEL_NO') ); INSERT into ROOM(HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
INSERT into HOTEL(HOTEL_NO, NAME, ADDRESS) VALUES('1', 'GROSVENOR HOTEL', 'LONDON'), ('2', 'MERKURY HOTEL', 'POZNAN'), ('3', 'NovoTel', 'Poznan'); create table ROOM( ROOM_NO int not null, Hotel_No int not null, TYPE enum('s','d','f') not null unique, Price DECIMAL(10,2) not null unique, Primary key('ROOM_NO','HOTEL_NO') ); INSERT into ROOM(HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
create table ROOM( ROOM_NO int not null, Hotel_No int not null, TYPE enum('s','d','f') not null unique, Price DECIMAL(10,2) not null unique, Primary key('ROOM_NO','HOTEL_NO') ); INSERT into ROOM(HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
create table ROOM( ROOM_NO int not null, Hotel_No int not null, TYPE enum('s','d','f') not null unique, Price DECIMAL(10,2) not null unique, Primary key('ROOM_NO','HOTEL_NO') ); INSERT into ROOM(HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
create table ROOM(ROOM_NO int, Hotel_No int, TYPE enum('s','d','f') not null unique, Price DECIMAL(10,2) not null unique, Primary key('ROOM_NO','HOTEL_NO') ); INSERT into ROOM(HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
create table ROOM(ROOM_NO int, Hotel_No int, TYPE enum('s','d','f') not null unique, Price DECIMAL(10,2) not null unique, Primary key('ROOM_NO','Hotel_No') ); INSERT into ROOM(HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
create table ROOM(ROOM_NO int, Hotel_No int, TYPE enum('s','d','f') not null, Price DECIMAL(10,2) not null unique, PRIMARY KEY(ROOM_NO, HOTEL_NO) ); INSERT into ROOM(HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
INSERT into ROOM(ROOM_NO, HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
INSERT into ROOM(ROOM_NO, HOTEL_NO, TYPE, Price) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
INSERT into ROOM(HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
select FIRMA_HOTELOWA;
use FIRMA_HOTELOWA
INSERT into ROOM(HOTEL_NO, NAME, ADDRESS) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
INSERT into ROOM(ROOM_NO, HOTEL_NO, TYPE, PRICE) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00);
INSERT into ROOM(ROOM_NO, HOTEL_NO, TYPE, PRIVE) VALUES('1','1','D',100.00), ('2','1','S',50.00), ('3','1','F',150.00), ('4','1','F',200.00), ('1','2','S',100.00), ('2','2','S',100.00), ('3','2','D',250.00), ('4','2','F',300.00)
ALTER table ROOM change prive price;
ALTER table ROOM change prive price DECIMAL(10,2)
create table BOOKING( BOOK_NO int primary key auto_increment, HOTEL_NO int not null, ROOM_NO int not null, Guest_No int not null, Date_FROM date not null, Date_To date not null )
create table GUEST(GUEST_NO int primary key, NAME varchar(30) not null, ADDRESS varchar(50) not null)
INSERT INTO GUEST VALUES('1','KOWALSKI','Lesna 2, Warszawa'), ('2','STONE','NULL'), ('3','Schmit',' Alter Weg 110, 12345 Musterdorf'), ('4','Touchstone','49 Featherstone Street LONDON EC1Y 8SY UNITED KINGDOM '), ('5','Czerkarski','NULL'), ('6','Zacios','Poznan')
INSERT INTO BOOKING(HOTEL_NO,ROOM_NO,GUEST_NO,DATE_FROM,DATE_TO) Values('2','2','3',' 2015-05-01','2015-05-03'), ('2','2','3',' 2015-07-03','2015-07-06'), ('1','1','1','2015-09-14',' 2015-09-20'), ('2','2','2','2015-10-06','2015-10-08')
SELECT * FROM *;
SELECT * FROM HOTEL; SELECT * FROM ROOM; SELECT * FROM BOOKING; SELECT * FROM GUEST;
SELECT * FROM HOTEL; SELECT * FROM ROOM; SELECT * FROM BOOKING; SELECT * FROM GUEST;
use FIRMA_HOTELOWA
SELECT * FROM GUEST
Rozszerz  Wykonaj zapytanie ponownie  Edytuj  Wyjaśnij  Profilowanie Dodaj do zakładek  Baza danych  Czas zapytania
SELECT * FROM GUEST