مشروع فندق

بسم الله الرحمن الرحيم
اخواني الأعزاء
لدي برنامج صغير وهو عبارة عن جدول
PROMPT Creating Table 'H_ROOM_TYPE'
CREATE TABLE H_ROOM_TYPE
(TYPE_ID NUMBER(4) NOT NULL
,TYPE_DESC VARCHAR2(100) NOT NULL
,PRICE NUMBER(16,2) NOT NULL
)
PROMPT Creating Table 'H_ROOM'
CREATE TABLE H_ROOM
(ROOM_NO NUMBER(4) NOT NULL
,ROOM_NAME VARCHAR2(150) NOT NULL
,PERSON_NO NUMBER(4)
,TYPE_ID NUMBER(4) NOT NULL
)
/PROMPT Creating Table 'H_RESERVATION'
CREATE TABLE H_RESERVATION
(RES_NO NUMBER(4) NOT NULL
,RES_DATE DATE NOT NULL
,CUSTOMER_ID NUMBER(4) NOT NULL
,ROOM_NO NUMBER(4) NOT NULL
,DATE_IN DATE
,DATE_OUT DATE
)
/PROMPT Creating Table 'H_DISCOUNT'
CREATE TABLE H_DISCOUNT
(NUMBER_OF_NIGHTS NUMBER(4)
,DISCOUNT NUMBER(5)
)
/PROMPT Creating Table 'H_CUSTOMER'
CREATE TABLE H_CUSTOMER
(CUSTOMER_ID NUMBER(4) NOT NULL
,FIRST_NAME VARCHAR2(50) NOT NULL
,SECOND_NAME VARCHAR2(50)
,LAST_NAME VARCHAR2(50) NOT NULL
,PHONE VARCHAR2(12)

PROMPT Creating Primary Key on 'H_ROOM_TYPE'
ALTER TABLE H_ROOM_TYPE
ADD (CONSTRAINT HRE_PK PRIMARY KEY
(TYPE_ID))
/

PROMPT Creating Primary Key on 'H_ROOM'
ALTER TABLE H_ROOM
ADD (CONSTRAINT HRM_PK PRIMARY KEY
(ROOM_NO))
/



PROMPT Creating Primary Key on 'H_CUSTOMER'
ALTER TABLE H_CUSTOMER
ADD (CONSTRAINT HCR_PK PRIMARY KEY
(CUSTOMER_ID))
/




PROMPT Creating Foreign Key on 'H_ROOM'
ALTER TABLE H_ROOM ADD (CONSTRAINT
HRM_HRE_FK FOREIGN KEY
(TYPE_ID) REFERENCES H_ROOM_TYPE
(TYPE_ID))
/

PROMPT Creating Foreign Key on 'H_RESERVATION'
ALTER TABLE H_RESERVATION ADD (CONSTRAINT
HRN_HRM_FK FOREIGN KEY
(ROOM_NO) REFERENCES H_ROOM
(ROOM_NO))
/

PROMPT Creating Foreign Key on 'H_RESERVATION'
ALTER TABLE H_RESERVATION ADD (CONSTRAINT
HRN_HCR_FK FOREIGN KEY
(CUSTOMER_ID) REFERENCES H_CUSTOMER
(CUSTOMER_ID))
/



create table users
(USER_NO VARCHAR2(7) primary key,
PASS_WORD VARCHAR2(7),
USER_ARABIC_NAME VARCHAR2(70),
USER_ENGLISH_NAME VARCHAR2(70),
DEPARTMENT_ARABIC_NAME VARCHAR2(70),
DEPARTMENT_ENGLISH_NAME VARCHAR2(70));

واريد ان اعمل SYSTEM متكامل لهذه الجداول من شاشة الدخول بطلب اسم المستخدم واخاله الى الشاشة الرئيسية


ساعدوني بشدة بارك الله فيكم
في اسرع وقت جزاكم الله خير