- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 1 (65.23 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 2 (60.08 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 3 (32.89 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 4 (39.32 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 5 (65.23 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 6 (35.59 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 7 (28.85 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 8 (13.81 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 9 (28.38 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 10 (24.36 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 11 (64.19 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 12 (12.98 KiB) Viewed 15 times
- Type Help Or H For Help Type C To Clear The Current Input Statement Mariadb None Use Hotelmanagement Sys 13 (32.42 KiB) Viewed 15 times
C:\Windows\System32\cmd.exe - mysql -uroot-p 6 rows in set (0.037 sec) MariaDB [Hotel Management Systems]> CREATE TABLE Manager ( -> Mid INT NOT NULL, -> fname VARCHAR(25) NOT NULL, -> 1name VARCHAR(25) NOT NULL, -> Memail VARCHAR(35), -> MphoneNo INT, -> Maddress VARCHAR(255), -> PRIMARY KEY(Mid)); Query OK, e rows affected (0.084 sec) MariaDB [HotelManagement Systems]> CREATE TABLE Employee( -> Eid INT NOT NULL, -> fname VARCHAR(25) NOT NULL, -> 1name VARCHAR (25) NOT NULL, -> Eemail VARCHAR(35), -> Eaddress VARCHAR(255), -> EphoneNo INT, -> salary INT, -> PRIMARY KEY(Eid)); Query OK, e rows affected (0.056 sec) MariaDB [HotelManagement Systems]> CREATE TABLE Client( -> Cid INT NOT NULL, -> fname VARCHAR (25) NOT NULL, -> 1name VARCHAR (25) NOT NULL, -> Cemail VARCHAR(35), -> CphoneNo INT, -> PRIMARY KEY(Cid)); Query OK, e rows affected (0.124 sec) MariaDB [HotelManagement Systems ]> CREATE TABLE Booking( TNT NOT NULL,
-> fname VARCHAR (25) NOT NULL, -> Iname VARCHAR (25) NOT NULL, -> Cemail VARCHAR(35), -> CphoneNo INT, -> PRIMARY KEY(Cid)); Query OK, e rows affected (0.124 sec) MariaDB [HotelManagement Systems]> CREATE TABLE Booking -> Bookid INT NOT NULL, -> roomNo INT, -> TranDate DATE, -> PRIMARY KEY(Bookid), -> FOREIGN KEY(numRooms) REFERENCES Hotel (numRooms)); ERROR 1072 (42000): Key column 'numRooms' doesn't exist in table MariaDB [HotelManagement Systems]> dest Bookings; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Mariace server version for the right sy at line 1 MariaDB [Hotel Management Systems]> desc Bookings; doesn't exist ERROR 1146 (42502): Table 'hotelmanagementsystems.bookings' MariaDB [HotelManagement Systems]> CREATE TABLE Payment( ->payid INT NOT NULL, -> TranDate DATE, ->TransNo VARCHAR(255), -> status VARCHAR(30), -> PRIMARY KEY(payid), ->CREATE TABLE Booking (;;;;;;;gbhfber ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Pariace server version for the right oking(' at line 7 ERROR: No query specified ERROR: No query specified specified
C\Windows\System32\cmd.exe - mysql -uroot-p MariaDB [HotelManagement Systems]> CREATE TABLE booking ( -> bookID INT, -> numRooms INT, ->date DATE, -> PRIMARY KEY(bookID), FOREIGN KEY(numRooms) REFERENCES hotel (numRooms)); ERROR 1005 (HYBee): Can't create table hotelmanagementsystems. "booking (errno: 150 "Foreign key constraint is incorrectly formed") MariaDB [HotelManagement Systems]> ALTER TABLE hotel -> ADD UNIQUE (numRooms); Query OK, 8 rows affected (0.183 sec) Records: 8 Duplicates: @ Warnings: @ MariaDB [HotelManagement Systems]> CREATE TABLE booking( -> bookID INT, -> numRooms INT, ->date DATE, -> PRIMARY KEY(bookID), FOREIGN KEY(numRooms) REFERENCES hotel (numRooms)); Query OK, 8 rows affected (8.322 sec) MariaDB [HotelManagement Systems]> CREATE TABLE payment ( -> payID INT, -> bookID INT, ->date DATE, ->transactionNO VARCHAR(55), ->status VARCHAR(25), -> PRIMARY KEY(payID), FOREIGN KEY(book ID) REFERENCES booking (book ID)); Query OK, 8 rows affected (0.846 sec) MariaDB [HotelManagement Systems]> desc hotel ->; | Field | Type | Null | Key | Default | Extra | Hid int(11) NO PRI NULL Hname | varchar(35) NO NULL I address I varchar(255) YES NULL numRooms | int(11) NO UNT NULL 4 rows in set (8.091 sec) MariaDB [HotelManagement Systems]> desc owner; | Field | Type Null | Key | Default | Extra |
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> USE HotelManagement Systems; Database changed MariaDB [HotelManagement Systems]> DESC Hotel; | Field | Type | Null | Key | Default | Extra | | Hid | int (11) NO PRI NULL | varchar(35) NO Hname address NULL NULL numRooms int(11) varchar(255) | YES I NO NULL 4 rows in set (0.069 sec) MariaDB [HotelManagement Systems ]> DESC Owner; | Field | Type | Null | Key | Default | Extra | Oid int (11) NO PRI NULL NULL NO fname varchar(25) NULL 1name NO varchar(25) NULL email YES varchar(35) NULL YES int (11) phoneNo NULL YES varchar(255) Oaddress 6 rows in set (0.037 sec) MariaDB [HotelManagement Systems]> CREATE TABLE Manager ( -> Mid INT NOT NULL, -> fname VARCHAR(25) NOT NULL, -> 1name VARCHAR (25) NOT NULL, MORCHAR(35), +-
CAWindows\System32cmd.exe-mysql-root-p 4 rows in set (0.091 sec) MariaDB [HotelManagement Systems]> desc owner; | Field I Type | Null Key Default | Extra | Oid NO PRI NULL int(11) varchar(25) fname NO 1 NULL Iname varchar(25) NULL INO 1 YES email varchar(35) NULL phoneNo int(11) YES NULL Oaddress varchar(255) | VES | NULL 6 rows in set (0.187 sec) MariaDB [HotelManagement Systems]> desc manager; | Field | Type Null | Key Default | Extra | Mid NO PRI NULL int(11) varchar(25) frame NO NULL NO NULL Iname | Memail I varchar(25) Ivarchar(35) VES NULL | MphoneNo | int(11) YES NULL Maddress varchar(255) YES NULL 6 rows in set (0.884 sec) MariaDB [HotelManagement Systems]> desc employee; | Field I Type | Null | Key | Default | Extra | Eid NO PRI NULL int(11) varchar(25) frame NO NULL Iname varchar(25) NO NULL Eemail YES 1 NULL varchar(35) varchar(255) Eaddress YES NULL int(11) YES I NULL EphoneNo salary int(11) YES | NULL 7 rows in set (0.075 sec) MariaDB [HotelManagement Systems]> desc client; 1
C\Windows\System32\cmd.exe-mysql-uroot-p MariaDB [HotelManagement Systems]> desc client; Field | Type | Null | Key | Default | Extra | NO PRI NULL Cid fname NULL | 1name | int(11) varchar(25) NO varchar(25) NO varchar(35) YES NULL | Cemail NULL | CphoneNo | int(11) | YES NULL 5 rows in set (0.101 sec) MariaDB [HotelManagement Systems]> desc booking -> | Field | Type Null | Key | Default | Extra | bookID | int(11) | NO PRI NULL VES | MUL NULL | numRooms | int(11) | date | date | YES NULL 3 rows in set (0.025 sec) MariaDB [HotelManagement Systems]> desc payment; Field | Type | int (11) pay ID | bookID | int(11) | date | date | transactionNO | varchar(55) | status | varchar(25) | YES 5 rows in set (8.834 sec) Maria08 [HotelManagement Systems]> | Null | Key | Default | Extra NO PRI NULL YES MUL NULL YES | NULL YES! NULL NULL
CWindows System32\cmd.exe mysql-root-p Server version. 10.4.22-Maria08 mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, Maria Corporation Ab and others. Type 'help;' or 'h' for help. Type 'le' to clear the current input statement. Maria00 [(none)]> USE Hotel Management Systems; Database changed MariaDB [HotelManagement Systems]> INSERT INTO hotel (Hid, Hame, address, numRooms,city) VALUES ('1801', 'Crown Plaza", "al Ma'Adi Road, Al Corniche, Jeddah 21443","50", "3 eddah');
0 Hotel Hid 1001 1002 1003 Hilton 1004 1005 Hname Crowne Plaza. Movenpick address al Ma'Adi Road, Al Corniche, Jeddah 21443 King Abdul Aziz Rd, Abraj Al Bait, Mecca 21955 6623 Eastern Ring Rd, Ghirnatah, Riyadh 13241 Casablanca St-Garhoud - Dubai - United Arab Emirates Casablanca Crowne Plot 29, Arkan Plaza Zayed Entrance, Sheikh Zayed Plaza City, Giza Governorate 12588, Egypt city Jeddah Mecca Riyadh Dubal sheikh zaved numRoo ms 50 I 200 450 300 100 From d quapen
CWindows\System32andese mysql-root-p "Mecca'); MariaDB [HotelManagement Systems]> INSERT INTO hotel VALUES ("1002", "Movenpick", "King Abdul Aziz Rd 21955', Query OK, 1 row affected (0.030 sec) Mariace [HotelManagement Systems]> INSERT INTO hotel VALUES ("1003", "Hilton, 4623 Eastern Ring Rd 13241", "450", "Riyadh'); Query OK, 1 row affected (0.011 sec) Maria00 [HotelManagement Systems]> INSERT INTO hotel VALUES ('1004", "Casablanca", "Casablanca St', '300', 'Dubai'); Query OK, 1 row affected (0.010 sec) Mariace (Hotel Managementsystems]> INSERT INTO hotel VALUES ('1885", "Crown Plaza', 'Arkan Plaza Zayed Entrance 12588', '100', 'sheikh zayed'); Query OK, 1 row affected (0.016 sec) Mariacs [HotelManagementsystens]> SELECT FROM hotel; | Hid Hame address nunRooms city Crown Plaza Al Corniche 21443 58 Jeddah King Abdul Aziz Rd 21955 200 Mecca 1001 1002 Movenpick 1003 Hilton 1004 Casablanca 1005 Crown Plaza 450 Riyadh 6623 Eastern Ring Rd 13241 Casablanca St 300 Dubal Arkan Plaza Zayed Entrance 12588 100 sheikh zayed 5 rows in set (0.001 sec) MariaDB [HotelManagement Systens]>
C:\Windows\System32\cmd.exe mysql -uroot -p 6 rows in set (0.037 sec ) MariaDB [Hotel Management Systems]> CREATE TABLE Manager ( -> Mid INT NOT NULL, -> fname VARCHAR(25) NOT NULL, -> 1name VARCHAR(25) NOT NULL, -> Memail VARCHAR(35), -> MphoneNo INT, -> Maddress VARCHAR(255), -> PRIMARY KEY(Mid)); Query OK, e rows affected (0.084 sec) MariaDB [HotelManagement Systems]> CREATE TABLE Employee( -> Eid INT NOT NULL, -> fname VARCHAR (25) NOT NULL, -> 1name VARCHAR (25) NOT NULL, -> Eemail VARCHAR(35), -> Eaddress VARCHAR(255), -> EphoneNo INT, -> salary INT, -> PRIMARY KEY(Eid)); Query OK, e rows affected (0.056 sec) MariaDB [HotelManagement Systems]> CREATE TABLE Client( -> Cid INT NOT NULL, -> fname VARCHAR (25) NOT NULL, -> 1name VARCHAR (25) NOT NULL, -> Cemail VARCHAR(35), -> CphoneNo INT, -> PRIMARY KEY(Cid)); Query OK, e rows affected (0.124 sec) CREATE TABLE Booking(
MariaDB [HotelManagement Systems]> CREATE TABLE booking( -> bookID INT, -> numRooms INT, ->date DATE, -> PRIMARY KEY(bookID), FOREIGN KEY(numRooms) REFERENCES hotel (numRooms)); Query OK, 8 rows affected (e.322 sec) MariaDB [HotelManagement Systems]> CREATE TABLE payment ( ->payID INT, -> bookID INT, ->date DATE, ->transactionNO VARCHAR(55), ->status VARCHAR(25), -> PRIMARY KEY(payID), FOREIGN KEY(bookID) REFERENCES booking (book ID)); Query OK, e rows affected (0.046 sec).
Text ↓ ↓00 急+ Zipcode City Lname 0000 Email Name Quantity Address Address State Salary Frame Frame Room num Date Room Phone num Hotel Hotel id Lname Manager Phone Nam Reservation Clients Book Booking Manage Phone num Salary Bookingid Pay Frame Owner Salary Salary Le Address Email Employee Phone num Phone num Email Owner id Payment 944 Status Transactiondate (Transaction num