أخواني ضروري وعاجل جداً أرجو مراجعة وتصحيح كود قاعدة البيانات

[الخريف]

أخواني ضروري وعاجل جداً أرجو مراجعة وتصحيح كود قاعدة البيانات التالية
مطلوب تسليمها اليوم

كود القاعدة موجود في الملف المرفق

CDDe.txt

تم تعديل 13 يناير 2010 بواسطة الخريف

[Ahmad.Hasan]

ما الخطأ بالتحديد ؟؟

[الخريف]

أشكر أخي PALI.ORACLE على سرعة الرد لأنني منتظر الردود بلهفة

أرفقت لكم الملف
أخى ما أدري ،،، كتبت القاعدة منذ زمن وأدخلت عليها بعض الاضافات وعندما أدرجتها في معالج SQL يظهر لي إيرور

مدري ويش السالفة ؟ ومطلوب أن أرسل القاعدة بالبريد اللاكتروني للجامعة اليوم أي بعد ساعات قليلة وأتمنى من أخواني أدراج الكود في معالج SQL وعمل المراجعة والتصحيح السريع ... لأنه أتوقع يكون خطأ بسيط

وجزاكم الله خيراً ،، وجعل ذلك في ميزان حسناتكم
 

CDDe.txt

تم تعديل 13 يناير 2010 بواسطة الخريف

[Ahmad.Hasan]

السلام عليكم
الجزء الأول:

Create Table Course (
Couse_Code  Varchar2(20),
Learner_No  Varchar2(20));

Alter Table Course Add Constraint Cours_No_Pk Primary Key (Couse_Code);

Insert  Into Course (Couse_Code, Learner_No) Values ('A2332', '1011');

Insert  Into Course (Couse_Code, Learner_No) Values ('B5446', '5678');

Insert  Into Course (Couse_Code, Learner_No) Values ('S3009', '1981');

Insert  Into Course (Couse_Code, Learner_No) Values ('E5433', '9081');

Insert  Into Course (Couse_Code, Learner_No) Values ('D4356', '2243');
/
--=====================================================================================================
Create Table Learner (
Learner_No  Varchar2(20),
Couse_Code  Varchar2(20),
Module_No   Varchar2(20));

Alter Table Learner Add Constraint Learner_Crse_Cod_Fk Foreign Key(Couse_Code) References Course;

Insert  Into Learner (Learner_No, Couse_Code, Module_No) Values ('1022', 'A2332', '23');

Insert  Into Learner (Learner_No, Couse_Code, Module_No) Values ('1023', 'B5446', '51');

Insert  Into Learner (Learner_No, Couse_Code, Module_No) Values ('1056', 'S3009', '65');

Insert  Into Learner (Learner_No, Couse_Code, Module_No) Values ('1043', 'E5433', '76');

Insert  Into Learner (Learner_No, Couse_Code, Module_No) Values ('1021', 'D4356', '11');

/
--====================================================================================================
Create Table Module (
Modules_No   Varchar2(20),
Module_Title Varchar2(100),
Couse_Code   Varchar2(20));


Alter Table Module Add Constraint Mod_Cors_Code_Fk Foreign Key (Couse_Code) References Course;

Insert  Into Module (Modules_No, Module_Title, Couse_Code ) Values ('23', 'MMS','A2332');

Insert  Into Module (Modules_No, Module_Title, Couse_Code ) Values ('51', 'CXX','B5446');

Insert  Into Module (Modules_No, Module_Title, Couse_Code ) Values ('65', 'WER','S3009');

Insert  Into Module (Modules_No, Module_Title, Couse_Code ) Values ('76', 'CDD','E5433');

Insert  Into Module (Modules_No, Module_Title, Couse_Code ) Values ('11', 'MVE','D4356');

/
--======================================================================================================

اعتذر لعدم التكمله لانشغالي بالعمل.

[الخريف]

جزاك الله خيراً أخي العزيز PALI.ORACLE
أشكرك جداً من أعماق قلبي

باقي فقط جدولين أخي إذا كان وقت يسمح ... والسموحه ..

تم تعديل 13 يناير 2010 بواسطة الخريف

[lolyloly]

Tabe building has wrong data value in room_no column you must chang it first

create table room
(room_no number(6),
location varchar2(100));

alter table room add constraint room_no_pk primary key(room_no);

Insert  into room (room_no , location )
Values ('005','SALALAH');

Insert  into room (room_no , location )
Values ('008','NIZWA');

Insert  into room (room_no , location )
Values ('011','ALBURIMY');

Insert  into room (room_no , location )
Values ('007','MARBAT');

Insert  into room (room_no , location )
Values ('012','RAYSOOT');


/
create table building
( residence_no number(6),
room_no number(6),
build_desc varchar2(100));

alter table building add constraint build_room_no_fk foreign key (room_no) references room;

Insert  into building (room_no , build_desc )
Values ('011','ALSAHAWA');

Insert  into building (room_no , build_desc )
Values ('034','ZUBAIR');

Insert  into building (room_no , build_desc )
Values ('065','BUSHAR');

Insert  into building (room_no , build_desc )
Values ('021','FANGA');

Insert  into building (room_no , build_desc )
Values ('076','SUHAR');
commit;
/

[Ahmad.Hasan]

السلام عليكم
هذا السكريبت كامل:

Create Table Course (
Couse_Code Varchar2(20),
Learner_No Varchar2(20));

Alter Table Course Add Constraint Cours_No_Pk Primary Key (Couse_Code);

Insert Into Course (Couse_Code, Learner_No) Values ('A2332', '1011');

Insert Into Course (Couse_Code, Learner_No) Values ('B5446', '5678');

Insert Into Course (Couse_Code, Learner_No) Values ('S3009', '1981');

Insert Into Course (Couse_Code, Learner_No) Values ('E5433', '9081');

Insert Into Course (Couse_Code, Learner_No) Values ('D4356', '2243');
/
--=====================================================================================================
Create Table Learner (
Learner_No Varchar2(20),
Couse_Code Varchar2(20),
Module_No Varchar2(20));

Alter Table Learner Add Constraint Learner_Crse_Cod_Fk Foreign Key(Couse_Code) References Course;

Insert Into Learner (Learner_No, Couse_Code, Module_No) Values ('1022', 'A2332', '23');

Insert Into Learner (Learner_No, Couse_Code, Module_No) Values ('1023', 'B5446', '51');

Insert Into Learner (Learner_No, Couse_Code, Module_No) Values ('1056', 'S3009', '65');

Insert Into Learner (Learner_No, Couse_Code, Module_No) Values ('1043', 'E5433', '76');

Insert Into Learner (Learner_No, Couse_Code, Module_No) Values ('1021', 'D4356', '11');
/
--====================================================================================================
Create Table Module (
Modules_No Varchar2(20),
Module_Title Varchar2(100),
Couse_Code Varchar2(20));


Alter Table Module Add Constraint Mod_Cors_Code_Fk Foreign Key (Couse_Code) References Course;

Insert Into Module (Modules_No, Module_Title, Couse_Code ) Values ('23', 'Mms','A2332');

Insert Into Module (Modules_No, Module_Title, Couse_Code ) Values ('51', 'Cxx','B5446');

Insert Into Module (Modules_No, Module_Title, Couse_Code ) Values ('65', 'Wer','S3009');

Insert Into Module (Modules_No, Module_Title, Couse_Code ) Values ('76', 'Cdd','E5433');

Insert Into Module (Modules_No, Module_Title, Couse_Code ) Values ('11', 'Mve','D4356');
--======================================================================================================
Create Table Room (
Room_No  Number(6),
Location Varchar2(100));

Alter Table Room Add Constraint Room_No_Pk Primary Key(Room_No);

Insert  Into Room (Room_No, Location) Values ('005','Salalah');

Insert  Into Room (Room_No, Location) Values ('008','Nizwa');

Insert  Into Room (Room_No, Location) Values ('011','Alburimy');

Insert  Into Room (Room_No, Location) Values ('007','Marbat');

Insert  Into Room (Room_No, Location) Values ('012','Raysoot');
--==============================================================================================
Create Table Building (
Residence_No Number(6),
Room_No      Number(6),
Build_Desc Varchar2(100));

Alter Table Building Add Constraint Build_Room_No_Fk Foreign Key (Room_No) References Room;

Insert  Into Building (Room_No, Build_Desc) Values ('011','Alsahawa');

Insert  Into Building (Room_No, Build_Desc) Values ('034','Zubair');

Insert  Into Building (Room_No, Build_Desc) Values ('065','Bushar');

Insert  Into Building (Room_No, Build_Desc) Values ('021','Fanga');

Insert  Into Building (Room_No, Build_Desc) Values ('076','Suhar');

موفق.