View difference between Paste ID: za2qNLh1 and ckz8UcL5

 Hotel: Class for managing the branch hotel, and contact of each hotel
-a.	Hotel_ID: is a code name for branch hotel
+a.	hotelID: is a code name for branch hotel
-b.	name: branch hotel name
+b.	hotelName: branch hotel name
-c.	manager_ID: shows the Staff ID of manager of the branch hotel
+c.	hoteManagerID: shows the Staff ID of manager of the branch hotel
-d.	address: information of the branch hotel
+d.	hotelAddress: information of the branch hotel
-e.	phoneNo: the contact number of each hotel
+e.	hotelPhone: the contact number of each hotel
 
 Employee: Class to manage the information of the employee in each branch hotel.
-a.	Staff_ID: code for each staff
+a.	employeeID: code for each staff
-b.	Hotel_ID: identify which branch hotel the employee worked for
+b.	hotelID: identify which branch hotel the employee worked for
-c.	name: Employee 's name
+c.	employeeName: Employee 's name
-d.	position: the work of employee (Receptionist, accountant, manager, cleaner,…)
+d.	employeePosition: the work of employee (Receptionist, accountant, manager, cleaner,…)
-e.	salary: the monthly salary of the employee
+e.	employeeSalary: the monthly salary of the employee
-f.	phoneNo: the contact number
+f.	employeePhone: the contact number
-g.	address: the home address of employee
+g.	employeeAddress: the home address of employee
 
 Customer: Class to manage the information of the customer in each hotel. In order to provide privacy for the customer, we only collect necessary identification information.
-a.	Customer_ID: an ID that was given to customer when booking and check in (may use identification number)
+a.	customerID: an ID that was given to customer when booking and check in (may use identification number)
-b.	name: Customer's name
+b.	customerName: Customer's name
-c.	phoneNo: the contact number
+c.	customerPhone: the contact number
-d.	address: the home address of customer (in case of return missing luggage, etc)
+d.	customerAddress: the home address of customer (in case of return missing luggage, etc)
 
 Room: The table of rooms available in hotels
-a.	Room_ID: The room code (including the hotel indication, floor and room number, for example: E308 is the 8th room on 3rd floor of Hotel E)
+a.	roomID: The room code (including the hotel indication, floor and room number, for example: E308 is the 8th room on 3rd floor of Hotel E)
-b.	Hotel_ID: the branch hotel that have the room
+b.	hotelID: the branch hotel that have the room
-c.	RoomType: the type of the room
+c.	roomType: the type of the room
-d.	price: price per day
+d.	roomPrice: price per day
-e.	State: reserved (1) or empty (0), the room state will be changed automatically when there is a check in or check out.
+e.	state: reserved (1) or empty (0), the room state will be changed automatically when there is a check in or check out.
 
 Booking: This table manage the booking record and the current customer in the hotel also
-a.	Booking_ID: The booking code auto increase from 1
+a.	bookingID: The booking code auto increase from 1
-b.	Customer_ID: ID of the customer made the booking
+b.	customerID: ID of the customer made the booking
-c.	Room_ID: ID of the booked room
+c.	roomID: ID of the booked room
-d.	Hotel_ID: ID of the hotel
+d.	hotelID: ID of the hotel
-e.	BookingDate: the date the booking is made
+e.	bookingDate: the date the booking is made
-f.	CheckinTime: The time the customer check in, get updated by receptionist
+f.	checkInTime: The time the customer check in, get updated by receptionist
-g.	CheckoutTime: The time the customer check out, get updated by receptionist
+g.	checkOutTime: The time the customer check out, get updated by receptionist
 
 ServiceType: The table of types of service and price so that we can easily add new service or change the price.
-a.	ServiceType: Laundry, Served Food and Drink, etc
+a.	serviceType: Laundry, Served Food and Drink, etc
-b.	price: the price of service
+b.	servicePrice: the price of service
 
 Service: The table stores the records of all the services with amount detail and Customer ID for later payment
-a.	Service_ID: The service code auto increase from 1
+a.	serviceID: The service code auto increase from 1
-b.	Customer_ID: ID of the customer requests the service
+b.	customerID: ID of the customer requests the service
-c.	Time: Time of service
+c.	time: Time of service
-d.	ServiceType: Type of service
+d.	serviceType: Type of service
 e.	quantity: quantity of service(multiply with price of Service Type)
-f.	ServiceFee: calculated automatically
+f.	serviceFee: calculated automatically
-g.	State: Paid (1) or Unpaid (0)
+g.	state: Paid (1) or Unpaid (0)
 
 Payment: The payment bill of customer, which is paid by the Check out time
-a.	BillNumber:
+a.	billNumber:
-b.	Customer_ID: we can extract the customer data from id
+b.	customerID: we can extract the customer data from id
-c.	RoomFee: calculated by the Check out time
+c.	roomFee: calculated by the Check out time
-d.	TotalService Fee: calculated from service during the time customer in the hotel
+d.	totalServiceFee: calculated from service during the time customer in the hotel
-e.	TotalPayment: Total sum of Room Fee and Service Fee
+e.	totalPayment: Total sum of Room Fee and Service Fee
 
 III/ Implementation:
 CREATE TABLE Hotel (
-Hotel_ID	nchar(10)	PRIMARY KEY,
+hotelID			nchar(10)	PRIMARY KEY,
-h_name	nchar(20),
+hotalName		nchar(20),
-manager_ID	nchar(10),
+hotelManagerID	nchar(10),
-address	nchar(20),
+hotelAddress		nchar(20),
-phoneNo	nchar(20));
+hotelPhone		nchar(20));
 
 CREATE TABLE Customer (
-Customer_ID	nchar(10)	PRIMARY KEY,
+customerID		nchar(10)	PRIMARY KEY,
-name		nchar(20)	not null,
+customerName	nchar(20)	not null,
-phoneNo	nchar(20),
+customerPhone	nchar(20),
-address	nchar(20));
+customerAddress	nchar(20));
 
 CREATE TABLE Employee (
-Staff_ID	nchar(10)	PRIMARY KEY,
+employeeID		nchar(10)	PRIMARY KEY,
-Hotel_ID	nchar(10)	not null,
+hotelID			nchar(10)	not null,
-e_name	nchar(20)	not null,
+employeeName	nchar(20)	not null,
-position	nchar(15),
+employeePosition	nchar(15),
-salary		real,
+employeeSalary	real,
-phoneNo	nchar(20),
+employeePhone	nchar(20),
-address	nchar(20),
+employeeAddress	nchar(20),
-FOREIGN KEY (Hotel_ID)	REFERENCES Hotel);
+FOREIGN KEY (hotelID)	REFERENCES Hotel);
 
 CREATE TABLE Room (
-Room_ID	nchar(10)	 PRIMARY KEY,
+roomID	nchar(10)	 PRIMARY KEY,
-Hotel_ID	nchar(10)	not null,
+hotelID		nchar(10)	not null,
-State		binary,
+state		binary,
-RoomType	nchar(20),
+roomType	nchar(20),
-price		real,
+roomPrice	real,
-FOREIGN KEY (Hotel_ID)	REFERENCES Hotel );
+FOREIGN KEY (hotelID)	REFERENCES Hotel );
 
 CREATE TABLE Booking (
-Booking_ID	nchar(10)	PRIMARY KEY AUTO_INCREMENT,
+bookingID	nchar(10)	PRIMARY KEY AUTO_INCREMENT,
-Customer_ID	nchar(10)	not null,
+customerID	nchar(10)	not null,
-Room_ID	nchar(10)	not null,
+roomID	nchar(10)	not null,
-Hotel_ID	nchar(10)	not null,
+hotelID		nchar(10)	not null,
-BookingDate	datetime,
+bookingDate	datetime,
-CheckinTime	datetime,
+checkInTime		datetime,
-CheckoutTime		datetime,
+checkOutTime		datetime,
-FOREIGN KEY (Customer_ID)	REFERENCES Customer
+FOREIGN KEY (customerID)		REFERENCES Customer
-FOREIGN KEY (Room_ID)		REFERENCES Room,
+FOREIGN KEY (roomID)		REFERENCES Room,
-FOREIGN KEY (Hotel_ID)		REFERENCES Hotel);
+FOREIGN KEY (hotelID)		REFERENCES Hotel);
 
 CREATE TABLE ServiceType (
-ServiceType	nchar(20) 	PRIMARY KEY,
+serviceType	nchar(20) 	PRIMARY KEY,
-ServicePrice	real);
+servicePrice	real);
 
 CREATE TABLE Service (
-Service_ID	nchar(10) PRIMARY KEY AUTOINCREMENT,
+serviceID	nchar(10) PRIMARY KEY AUTOINCREMENT,
-Customer_ID	nchar(10),
+customerID	nchar(10),
-Time		datetime,
+time		datetime,
-ServiceType	nchar(20),
+serviceType	nchar(20),
 amount	int;
-ServiceFee	real,
+serviceFee	real,
-State		binary,
+state		binary,
-FOREIGN KEY (RoomType)	REFERENCES Room,
+FOREIGN KEY (roomType)	REFERENCES Room,
-FOREIGN KEY (Hotel_ID)	REFERENCES Hotel);
+FOREIGN KEY (hotelID)	REFERENCES Hotel);
 
 CREATE TABLE Payment (
-BillNumber	nchar(10) PRIMARY KEY AUTOINCREMENT,
+billNumber	nchar(10) PRIMARY KEY AUTOINCREMENT,
-Customer_ID	nchar(10),
+customerID	nchar(10),
-RoomFee	real,
+roomFee	real,
-TotalServiceFee	real,
+totalServiceFee	real,
-TotalPayment		real,
+totalPayment		real,
-FOREIGN KEY (Customer_ID)	REFERENCES Payment);
+FOREIGN KEY (customerID)	REFERENCES Payment);